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.

N1471EKdrd Holdings LLC · Texas City, TXBuilt 1978 · S/N 17271014 N1472FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273007 N1474ESuffolk County Police Pilots Assoc · Bayport, NYBuilt 1978 · S/N 17271015 N1474FJlb Aviation Services LLC · Woodbine, NJBuilt 1979 · S/N 17273008 N1479EAero Capital Lending LLC · Miami, FLBuilt 1978 · S/N 17271016 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1490EFoothill Aircraft Sales & Service Inc · Upland, CABuilt 1978 · S/N 17271020 N1493ESherman Aviation LLC · Fairfield, NJBuilt 1978 · S/N 17271022 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1517EHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 1978 · S/N 17271031 N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N1544EAtlas Aero Training LLC · Casper, WYBuilt 1978 · S/N 17271041 N1545ESlipstream Aviation LLC · Carrollton, GABuilt 1978 · S/N 17271042 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043 N1558EFlores Frank J · Ozark, MOBuilt 1978 · S/N 17271046 N1560EAmerican Airman Inc · Stony Brook, NYBuilt 1978 · S/N 17271047 N1564EElizabethtown Flying Service Inc · Elizabethtown, KYBuilt 1978 · S/N 17271048 N156XDBurgess Mark W · Greene, MES/N 17268718 N1571EMorgan Steven P · Roswell, GABuilt 1978 · S/N 17271049 N1580EBermudez John M · Pembroke Pines, FLBuilt 1978 · S/N 17271051 N1584EDurbin William E · Parkersburg, IABuilt 1978 · S/N 17271052 N1588EGeaux Giddum 1 LLC · Brandon, MSBuilt 1978 · S/N 17271054 N1591EWingsleasing LLC · Wichita, KSBuilt 1978 · S/N 17271057 N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060 N15FACivil Air Patrol · Maxwell Afb, ALBuilt 1978 · S/N 17270117 N15FPFoxtrot Papa LLC · Slidell, LABuilt 1977 · S/N 17268574 N15HJMorehouse Cooper · North Pole, AKS/N 17268950 N1602BBoyd Aaron · S San Fran, CABuilt 1979 · S/N 17272737 N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062 N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065 N160FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272752 N1612EPavlovitch Marion T · Northridge, CAFirst renewal noticeBuilt 1978 · S/N 17271066 N1615EFisher Ralph B · Lutz, FLBuilt 1978 · S/N 17271067 N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070 N1629EAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 17271072 N162ASA S Air LLC · Lantana, FLBuilt 1978 · S/N 17271785 N1631ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271073 N1632EXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 17271074 N1637EJag Flying Club Inc · Morgantown, WVBuilt 1978 · S/N 17271077 N1640EBanan Abdolreza · San Diego, CABuilt 1978 · S/N 17271078 N1644EMountain Flyers Inc · Hendersonville, NCBuilt 1979 · S/N 17271079 N1651ENoffsinger Robert L · Winston Salem, NCS/N 17271081 N1657EMcghee David L · Oklahoma City, OKBuilt 1978 · S/N 17271085 N1658EBrockwell Jesse A · Disputanta, VABuilt 1978 · S/N 17271086 N1660BKanode William E · Delaware, OHS/N 17268123 N1672EWichita Area Technical College · Wichita, KSBuilt 1978 · S/N 17271089 N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090 N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093 N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095

Back to Cessna 172N