Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N72756Brown Randy S · Wasilla, AKBuilt 1946 · S/N 9939 N72757Rich Walter M · Amana, IAS/N 9940 N72769Ritschel Andrew J · San Martin, CAS/N 9952 N72776Hanson James A · Bandon, ORS/N 9959 N72777Wilk Alan · East Elmhurst, NYBuilt 1946 · S/N 9960 N72789Dornseif Keith · Merrillville, INBuilt 1946 · S/N 9975 N72791Anderson Wayne G · Tehachapi, CAFirst renewal noticeBuilt 1946 · S/N 9977 N72801Brink Daniel · Florence, ALBuilt 1946 · S/N 9987 N72803Cotton Norman E · Carmel, CABuilt 1946 · S/N 9989 N72826August Aero LLC · Kalispell, MTS/N 10012 N72827Registration Pending · Winnsboro, SCRegistration pending, pending cancellationBuilt 1946 · S/N 10013 N72831Huff Tony D · Luthersville, GABuilt 1946 · S/N 10017 N72845Alexandrov Boyan · Reno, NVBuilt 1946 · S/N 10032 N72848Erker Quade J · Roggen, COBuilt 1946 · S/N 10035 N72853Day Michael J Trustee · Cedar Key, FLBuilt 1946 · S/N 10040 N72854Dupont Michael R · East Taunton, MABuilt 1946 · S/N 10041 N72856Orme John Robert II · Flushing, MIBuilt 1946 · S/N 10043 N72860Woodside Nicholas · Johnson City, TNBuilt 1946 · S/N 10051 N72862Registration Pending · Ozark, ALRegistration pending, pending cancellationS/N 10053 N72865Schmidt Victor · Goldendale, WAS/N 10056 N72876Legan Howard Daniel · Las Vegas, NVBuilt 1946 · S/N 10067 N72878Doughty Frank · North Andover, MABuilt 1946 · S/N 10072 N72881Jenkins Joan C · West Columbia, SCBuilt 1946 · S/N 10075 N72883Donovan Robert J · Bothell, WABuilt 1946 · S/N 10077 N72885George Richard · Holmen, WIBuilt 1946 · S/N 10079 N72891Steiner Zachary J · Bethlehem, CTS/N 10085 N72894Registered aircraftBuilt 1946 · S/N 10088 N72897Chamberlain Kendall · Frisco, TXS/N 10091 N72902Fischer Lee F · Larned, KSBuilt 1946 · S/N 10096 N72907Maggart Kenneth R · Lutz, FLBuilt 1946 · S/N 10101 N72911Garrison Kevin · Lexington, KYS/N 10105 N72913Kinsey Roy M Jr · Pensacola, FLBuilt 1946 · S/N 10107 N72915Engelking William S · Detroit Lakes, MNBuilt 1946 · S/N 10109 N72917Walker Ray · Sanger, TXS/N 10111 N7291BBognar Jeffrey L · Kinnelon, NJBuilt 1946 · S/N 10108 N72922Registered aircraftBuilt 1946 · S/N 10120 N72926Williams Andrew B · Mineral Wells, TXBuilt 1946 · S/N 10124 N72930Fox Industries Of Ms Inc · Canton, MSS/N 10128 N72937Bardo Daniel J · Salem, OHBuilt 1946 · S/N 10135 N72938Heitz John · Manvel, TXBuilt 1946 · S/N 10136 N72943Parsons Douglas L · Carrollton, OHBuilt 1946 · S/N 10141 N72949Uhlemeyer William A · Alvin, TXBuilt 1946 · S/N 10147 N72950El Coyote Ranch LLC · Alzada, MTS/N 10148 N72951Ciholas Philippe A · Sedgwick, KSBuilt 1946 · S/N 10149 N72953Kor Reese W · Piedmont, SDS/N 10151 N72957Hugie Lucas R · Logan, UTBuilt 1946 · S/N 10155 N72959Holloway Kevin R · Williamsport, MDFirst renewal noticeBuilt 1946 · S/N 10157 N72962Huff Tony D · Luthersville, GABuilt 1946 · S/N 10160 N72963Minier Tryg R · Watsonville, CABuilt 1946 · S/N 10161 N72966Capdepon Paul V · Newellton, LABuilt 1946 · S/N 10167

Back to Cessna 140