Skip to content

Registered aircraft · 3,572

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2072418')
  ORDER BY n_number"

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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072418')
ORDER BY n_number

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.

N383BHAero Aircraft 13 LLC · Jacksonville, FLBuilt 1974 · S/N 17264151 N3842VN3842v LLC · Wainscott, NYBuilt 1973 · S/N 17262158 N38CKHartsfield Amy G · Pace, FLS/N 17263959 N397TNickerson Kelly D · Ellensburg, WABuilt 1973 · S/N 17260863 N3JARegistered aircraftBuilt 1975 · S/N 17266528 N3RXMorelli Michael V · Kenilworth, ILBuilt 1974 · S/N 17264044 N3TNChamplain Flyers LLC · Westford, VTBuilt 1974 · S/N 17263547 N401HXThree Forks Flying Club Inc · Three Forks, MTFirst renewal noticeBuilt 1974 · S/N 17263490 N4060GCm3 LLC · North Las Vegas, NVS/N 17264771 N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170 N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241 N411SSDalmolin Russell Scott · Globe, AZBuilt 1973 · S/N 17261603 N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164 N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659 N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980 N42024White Wings Air Inc · Jacksonville, FLBuilt 1974 · S/N 17264153 N42033State Of Alaska · Anchorage, AKBuilt 1974 · S/N 17264154 N42035Paulsen Hans J · Cedartown, GABuilt 1974 · S/N 17264155 N42061Muhle Gerald A · Lincoln, NEBuilt 1974 · S/N 17264156 N42062Parker Jo K Trustee · Ardmore, OKBuilt 1974 · S/N 17264157 N42095Cpkb · Summit, NJBuilt 1974 · S/N 17264158 N42111Blanchfield Christine Lizabeth · Devils Lake, NDBuilt 1974 · S/N 17264159 N42117Sturdivant Marshall J · Ellijay, GABuilt 1974 · S/N 17264160 N42126Zrelak Patrick · Apple Valley, CABuilt 1974 · S/N 17264162 N42212Caves Xxi Properties LLC · Virginia Beach, VABuilt 1974 · S/N 17264163 N42292Breier Michael D · Pasco, WABuilt 1974 · S/N 17264168 N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171 N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404 N427JGLigon Scott A · Florence, ALBuilt 1973 · S/N 17261688 N4283SHayes Timothy · Gray, MEBuilt 1974 · S/N 17263748 N4284PEmpire Aviators LLC · Long Island City, NYS/N 17264088 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N42CMMazor Chris · Belleville, MIS/N 17266374 N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383 N4300RCab Air Inc · Columbia, NJBuilt 1974 · S/N 17263054 N4301RMeggers Roger D · Baker, MTBuilt 1974 · S/N 17263055 N4307RMcmath Don · Collinsville, OKBuilt 1974 · S/N 17263060 N4312RHorizon Group Inc Trustee · Boca Raton, FLBuilt 1974 · S/N 17263065 N4313RStauffer Kurt A · Belleville, PABuilt 1974 · S/N 17263066 N4315RDuffys Aircraft Sales And Leasng Inc · Neillsville, WIBuilt 1974 · S/N 17263068 N4316RMarston Charles T · New Bern, NCBuilt 1974 · S/N 17263069 N4317RSam Aviation LLC · Long Beach, CAS/N 17263070 N4318RBeaulieu Steven · Georgetown, DEBuilt 1974 · S/N 17263071 N431ARegistered aircraftBuilt 1976 · S/N 17265942 N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076 N4324RShadle James A Jr · Gig Harbor, WABuilt 1974 · S/N 17263077 N4325RGaruda Aviation Inc · Miami, FLBuilt 1974 · S/N 17263078 N4331RConsolidated Aviation Services LLC · Seymour, TNBuilt 1974 · S/N 17263084 N4332RHolland Peter B · Uniontown, WABuilt 1974 · S/N 17263085 N4333RReigle Aviation · Palmyra, PABuilt 1974 · S/N 17263086

Back to Cessna 172M