Skip to content

Registered aircraft · 660

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 ('2071402')
  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 ('2071402')
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.

N799TLSmith Joel L · Cedar Park, TXBuilt 1946 · S/N 11788 N81040Bas Part Sales LLC · Greeley, COS/N 10330 N81044Air Transport Inc · Las Vegas, NVBuilt 1946 · S/N 10334 N81064Borkowski Steven S · Summerfield, NCBuilt 1946 · S/N 10354 N81084Murphy Matthew L · Harlem, GABuilt 1946 · S/N 10378 N869ABHoover Travis · Mountain View, OKBuilt 1947 · S/N 12888 N89498Ehmann Stephen L · Grand Rapids, MIS/N 8534 N89510K & M Aviation LLC · West Liberty, KYBuilt 1946 · S/N 8546 N89530Bradshaw David T · Tuscola, TXBuilt 1946 · S/N 8566 N89550Shewman Jamison · Mt Enterprise, TXBuilt 1946 · S/N 8590 N89563Wiener Ronald K · Tucson, AZBuilt 1946 · S/N 8606 N89567Registered aircraftBuilt 1946 · S/N 8610 N89583Crosby Charles Daniel · Stottville, NYBuilt 1946 · S/N 8626 N89587Thompson Randy L · Anderson, CABuilt 1946 · S/N 8630 N89598Phillipson Justin M · Vacaville, CABuilt 1946 · S/N 8642 N89611Hurren Scott Joseph · Grant Township, MIS/N 8658 N89631Reeves Shawn E · Richmond Hill, GAS/N 8678 N89635Ocotillo Medical LLC · Tempe, AZBuilt 1946 · S/N 8682 N89639Holmgren Lorence T · Kulm, NDBuilt 1946 · S/N 8686 N89658Scott William M · Spring Hill, FLBuilt 1946 · S/N 8706 N89682Evans Dwight M · Nipomo, CABuilt 1946 · S/N 8730 N89690Warren Joy A · White Lake, MIBuilt 1946 · S/N 8738 N89697Boor Benjamin G · Masury, OHS/N 8746 N89709Guillory Howard C · Sulphur, LABuilt 1946 · S/N 8758 N89765Miller Aviation Inc · Norton, KSBuilt 1946 · S/N 8814 N89777C&D D LLC · Conway Springs, KSBuilt 1946 · S/N 8826 N89785Baldwin Aaron J · Gig Harbor, WAS/N 8834 N89801Dalton Berek · Owasso, OKBuilt 1946 · S/N 8850 N89809St Cyr Shane R · Plattsburgh, NYS/N 8858 N89829Ficker Duane · Marine, ILS/N 8878 N89833Shaffer Randall H · Orinda, CABuilt 1946 · S/N 8882 N89837Williams Robert W Jr · Lees Summit, MOBuilt 1946 · S/N 8886 N89861Hicks Bobby J · Horn Lake, MSBuilt 1946 · S/N 8906 N89885Erhart Aviation Services LLC · Kalispell, MTBuilt 1946 · S/N 8930 N89925Dirigo Aerospace Solutions LLC · Sumner, MES/N 8974 N89938Nickel Galen L · Sagle, IDBuilt 1946 · S/N 8990 N89942Hawgwild Aviation & Holdings LLC · Kansas City, MOBuilt 1946 · S/N 8994 N89954Aviation Consulting Management Enterprises LLC · Bryant, ARBuilt 1946 · S/N 9006 N89958Frets Jason G · Gainesville, GABuilt 1946 · S/N 9010 N89974Mulvania Rodney A · Linn, MOBuilt 1946 · S/N 9026 N89978Wilson Keith · Los Lunas, NMBuilt 1946 · S/N 9030 N89982Kiper Kaleb · Fairbanks, AKBuilt 1946 · S/N 9034 N89990Arbie Melvin J · Lake City, FLBuilt 1946 · S/N 9042 N89996Stauffer Bradley E · Milford, NEBuilt 1946 · S/N 9050 N90004Forthofer Richard · King Salmon, AKBuilt 1946 · S/N 9058 N90028Seiler Elliott R · Green Bay, WIS/N 9086 N90044Crosby Kenneth R · Trapper Creek, AKBuilt 1956 · S/N 9102 N90056Mcginn Robert W · Marion, NCBuilt 1946 · S/N 9114 N90061Theobald Daryl Lee · Aberdeen, SDBuilt 1946 · S/N 9122 N90065Jones David L · Excelsior Springs, MOS/N 13376

Back to Cessna 120