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.

N89754Bentch Mark W · Sedalia, MOBuilt 1946 · S/N 8803 N89760Bollenbacher Stephen A · Fulton, NYBuilt 1946 · S/N 8809 N89762Fennig Barry L · Bryant, INBuilt 1946 · S/N 8811 N89766Rc White Aviation LLC · Wilmington, DEBuilt 1946 · S/N 8815 N89775Norman Charles E · Zanesville, OHBuilt 1946 · S/N 8824 N89788Mulder Albert · Midland, MIBuilt 1946 · S/N 8837 N89794Buechler Tryston M · Billings, MTBuilt 1946 · S/N 8843 N89798Bowen Bruce C · Sturgis, SDBuilt 1946 · S/N 8847 N89799Bahr Bradley R · Salem, ORBuilt 1946 · S/N 8848 N89816Redman Ronald G · Palouse, WABuilt 1946 · S/N 8865 N89818Benning Dennis D · Tuolumne, CABuilt 1946 · S/N 8867 N89830Doda Scott R · Niagara, WIBuilt 1946 · S/N 8879 N89835Ramras Jay B · Fairbanks, AKBuilt 1946 · S/N 8884 N89836Barr Michael J · Colorado Springs, COBuilt 1946 · S/N 8885 N89842Welch James D · Holdenville, OKBuilt 1946 · S/N 8891 N89844Stevens Brian R · Lompoc, CABuilt 1946 · S/N 8893 N89848Haas David C · Janesville, WIS/N 8897 N89849Myers Russell · Spangle, WABuilt 1946 · S/N 8583 N89850Thompson Michael P · Natchez, MSBuilt 1946 · S/N 8584 N89855Jones Riley T · Thayne, WYS/N 8900 N89858Livingston Patrick A · Pratt, KSBuilt 1946 · S/N 8903 N89860Bradley Charles R · Herod, ILFirst renewal noticeBuilt 1946 · S/N 8905 N89882Plane Fun Inc Tr Trustee · Snellville, GABuilt 1946 · S/N 8927 N89883Beck Christopher A · Belvidere, ILS/N 8928 N89884Valiair Lc Trustee · Casper, WYBuilt 1946 · S/N 8929 N89886Dickson David C · Sebring, FLBuilt 1946 · S/N 8931 N89895Gandall Ryan D · Elk, CAS/N 8940 N89898Fay Gregory A · Milton, VTS/N 8943 N89902Subra Marlin D · Taylor, WIBuilt 1955 · S/N 8947 N89903Covey Zachary J · New Underwood, SDBuilt 1946 · S/N 8948 N89906Beery Ray M · Exeter, CABuilt 1946 · S/N 8951 N89907Hill David A · Fort Worth, TXBuilt 1946 · S/N 8952 N89911Krause Aviation LLC · Geneva, ILBuilt 1946 · S/N 8960 N89918Christie Ian A H · Limon, COBuilt 1946 · S/N 8967 N89923Livermont Joann M · Dillingham, AKBuilt 1946 · S/N 8972 N89932Swartzendruber Brett · Hesston, KSS/N 8984 N89936Barnes Clint R · Wills Point, TXBuilt 1946 · S/N 8988 N89941Bernard E Fay II · Eagle, AKBuilt 1946 · S/N 8993 N89947Christain Keith · Ogden, UTBuilt 1946 · S/N 8999 N89952Striegel William H II · Spangle, WABuilt 1946 · S/N 9004 N89959King Mark R · Oxnard, CABuilt 1946 · S/N 9011 N89965King Aubrey R · Salinas, CABuilt 1946 · S/N 9017 N89968Warwick Dakota R · Jupiter, FLS/N 9020 N89972Wrong Brothers LLC · Sedgwick, KSBuilt 1954 · S/N 9024 N89973Seward Leasing Inc · Guthrie, OKBuilt 1946 · S/N 9025 N89977Hampton Stephen L · Culbertson, MTBuilt 1946 · S/N 9029 N89988Carpentier Michael · Moses Lake, WABuilt 1946 · S/N 9040 N89993Mossman Andrew Douglas · Pickerington, OHS/N 9047 N89999Moreus Steven P · Sunfish Lake, MNBuilt 1946 · S/N 9053 N90000White Steven M · Grapevine, TXBuilt 1946 · S/N 9000

Back to Cessna 140