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.

N5135ECommercial Safe And Lock Inc · Imperial, MOBuilt 1978 · S/N 17271728 N5136DZieg James E · Goldsboro, NCBuilt 1979 · S/N 17272432 N5136EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271729 N5138ESanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17271731 N5139EAero Techniques LLC · Binghamton, NYBuilt 1978 · S/N 17271732 N5140ESadosky Paul · Glendale, WIS/N 17271733 N5141KGilbertsville Flying Service LLC · Gilbertsville, PABuilt 1980 · S/N 17273983 N5143JSkywarrior Flight Training Inc · Pensacola, FLS/N 17273713 N5145ESierra Pacific Aviation · Willits, CAS/N 17271735 N5145KZulu Jets LLC · Boerne, TXBuilt 1980 · S/N 17273986 N5147EDirty Side Down LLC · Noblesville, INBuilt 1978 · S/N 17271737 N5148JTc Cavu Club LLC · Traverse City, MIS/N 17273715 N5148KHetteen David D · Camano Island, WABuilt 1980 · S/N 17273988 N5149EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271738 N5150DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272435 N5154DCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17272436 N5155JCisco Aero LLC · Cisco, TXS/N 17273717 N5155KSuno LLC · Calhan, COBuilt 1980 · S/N 17273992 N5156JWings Over La Aviation LLC · West Hills, CABuilt 1979 · S/N 17273718 N5157KWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1980 · S/N 17273993 N5158EHuettl Austin · Liberty Hill, TXBuilt 1978 · S/N 17271743 N5160ELeading Edge Flight Academy LLC · Bend, ORBuilt 1978 · S/N 17271744 N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120 N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438 N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746 N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747 N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889 N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998 N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752 N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753 N517CAFisher Richard L Jr · Saint Helens, ORS/N 17268100 N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965 N5182ERegistered aircraftBuilt 1978 · S/N 17271756 N5183ENashville Flight School LLC · Nashville, TNS/N 17271757 N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758 N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721 N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441 N5187ENowak Michael J · Waxahachie, TXBuilt 1978 · S/N 17271760 N5187GThompson Edward A · Sunset Beach, NCBuilt 1979 · S/N 17273555 N518CACompass Aviation Inc · Shelby, NCBuilt 1979 · S/N 17273049 N5191JN5191j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273724 N5193ER&R Aero Services LLC · Eden Prairie, MNS/N 17271763 N5194FSanders Flight Training Center Inc · Jasper, ALBuilt 1979 · S/N 17273125 N5194KHowe'S Flight Concepts LLC · Visalla, CAFirst renewal noticeBuilt 1980 · S/N 17274005 N5195ESix Ten Ventures LLC · Grand Prairie, TXBuilt 1978 · S/N 17271764 N5197ETspy Services Inc · Wilmington, DEBuilt 1978 · S/N 17271765 N5197KN5197k LLC · Cheyenne, WYBuilt 1980 · S/N 17274007 N5198EGaruda Flight Training LLC · Miami, FLBuilt 1978 · S/N 17271766 N5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLBuilt 1978 · S/N 17271767 N5202EMcdowell William R · Corpus Christi, TXBuilt 1978 · S/N 17271768

Back to Cessna 172N