Skip to content

Registered aircraft · 3,138

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 ('2072434')
  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 ('2072434')
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.

N3564EGenerals International Inc · Red Oak, TXBuilt 1978 · S/N 17271590 N3566ECronk Jack L · Fallbrook, CABuilt 1978 · S/N 17271591 N3568EColonial Air Inc · New Bedford, MABuilt 1978 · S/N 17271592 N3570EBlackbird Aviation Corp · Van Nuys, CAS/N 17271593 N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601 N3601ELsn Air LLC · Morrison, COBuilt 1978 · S/N 17271603 N3606EMiller Robert J · Casselton, NDBuilt 1978 · S/N 17271604 N3607EPalm Cedric C · St Francisville, LABuilt 1978 · S/N 17271605 N3609EBismarck Aero Center Corp · Bismarck, NDBuilt 1978 · S/N 17271606 N3610EOrange County Flyers Inc · Mission Viejo, CAS/N 17271607 N3627EJmch Flight LLC · Henderson, NVBuilt 1978 · S/N 17271610 N362BLLabelle Brendan · Huntington, NYBuilt 1978 · S/N 17270478 N3631EMudcat Construction Inc · Beattyville, KYBuilt 1978 · S/N 17271611 N3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 17271612 N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033 N369ADManston Quinton A · White, GABuilt 1977 · S/N 17269479 N369RJD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17273068 N36GRRiethof George N · Nantucket, MABuilt 1978 · S/N 17272026 N370XPMckerney Charles A · Anchorage, AKBuilt 1976 · S/N 17267622 N372SAJoe Wagner IV Construction LLC · Zebulon, NCBuilt 1979 · S/N 17272854 N379JASugai Kunio Kenny · Van Nuys, CABuilt 1977 · S/N 17268761 N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385 N381DFSouth & Silver Aviation LLC · Pikesville, MDBuilt 1977 · S/N 17269718 N382DFDream Flight LLC · Westminster, MDBuilt 1976 · S/N 17268233 N383DFDream Flight LLC · Westminster, MDBuilt 1977 · S/N 17269914 N38FRHenry Scott · Kingman, AZBuilt 1978 · S/N 17270698 N38PAMarine Flyer LLC · Eddyville, KYBuilt 1977 · S/N 17270182 N3HQChesapeake Searey LLC · Wilmington, DES/N 17269154 N3RWGordon George M Jr · Weston, MABuilt 1978 · S/N 17271069 N4021Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1979 · S/N 17272149 N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264 N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569 N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900 N4182TMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270319 N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787 N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890 N41FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272997 N41MEFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17269389 N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437 N422BPreston Richard K Trustee · Albuquerque, NMS/N 17268342 N424WMMorrison Jeffrey A · Williamson, GABuilt 1977 · S/N 17269385 N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050 N426SKBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17273720 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N430FSCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 17271355 N4334LOcuto Vincent Louis II · Homestead, FLS/N 17269555 N436RMRocky Mountain College · Billings, MTBuilt 1979 · S/N 17273662 N437PHHolske Peter John · Dartmouth, MAS/N 17267933 N43APSchubert Edward M · Floyds Knobs, INS/N 17273802 N43FAKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 17270808

Back to Cessna 172N