Skip to content

Registered aircraft · 87

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

N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409 N1046VSusitna Air Service LLC · Anchorage, AKBuilt 1974 · S/N U20602418 N1065VRegistered aircraftBuilt 1974 · S/N U20602435 N1083VWoltering Myron B · Granite Bay, CABuilt 1974 · S/N U20602453 N111ZUsda Forest Service · Boise, IDS/N U20602919 N1191QCameron Schoessler Aviation LLC · Bliss, IDBuilt 1975 · S/N U20602862 N1194QKirkpatrick Jason · Mosca, COBuilt 1975 · S/N U20602864 N150SCAnderson Thomas R · Seattle, WABuilt 1973 · S/N U20601958 N155DVDunning Vineyards · Haines, ORS/N U20602985 N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075 N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936 N186MLIdaho Fly Girl LLC · Boise, IDBuilt 1974 · S/N U20602644 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316 N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629 N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965 N206BABoeing Company · Mesaon, AZBuilt 1973 · S/N U20602034 N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512 N206RCPaloma Aviation LLC · Fruitland, IDBuilt 1974 · S/N U20602431 N222LSLj Bickford Companies LLC · Wasilla, AKBuilt 1972 · S/N U206-01751 N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999 N25GPAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N U20602889 N2814QGill Robert L · Dixon, CABuilt 1975 · S/N U20602998 N2856QFoster Aaron J · Missoula, MTBuilt 1975 · S/N U20603005 N3160LKo Hee Sun · Norwood, NJBuilt 1975 · S/N U20602815 N33189Schrage Rodney L · Steamboat Springs, COBuilt 1975 · S/N U20602659 N3422Hergenrather Michael · Spring, TXS/N U20602920 N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777 N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792 N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808 N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829 N3746Nickravesh Niknam J · Saratoga, CABuilt 1975 · S/N U20602818 N37EWKundel Andrew R · Muscatine, IAS/N U20602997 N3968QTundra Wings Ministries · Wasilla, AKBuilt 1975 · S/N U20603037 N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093 N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040 N448AKN448ak LLC · Helena, MTBuilt 1974 · S/N U20602295 N50901United Indian Missions Inc DBA · Tucson, AZBuilt 1973 · S/N U20601951 N511RLHatch Leasing Co LLC · Marble Canyon, AZBuilt 1973 · S/N U20602109 N51237Infanger James Robert · Salmon, IDS/N U20601983 N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643 N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645 N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002 N603ETSanborn Map Co · Colorado Springs, COBuilt 1973 · S/N U20602230 N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729 N68NQRounds Dana H · Vacaville, CABuilt 1976 · S/N U20603399 N7000LHalstead Michael J · Gresham, ORBuilt 1975 · S/N U20602907 N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083 N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085

Back to Cessna TU206F