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.

N76581Lee Marc T · Farmers Branch, TXS/N 11021 N76585Anderson Thomas M · Fairbanks, AKS/N 11025 N76591Dessertier · San Diego, CABuilt 1946 · S/N 11031 N76596Jerome Jeffrey A · Conneaut Lake, PABuilt 1946 · S/N 11036 N76600Benda Carl III · Colorado Springs, COBuilt 1946 · S/N 11040 N76603Dunn Ward A · Columbia, SCBuilt 1946 · S/N 11043 N76608Widewings LLC · Alexandria, VABuilt 1946 · S/N 11048 N76611Peach Daniel J · Rockvale, TNBuilt 1946 · S/N 11051 N76613Hunter Joseph · Myrtle Beach, SCBuilt 1946 · S/N 11053 N76616Farnham Jesse J · Middlebury, CTBuilt 1946 · S/N 11056 N76617Martz Gary Rodney · Frederick, MDS/N 11057 N76619Pitman Marvin L · Harrah, OKBuilt 1946 · S/N 11059 N76621Couch John · Sunman, INBuilt 1946 · S/N 11061 N76624Missionair Inc · Danbury, CTS/N 11064 N76625Brunner Thomas W · Manitowoc, WIFirst renewal noticeBuilt 1946 · S/N 11065 N76628Elhandt Bryan A · Missoula, MTBuilt 1946 · S/N 11068 N76629Liggett L Michael · El Dorado, KSBuilt 1946 · S/N 11069 N76632Satanta Flying Service Inc · Satanta, KSBuilt 1946 · S/N 11072 N76633Burkey Richard A · Wagener, SCBuilt 1946 · S/N 11073 N76635Plane Air LLC · Paducah, KYBuilt 1946 · S/N 11075 N76644Call One Inc · Clarinda, IABuilt 1946 · S/N 11084 N76645Mcleod Chad H · Sumter, SCBuilt 1946 · S/N 11085 N76652Boettcher Christopher A · Benton, KSBuilt 1946 · S/N 11092 N76657Almaguer Carlos · Mcallen, TXBuilt 1946 · S/N 11097 N76673Delaney Patrick J · Marion, TXS/N 11113 N76677Collins Curtis R · Tennessee Colony, TXBuilt 1946 · S/N 11117 N76679Barros Arnold C · Olympia, WABuilt 1946 · S/N 11119 N76680Thomas Daniel S · Willow, AKBuilt 1946 · S/N 11120 N76684Vickers Stephen F · Sandia, TXS/N 10813 N76686Smyder Harold E · New Florence, PABuilt 1946 · S/N 10817 N76689Webber Cris A · Paso Robles, CABuilt 1946 · S/N 10693 N76692Smith Gordon J · Manhattan, KSBuilt 1946 · S/N 11124 N76693Hammer Rick W · Auburn, CABuilt 1946 · S/N 11125 N76695Keyte Clinton W · Colfax, CABuilt 1946 · S/N 11127 N76696Arrow Aircraft Leasing LLC · Mcminnville, ORBuilt 1946 · S/N 11128 N76697Brundage John R · Ann Arbor, MIBuilt 1946 · S/N 11129 N76704Riley Stephen E Trustee · Springfield, ORBuilt 1946 · S/N 11136 N76708Consie Robert T · Ironwood, MIS/N 11140 N76719Basinger Kenneth J · Mcdonough, GABuilt 1946 · S/N 11151 N76724Armi Laurence · Cardiff By The Sea, CABuilt 1946 · S/N 11156 N76728Holloway Jason · Whitewright, TXBuilt 1946 · S/N 11160 N76731Ackerman Gary A · Plano, TXBuilt 1946 · S/N 11163 N76732Daniel Gordon W · Dillsburg, PABuilt 1946 · S/N 11164 N76735Bergen Daniel J · Vinton, IABuilt 1946 · S/N 11167 N76740Spencer Scott Andrew · Brownsburg, INBuilt 1946 · S/N 11172 N76743Gerken David V · Mariposa, CABuilt 1946 · S/N 11175 N76745Johnson Kenneth E · Mahtomedi, MNBuilt 1946 · S/N 11177 N76748Kuper Carl J II · Dalhart, TXBuilt 1946 · S/N 11180 N76755Wild Frederick E III · Oklahoma City, OKBuilt 1946 · S/N 11187 N76756Coon Levi G · Juneau, AKBuilt 1946 · S/N 11188

Back to Cessna 140