Skip to content

Registered aircraft · 38

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

N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N244HEDubin David A · Tucson, AZS/N 21058990 N2852SLudian Malgorzata · Bakersfield, CAS/N 21058974 N5937FDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 21058937 N5947FGulf Coast Aviation LLC · Terra Ceia, FLBuilt 1967 · S/N 21058947 N5948F5c1 Ltd · Boerne, TXBuilt 1967 · S/N 21058948 N5949FRead Travis E · Lumberton, TXBuilt 1967 · S/N 21058949 N5952FRedmon David M · Biloxi, MSBuilt 1967 · S/N 21058952 N5953FKnickerbocker Thomas C · Houston, TXS/N 21058953 N5956XCox David F · Tucson, AZS/N 21058956 N5969FBowles Walter Rolando Martinez · Naples, FLBuilt 1967 · S/N 21058969 N5982FCharles James Brown · Littlefield, TXS/N 21058982 N5984FFct Aviation LLC · Portales, NMBuilt 1968 · S/N 21058984 N5986FBingham Darold R · Idaho Falls, IDBuilt 1968 · S/N 21058986 N5996FL M W Leasing · Midlothian, TXBuilt 1968 · S/N 21058996 N5998FMedic Choppers LLC · Springdale, ARS/N 21058998 N6100FTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 21059000 N6105FShaw Christopher S · Porterville, CABuilt 1968 · S/N 21059005 N6110FKilmer Scott D · Fort Pierce, FLBuilt 1968 · S/N 21059010 N6112FPcb Inc · Paradise, CAS/N 21059012 N6117FBahl Lawrence S · Lottsburg, VABuilt 1968 · S/N 21059017 N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021 N6125FParker Richard A · West Chicago, ILBuilt 1968 · S/N 21059025 N6126FCarson John D · Garber, OKBuilt 1968 · S/N 21059026 N6127FSmith Phillip · Osprey, FLBuilt 1968 · S/N 21059027 N6130FBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 21059030 N6131FLundell Brandon M · Lyons, COBuilt 1968 · S/N 21059031 N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037 N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038 N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047 N6148FWorsham Eric S · La Porte, TXS/N 21059048 N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052 N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061 N905BWMauro William J · Lancaster, CABuilt 1968 · S/N 21059033 N919RRodriguez Daniel L · West Linn, ORS/N 21059032

Back to Cessna 210H