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.

Piper PA-28-1404,258 registered aircraftRegistry code 7102802Cirrus Design SR224,020 registered aircraftRegistry code 2130001Zipline International P2 ZIP3,854 registered aircraftRegistry code 06102IICessna 172M3,572 registered aircraftRegistry code 2072418Piper PA-28-1803,505 registered aircraftRegistry code 7102808Piper J3C-653,189 registered aircraftRegistry code 7100510Cessna 172N3,138 registered aircraftRegistry code 2072434Cirrus Design SR22T3,092 registered aircraftRegistry code 2130004Piper PA-28-1812,940 registered aircraftRegistry code 7102807Cessna 182P2,099 registered aircraftRegistry code 2075816Piper PA-18-1502,054 registered aircraftRegistry code 7101828Cessna 172S1,914 registered aircraftRegistry code 2072439Beech A361,907 registered aircraftRegistry code 1151604Aeronca 7AC1,878 registered aircraftRegistry code 2110102DJI AGRAS T401,843 registered aircraftRegistry code 06102D3Cessna 1721,805 registered aircraftRegistry code 2072402Cessna 1521,636 registered aircraftRegistry code 2071835Cirrus Design SR201,633 registered aircraftRegistry code 2130000Cessna 1401,603 registered aircraftRegistry code 2071602DJI AGRAS T501,569 registered aircraftRegistry code 06102HGCessna 182Q1,565 registered aircraftRegistry code 2072732Piper PA-28-1611,490 registered aircraftRegistry code 7102803Cessna 150L1,447 registered aircraftRegistry code 2071826Cessna 150M1,439 registered aircraftRegistry code 2071830Mooney M20J1,407 registered aircraftRegistry code 5870219Robinson Helicopter R44 II1,331 registered aircraftRegistry code 7640122Cessna 170B1,299 registered aircraftRegistry code 2072306Mooney M20C1,258 registered aircraftRegistry code 5870208Textron 172S1,250 registered aircraftRegistry code 2072449Piper PA-121,242 registered aircraftRegistry code 7101202