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.

N76978Pelz Michael J · Etowah, NCBuilt 1946 · S/N 11424 N76983Bridges Jesiah M · Muncie, INBuilt 1946 · S/N 11429 N76985Mandella Joseph · Harrison, ARBuilt 1946 · S/N 11431 N76989Thompson Randy L · Anderson, CABuilt 1946 · S/N 11435 N76990Brown Hector M · Glenwood Springs, COS/N 11436 N76994Speer Anthony F · Caldwell, IDS/N 11440 N76995Melia Daniel J · Burlington, COBuilt 1946 · S/N 11441 N76MWRoupoli Lou · San Pedro, CABuilt 1946 · S/N 8633 N77007Tanner Paul L · Savoy, TXBuilt 1946 · S/N 11453 N77009Tardif Peter J · Pittsburg, NHFirst renewal noticeBuilt 1946 · S/N 11455 N77011Altherr James H · Fairbanks, AKBuilt 1946 · S/N 11457 N77013White Stephen M · Brunswick, MEBuilt 1946 · S/N 11459 N77017Registration Pending · Kalamazoo, MIRegistration pendingBuilt 1946 · S/N 11463 N77018Madden Robert W Jr · Nome, AKBuilt 1946 · S/N 11464 N77021Ingram Ronald W · Springfield, ILBuilt 1946 · S/N 11467 N77041Registered aircraftS/N 11495 N77045Bobka Christian · NorthamptonshireS/N 11499 N77049J R Bane Land Corporation · Oakland, IABuilt 1946 · S/N 11503 N77050Cache R Bridges · Girdwood, AKS/N 11504 N77051Allen Benjamin L · Millen, GABuilt 1946 · S/N 11505 N77053Linden Richard M Jr · Dallas, TXBuilt 1946 · S/N 11507 N77061Magallanes Luis Alberto · Miami, FLBuilt 1946 · S/N 11515 N77062Monahan Steve G · Billings, MTS/N 11516 N77063Daniels Robert Douglas · Greenville, TXBuilt 1946 · S/N 11517 N77082Arps Alan D · Schuyler, NEBuilt 1946 · S/N 11536 N77083Beigle Harvey T · Prescott, AZBuilt 1946 · S/N 11537 N77086De Velde Nathaniel C · Dallas, TXS/N 11540 N77093Schmitt Mark R · Rockford, MIBuilt 1946 · S/N 11551 N77102Newton Christopher F · Avon, INBuilt 1946 · S/N 11560 N77114Bowers Byron L · Lafayette, CABuilt 1946 · S/N 11572 N77121Bays Joseph K · Weirsdale, FLBuilt 1946 · S/N 11579 N77123Cardillo Jeffrey Douglas · Bridgeton, NJBuilt 1946 · S/N 11581 N77130Gilbert Scott A · Cedar Rapids, IABuilt 1946 · S/N 11588 N77143Aukeman Mark C · Georgetown, MEBuilt 1946 · S/N 11601 N77147Dickson Aaron M · Arkadelphia, ARBuilt 1946 · S/N 11609 N77153Johnson Lawrence F · Anchorage, AKBuilt 1946 · S/N 11615 N77159Hamill Zachary A · Gridley, CABuilt 1946 · S/N 11621 N77161Hull Terri L · Weirsdale, FLBuilt 1946 · S/N 11623 N77163Knefley Michael J · Ulysses, PABuilt 1946 · S/N 11625 N77165Mohar Fred B Jr · Turner, MTBuilt 1946 · S/N 11627 N77169Colborn William C · Holly Springs, NCBuilt 1946 · S/N 11631 N77173Ackerman Garry A · Plano, TXBuilt 1946 · S/N 11635 N77174Merrell Blaine W · Bainbridge, INBuilt 1946 · S/N 11636 N77193Hospodar Robert P · Georgetown, PAS/N 11655 N77194Woosley Kenneth D · Rumsey, KYBuilt 1946 · S/N 11656 N77197Averbukh Anthony · Roswell, GAS/N 11659 N77202Ostmeyer Mark G · Colby, KSBuilt 1946 · S/N 11664 N77207Devin R Wiseth · Fargo, NDBuilt 1946 · S/N 11669 N77209Decker Thomas V · Deridder, LABuilt 1946 · S/N 11671 N77210Gomez Oscar · El Mirage, AZS/N 11672

Back to Cessna 140