Registered aircraft
318,637 aircraft in the FAA registry. Enter an N-number to see the aircraft and the ADs that may apply to its airframe and engine, and the aircraft that carried the number before (383,719 cancelled registrations since the 1920s).
Most registered models
Query with SQL
duckdb -csv -c "-- The 30 most registered models; without the LIMIT, every model SELECT m.code, m.manufacturer, m.model, count(*) AS aircraft FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code GROUP BY ALL ORDER BY aircraft DESC LIMIT 30"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
-- The 30 most registered models; without the LIMIT, every model SELECT m.code, m.manufacturer, m.model, count(*) AS aircraft FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code GROUP BY ALL ORDER BY aircraft DESC LIMIT 30
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
Piper PA-28-1404,258 registered aircraftCirrus Design SR224,020 registered aircraftZipline International P2 ZIP3,854 registered aircraftCessna 172M3,572 registered aircraftPiper PA-28-1803,505 registered aircraftPiper J3C-653,189 registered aircraftCessna 172N3,138 registered aircraftCirrus Design SR22T3,092 registered aircraftPiper PA-28-1812,940 registered aircraftCessna 182P2,099 registered aircraftPiper PA-18-1502,054 registered aircraftCessna 172S1,914 registered aircraftBeech A361,907 registered aircraftAeronca 7AC1,878 registered aircraftDJI AGRAS T401,843 registered aircraftCessna 1721,805 registered aircraftCessna 1521,636 registered aircraftCirrus Design SR201,633 registered aircraftCessna 1401,603 registered aircraftDJI AGRAS T501,569 registered aircraftCessna 182Q1,565 registered aircraftPiper PA-28-1611,490 registered aircraftCessna 150L1,447 registered aircraftCessna 150M1,439 registered aircraftMooney M20J1,407 registered aircraftRobinson Helicopter R44 II1,331 registered aircraftCessna 170B1,299 registered aircraftMooney M20C1,258 registered aircraftTextron 172S1,250 registered aircraftPiper PA-121,242 registered aircraft