FAA Civil Aviation Registry: The Federal Database Behind 700,000 Pilots and 300,000 Aircraft

The FAA Civil Aviation Registry maintains two of the most comprehensive public databases in US aviation — the Airmen Certification Database covering 700,000 active pilots with certificate type, ratings, and medical status, and the Aircraft Registration Database covering 300,000 registered civil aircraft with owner, make, model, and airworthiness information.

What the FAA Civil Aviation Registry is

The FAA Civil Aviation Registry is a division of the Federal Aviation Administration headquartered at the Mike Monroney Aeronautical Center in Oklahoma City, Oklahoma. Established under the Federal Aviation Act of 1958, the Registry is the federal agency responsible for maintaining the official record of all civil aircraft registered in the United States and all certificates issued to airmen — pilots, mechanics, dispatchers, and parachute riggers — operating within US jurisdiction.

The Registry administers two major databases of enduring public value. The Airmen Certification Database tracks every person holding a current airmen certificate, including certificate type, ratings, medical certificate status, and address of record. The Aircraft Registration Database tracks every civil aircraft holding a current US registration, including the owner of record, aircraft make and model, serial number, year of manufacture, and airworthiness classification. Both databases are public records under the Freedom of Information Act and are freely searchable through the FAA's online inquiry system at registry.faa.gov. Bulk data downloads are available through the FAA data portal at faa.gov, making both databases accessible for programmatic analysis without per-record query costs.

Together, the two databases answer the two most fundamental questions in civil aviation regulation: who is certified to fly, and what aircraft are authorized to fly. The Registry is the starting point for enforcement actions, accident investigations, airspace management, and every category of civil aviation transaction — from insurance underwriting to aircraft sales to investigative journalism.

Airmen Certification Database

The Airmen Certification Database records every individual holding a current airmen certificate issued by the FAA. As of the most recent quarterly release, approximately 700,000 airmen hold active certificates of some type, representing the universe of certificated aviation personnel operating legally within US airspace.

Certificate types span the full range of aviation roles. On the pilot side, the hierarchy runs from most basic to most advanced:

• Student Pilot — the entry-level certificate required to fly solo. Issued after a medical examination and basic knowledge test. Student pilots may not carry passengers and must be supervised by a flight instructor for all training flights until solo privileges are endorsed.
• Sport Pilot Certificate — a simplified certificate created in 2004 for operation of light-sport aircraft, which are limited to single-engine, fixed-gear aircraft under 1,320 pounds. Medical certification is replaced by a valid state driver's license. Sport pilots may not fly at night, in controlled airspace without specific endorsements, or in aircraft with more than two seats.
• Private Pilot Certificate (PPL) — the standard general aviation certificate. Requires a minimum of 40 flight hours, a written knowledge test, and a practical flight test administered by an FAA examiner or designated pilot examiner. PPL holders may carry passengers but may not be compensated for flight services with limited exceptions.
• Commercial Pilot Certificate (CPL) — requires 250 total flight hours and a more demanding practical test. CPL holders may be compensated for certain flight operations, including agricultural aviation, banner towing, survey work, and charter operations as first officer.
• Airline Transport Pilot Certificate (ATP) — the highest pilot certificate level. Requires 1,500 total flight hours following the Airline Transport Pilot Certification Act of 2010, which raised the requirement from 250 hours in the wake of the Colgan Air Flight 3407 accident. An ATP is mandatory for serving as pilot-in-command of Part 121 scheduled air carrier operations.
• Flight Instructor Certificate (CFI) — authorizes the holder to provide flight instruction and endorse students for certificates and ratings. CFIs hold an underlying pilot certificate (PPL or CPL) plus the instructor add-on. Instrument flight instructor (CFII) and multi-engine instructor (MEI) are separately endorsed ratings.
• Ground Instructor — authorizes classroom instruction and knowledge test endorsements without requiring flight hours. Subtypes include Basic Ground Instructor (BGI), Advanced Ground Instructor (AGI), and Instrument Ground Instructor (IGI).

Non-pilot airmen certificates include:

• Mechanic (A&P) — Airframe and Powerplant certificates, issued separately after written, oral, and practical tests administered by an FAA examiner. A&P mechanics are the backbone of general aviation maintenance.
• Repairman — a limited certificate issued to individuals performing maintenance on a specific aircraft, typically the builder of an amateur-built experimental aircraft.
• Parachute Rigger — required to pack parachutes for emergency use. Senior and Master Rigger levels exist.
• Aircraft Dispatcher — held by operations center personnel at Part 121 carriers who share responsibility with the captain for flight release decisions and in-flight monitoring.

Ratings and endorsements

Beyond the certificate itself, the database records ratings that expand or restrict certificate privileges. Key ratings include:

• Instrument Rating (IR) — authorizes flight in instrument meteorological conditions (IMC) under IFR flight plans. Requires additional training, a written test, and a practical test focused on attitude instrument flying and IFR procedure execution.
• Multi-Engine Rating (ME) — required to act as pilot-in-command of aircraft with more than one engine. Adds training in engine-out procedures and asymmetric thrust management.
• Type Ratings — required for specific large or turbojet-powered aircraft. Common type ratings include the B737 (Boeing 737 family), A320 (Airbus A320 family), CL65 (Bombardier CRJ series), and CE-525 (Cessna Citation family). Type ratings appear in the airmen database as part of the certificate record and are the mechanism by which airlines confirm a pilot's qualification on a specific aircraft type.

Medical certificates

Medical certification status is tracked in the airmen database under a separate medical certificate record. The FAA issues three classes of medical certificates:

• First Class Medical — required for ATP operations. Issued by FAA Aviation Medical Examiners (AMEs) after the most comprehensive physical examination. Requires vision correction to 20/20 distant, normal color vision, cardiac clearance, and no disqualifying medical conditions. Valid for 12 months for pilots under 40, 6 months for those 40 and over.
• Second Class Medical — required for commercial operations. Similar standards to First Class with slightly relaxed validity periods for non-ATP commercial operations.
• Third Class Medical — the minimum required for private pilot operations. Less stringent standards; valid for 60 months for pilots under 40, 24 months for those 40 and over.
• BasicMed — a simplified medical alternative created by the FAA Extension, Safety, and Security Act of 2016, effective May 2017. Pilots who held a valid medical certificate after July 14, 2006, may operate under BasicMed by completing a brief online course every 24 months and receiving a physical examination from any state-licensed physician every 48 months. BasicMed is valid for private pilot operations in aircraft under 6,000 pounds with no more than six seats, flying below 18,000 feet MSL at speeds not exceeding 250 knots. BasicMed has been adopted by tens of thousands of private pilots who previously struggled with the more demanding third-class medical standards.

The releasable airmen database published quarterly by the FAA includes home state, home city, gender, and certificate/rating information, but omits full street addresses to protect personal privacy. The full address of record is available for individual inquiries through the FAA registry but is not included in bulk downloads.

Aircraft Registration Database

The Aircraft Registration Database records every civil aircraft currently registered in the United States. As of the most recent monthly release, more than 300,000 civil aircraft hold active US registrations, making the US civil aviation fleet by far the largest in the world.

Every registered US civil aircraft receives an N-number— a unique alphanumeric identifier beginning with the letter N that serves as the aircraft's tail number and its primary identifier in all regulatory contexts. N-numbers appear physically on the aircraft fuselage and tail, on flight plans and ATC transponder squawk codes, in NTSB accident records, in FAA enforcement actions, and in air traffic control communications. The N-number is the universal join key across the federal aviation data ecosystem.

The aircraft registration record includes the following fields:

• N-Number — the registration identifier, 1 to 5 characters after the leading N (e.g., N12345, N1AB).
• Serial Number — the manufacturer's unique identifier for the specific airframe, used to track the aircraft through maintenance records and history independently of its N-number (which can be changed).
• Manufacturer Name and Model — the type certificate holder and model designation (e.g., CESSNA / 172S, PIPER / PA-28-181, CIRRUS / SR22).
• Year Manufactured — the production year. The age distribution of the US general aviation fleet is a consistent finding in fleet analysis: median aircraft age exceeds 40 years, as new aircraft production has never recovered to pre-1980 levels after product liability law changes suppressed manufacturing.
• Registrant Name and Address — the current owner of record, which may be an individual, a corporation, a trust, or a partnership. Aircraft held in trusts — a common ownership structure for tax and liability reasons — list the trust name and trustee address.
• Registration Status — active codes include Valid, Triennial (registration due for renewal under the triennial re-registration requirement established in 2010), and Expired. Deregistered aircraft carry their own status codes.
• Airworthiness Classification — the class of airworthiness certificate held by the aircraft: Standard, Experimental, Limited, Primary, Restricted, Special, or Light Sport.
• Aircraft Type Code — fixed wing single-engine, fixed wing multi-engine, rotorcraft, glider, balloon, blimp, or weight-shift control.
• Engine Type — reciprocating (piston), turboprop, turbojet, turbofan, turboshaft, ramjet, 2-cycle, 4-cycle, unknown, electric, or rotary.
• Kit-Built / Amateur-Built Flag — identifies aircraft built from kits or from scratch by individuals under FAA's amateur-built experimental category rules. These aircraft are constructed and maintained under looser regulatory requirements in exchange for the owner being the “primary builder.”

The full aircraft registration database is published as a ZIP file containing several related CSV tables. The primary MASTER.txt file contains one row per registered aircraft. Supporting files include ACFTREF.txt (aircraft type and engine codes), ENGINE.txt (engine reference data), and DEALER.txt (dealer certificate registrations). The database is updated monthly and available at faa.gov/licenses_certificates/aircraft_certification.

Pilot population trends

The US pilot population has undergone significant structural changes over the past three decades, and the airmen database is the primary source for tracking these trends.

Total certificated airmen of all types numbered approximately 770,000 as of 2023, but the active pilot subset is substantially smaller. Active pilots — those holding a current medical certificate or otherwise exercising certificate privileges — number approximately 450,000. The gap between total certificates on file and active pilots reflects the accumulation of lapsed certificates: the FAA does not cancel pilot certificates for inactivity alone, so the database includes tens of thousands of airmen who have not flown in years.

The certificate-type breakdown among active pilots (approximate, as of 2023) shows the shape of the training pipeline:

• Private Pilot: approximately 180,000 — the largest single category and the traditional entry point for those who fly for personal use
• Airline Transport Pilot: approximately 162,000 — reflecting the large commercial aviation sector
• Flight Instructor: approximately 120,000 — a large instructor pool enabling the training pipeline
• Commercial Pilot: approximately 93,000 — those qualified for compensation but below ATP minimums
• Student Pilot: population varies with training activity, roughly 70,000–90,000 at any given time
• Remote Pilot (Part 107): over 300,000 certificates issued since 2016 — the fastest-growing certificate category by far, reflecting the commercial drone industry's growth

The demographic composition of the pilot workforce is a recurring policy concern. Female pilots constitute approximately 8 percent of all certificated pilots, a figure that represents real growth from roughly 6 percent two decades ago but remains low relative to the general workforce and relative to other professional licenses. FAA diversity programs, military pilot pipelines, and scholarship initiatives from organizations like Women in Aviation International have sustained gradual improvement without producing dramatic change in the overall proportion.

The aging of the pilot workforce has attracted more immediate economic attention. The average age of a private pilot in the US is approximately 44 years, and the average age of ATP holders in commercial service skews older still. The mandatory retirement age of 65 for Part 121 first officers and captains — established by the Age 60 Rule and amended upward from 60 to 65 under the Fair Treatment for Experienced Pilots Act of 2007 — creates a predictable attrition pipeline. Regional airlines have faced acute pilot shortages driven by the ATP minimum hours requirement (raised from 250 to 1,500 by the Airline Transport Pilot Certification Act of 2010), mandatory retirement attrition, and the slow pipeline from student pilot to ATP-eligible commercial pilot. The average time from first solo to 1,500 hours is five to ten years for most civilian-trained pilots, creating a training cycle that cannot respond quickly to sudden demand increases.

Aircraft fleet composition

The US civil aircraft fleet registered in the FAA database reflects the full diversity of civil aviation, from single-engine training aircraft to corporate jets to experimental homebuilts. The 300,000+ registered civil aircraft break down roughly as follows:

General aviation accounts for approximately 200,000 aircraft — single-engine and multi-engine piston aircraft used for personal transportation, flight training, aerial photography, agricultural work, and recreational flying. Cessna is the most common manufacturer in the registry, led by the ubiquitous Cessna 172 Skyhawk (the most produced aircraft in history, with over 44,000 units built), Cessna 152, and Cessna 182 Skylane. Piper Aircraft is the second-largest manufacturer by registration count, led by the PA-28 Cherokee/Archer family and the PA-32 Saratoga line. Beechcraft — now a Textron brand alongside Cessna — is third, with the Bonanza series (manufactured continuously since 1947, the longest-running aircraft production program in history) and the Baron twin-engine line. Cirrus Aircraft, founded in 1984, has grown to be among the top five by active registrations, driven by the SR20 and SR22 composite aircraft with their integrated Cirrus Airframe Parachute System (CAPS).

For-hire commercial operations — charter, aerial work, on-demand air taxi — account for roughly 7,000 aircraft, many of which are also registered as general aviation aircraft and move between categories depending on the operating certificate under which they're flown on a given day.

Experimental and amateur-built aircraft number approximately 35,000 in the registry. This segment is the domain of the Experimental Aircraft Association (EAA), whose AirVenture fly-in at Oshkosh, Wisconsin, draws over half a million attendees annually. Popular kit-aircraft include the Van's Aircraft RV series (the most-built kit aircraft family, with thousands of completed examples), the Lancair and Columbia line, and numerous ultralight-derived designs. Experimental aircraft operate with significant regulatory flexibility: owners serve as their own maintenance authority, approved data requirements are relaxed, and operation is limited to non-commercial use. The tradeoff is a higher accident rate per flight hour than type-certificated aircraft.

Turbine-powered aircraft — turboprops and jets — number approximately 17,000 in the US registry. This category includes business jets (Gulfstream, Bombardier Challenger/Global, Cessna Citation, Dassault Falcon, Embraer Phenom/Praetor), turboprop singles and twins (Pilatus PC-12, Piper Meridian, King Air family), and regional turboprops (ATR 42/72, Dash-8/Q-series) operated by regional carriers.

Helicopters account for approximately 12,000 registered aircraft. The most common types include the Robinson R22 and R44 (dominant in flight training and personal use), Bell 206/407 (law enforcement, EMS, utility), Sikorsky S-76 (offshore oil, VIP transport), and Airbus H130/H145 (tour operations, EMS). The Robinson R22 has an outsized presence in accident statistics relative to its total numbers, reflecting its role in low-altitude training and the demanding autorotation procedures required at its weight class.

Electric aircraft are an emerging and growing category in the registry. Pipistrel (now Textron Aviation) and PC-Aero (Calin PC-Electric) aircraft have received type certificates or special airworthiness certificates. The FAA's Special Class category covers novel aircraft types without existing airworthiness standards, enabling experimental electric aircraft to earn registration while standards are developed. The 2020s have seen an explosion of electric vertical takeoff and landing (eVTOL) prototype registrations from companies including Joby Aviation, Archer Aviation, Wisk, and Lilium.

Drones — unmanned aircraft systems (UAS) — are tracked separately from the civil aircraft registry. The FAA's DroneZone system has processed over 900,000 drone registrations as of 2024, covering recreational and commercial UAS above 0.55 pounds. Commercial drone operators must also hold Part 107 Remote Pilot certificates tracked in the airmen database. The FAA's Remote ID rule, which took effect in 2023, requires most drones to broadcast identification and location information, creating a new layer of UAS tracking distinct from the traditional aircraft registry.

Law enforcement and investigative uses

The public accessibility of the FAA aircraft registration database has made it a standard tool for investigative journalism, law enforcement accountability reporting, and civil society monitoring of government surveillance operations.

The N-number lookup function at registry.faa.gov allows anyone to identify the registered owner of any aircraft from its tail number — a capability that has proven significant for tracking government surveillance aircraft. Beginning in the mid-2010s, reporting by BuzzFeed News and the Associated Press identified dozens of FBI and DEA surveillance aircraft operating over US cities by cross-referencing N-numbers observed by plane-spotters with FAA registration records. The registrations consistently pointed to shell companies — fictitious LLCs with names like “FVX Research” and “Execuair” — clustered at specific addresses, leading investigators to connect the dots between front companies and federal law enforcement aviation units.

The DEA's aviation fleet was documented through a combination of FAA registration data, flight tracking via ADS-B transponder data aggregated by FlightAware and FlightRadar24, and corporate registration records for the shell companies. The aircraft types favored by surveillance operations — Cessna 182Ts and 206s, Beechcraft King Airs, Pilatus PC-12s equipped with cell-site simulator technology and broadband intercept platforms — were identifiable through FAA registration records listing the manufacturer and model alongside the shell company owner.

The FBI's Cessna 182 surveillance aircraft operating over Baltimore during the 2015 unrest following the death of Freddie Gray became one of the highest-profile examples of FAA registry-based investigative journalism. The aircraft's N-number appeared in flight tracking databases; a registry lookup returned a shell company whose address matched other FBI aviation front entities. The reporting forced congressional scrutiny of federal surveillance flight programs and renewed debate about the use of front companies in FAA registrations, a practice that the FAA has explicitly declined to prohibit on the grounds that aircraft registration is a property record rather than an operator-identification system.

Beyond surveillance tracking, the aircraft database is a standard tool for:

• Aircraft accident investigation — NTSB investigators pull registration records as part of every investigation to establish the aircraft's ownership history and airworthiness certificate status at the time of the accident
• Title and lien searches — aircraft title companies search the FAA registry for encumbrances before any aircraft sale closes, analogous to a real estate title search
• Insurance underwriting — insurers verify aircraft registration status and airworthiness class as part of every policy application
• Flight tracking cross-reference — ADS-B aggregators like FlightAware and FlightRadar24 match transponder-broadcast N-numbers against the FAA registry to display aircraft make, model, and owner alongside the flight track in real time
• News and business reporting — corporate aircraft registrations identify which executives and companies operate private aircraft, useful for travel accountability reporting and corporate governance research

The NOTAM (Notice to Air Missions) system is a related public-access aviation data resource that identifies temporary flight restrictions (TFRs), airspace closures, and operational hazards. TFRs issued for VIP movements, including Presidential and Vice Presidential travel, create identifiable airspace restrictions that observers use to track official travel without disclosing specific travel itineraries — the FAA publishes the restriction without naming the specific dignitary, but the locations and timing create an inference chain that aviation enthusiasts routinely exploit.

Data access

The FAA provides multiple access pathways to the Registry's two major databases, ranging from individual record lookup to full bulk downloads.

Individual lookup. The FAA Aircraft Inquiry system at registry.faa.gov/aircraftinquiry allows lookup by N-number, serial number, or owner name. The airmen inquiry system at amsrvs.amsrvs.faa.gov/airmeninquiry allows lookup by name or certificate number. Both are free and require no account registration.

Releasable Airmen Database. The FAA publishes a quarterly bulk download of the releasable portion of the airmen database at faa.gov/licenses_certificates/airmen_certification. The download is a ZIP file containing multiple CSV files: PILOT_BASIC.csv covers pilot certificates, with fields for certificate type, rating, state, city, gender, and medical class. Companion files cover other certificate categories. The “releasable” designation reflects FAA Privacy Act redactions: home street addresses are omitted, but city, state, certificate type, and rating information are included.

Aircraft Registration Database. The full aircraft registration database is published monthly as a ZIP download at faa.gov/licenses_certificates/aircraft_certification. The primary MASTER.txt file contains the complete registration record for every civil aircraft. Supporting reference files decode the aircraft type and engine type codes. The download is typically 25–40 MB compressed and expands to several hundred MB in CSV form.

FAA Data Innovation Lab API. The FAA has progressively expanded machine-readable data access through its Data Innovation Lab at faa.gov/data_research. The Aviation Data and Analysis portal provides structured access to airmen statistics, fleet statistics, and aviation activity surveys. Data coverage includes the annual General Aviation and Part 135 Activity Survey (GAATA), which aggregates operational statistics — flight hours, fuel consumption, aircraft utilization — beyond what the registration and certification databases alone capture.

Python: downloading and analyzing the airmen certification database

The following script downloads the FAA Releasable Airmen database directly from the FAA's bulk download endpoint, extracts the PILOT_BASIC.csv file, and produces two summary analyses: the distribution of certificate types across the airmen population, and the top 15 states by active airmen count. Both analyses are useful starting points for understanding the composition and geographic distribution of the US pilot workforce.

import requests, zipfile, io, pandas as pd

# FAA Airmen Certification — releasable database (quarterly)
# From: https://www.faa.gov/licenses_certificates/airmen_certification/releasable_airmen_download
url = "https://av-info.faa.gov/data/certificatedAirmen/ReleasableAirmen.zip"
print("Downloading FAA Releasable Airmen database...")
resp = requests.get(url, timeout=120)

with zipfile.ZipFile(io.BytesIO(resp.content)) as z:
    names = z.namelist()
    print(f"Files in archive: {names}")
    # PILOT_BASIC.csv has core airmen data
    with z.open("PILOT_BASIC.csv") as f:
        df = pd.read_csv(f, encoding="latin-1", low_memory=False)

print(f"\nAirmen records: {len(df):,}")
print(f"Columns: {list(df.columns)}")

# Certificate type distribution
cert_col = [c for c in df.columns if "CERT" in c.upper()][0]
cert_dist = df[cert_col].value_counts().head(10)
print("\nAirmen certificate type distribution:")
print(cert_dist.to_string())

# State distribution
state_col = [c for c in df.columns if "STATE" in c.upper()][0]
top_states = df[state_col].value_counts().head(15)
print("\nTop 15 states by active airmen:")
print(top_states.to_string())

Implementation notes. The FAA's bulk download URL is stable but the archive structure has changed across releases; the script prints the archive contents before opening a specific file, making it straightforward to adapt if the internal naming changes in future releases. The encoding="latin-1" parameter is necessary because the FAA files use legacy Latin-1 encoding rather than UTF-8; reading without this parameter produces encoding errors on names with accented characters. The column-detection logic using CERT and STATEsubstring matching is robust to minor column name variation across quarterly releases.

The releasable database does not include medical certificate currency, which requires a separate data source — either the FAA's Airmen Inquiry web interface or the Aviation Medical Examiner system for individual lookups. Analytical work on medical certificate currency typically relies on the publicly available airmen data in combination with BasicMed adoption statistics published separately in the FAA's annual statistical handbook.

For aircraft registration analysis, the same download-and-parse pattern applies to the monthly MASTER.txt file from the aircraft registration portal. The MASTER.txt file uses fixed-width field layout in older releases and comma-delimited CSV in more recent ones; the FAA publishes a layout document alongside each release that defines field positions and widths for both formats.