Skip to content

Registered aircraft · 230

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 ('2073333', '207333A')
  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 ('2073333', '207333A')
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.

N221JEElgee John O · Anchorage, AKBuilt 1973 · S/N U20601990 N222MHJones Jimmy N · Bremond, TXBuilt 1972 · S/N U20601931 N229WWMcgregor Daniel A · Denali Park, AKBuilt 1973 · S/N U20601807 N24012Grubba Gregory T · Anchorage, AKBuilt 1974 · S/N U206-02237 N2457UBurr Ronald E · Anchorage, AKBuilt 1974 · S/N U20602378 N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822 N247KMNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1975 · S/N U20602872 N2481UWilliams Jeremy · Searsport, MES/N U20602380 N254TSGiesbrecht Nolan R · Burns, ORBuilt 1974 · S/N U20602381 N2591TFerguson John W · Edwardsburg, MIBuilt 1975 · S/N U20602594 N26FCRwr Air Inc · Tok, AKBuilt 1974 · S/N U20602541 N2WFMaine Dept Of Agriculture Conservation & Forestry · Old Town, MEBuilt 1975 · S/N U20602849 N2YROverland Missions Inc · Cocoa, FLS/N U20601737 N30MSFlying Medical Service · Grosse Pointe, MIBuilt 1974 · S/N U20602620 N3259RGlobal Marc Aire Inc · Dallas, TXBuilt 1973 · S/N U20602215 N32PXKustatan Leasing LLC · Kenai, AKBuilt 1976 · S/N U20603343 N33196One Niner Six Aviation LLC · Anchorage, AKBuilt 1975 · S/N U20602664 N33216Avarts LLC · New Castle, DES/N U20602676 N33247R House Leasing LLC · Stormville, NYBuilt 1975 · S/N U20602692 N33277Niebuhr Bradley A · Morriston, FLS/N U20602708 N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331 N34FFZwierlein Victor · Grand Prairie, TXBuilt 1976 · S/N U20603334 N355TAIsland Amphibs LLC · Fort Lauderdale, FLBuilt 1976 · S/N U20603446 N35837Smernoff Michael J · Des Plaines, ILBuilt 1975 · S/N U20602749 N35851Northwest Passage LLC · Anchorage, AKS/N U20602757 N35859Hooper Ranch LLC · Elko, NVBuilt 1975 · S/N U20602763 N35868Registration Pending · Enterprise, ORRegistration pendingBuilt 1973 · S/N U20602107 N35883Sasquatch Alaska Adventure Co LLC · Fritz Creek, AKBuilt 1975 · S/N U20602779 N35889Torgerson Management Inc · Turtle Lake, WIBuilt 1975 · S/N U20602783 N35937Glaser Don E DBA · Willow, AKBuilt 1975 · S/N U20602812 N35945Illinois Department Of Transportation · Springfield, ILBuilt 1975 · S/N U20602819 N35947Continental Construction Inc · Alpine, WYBuilt 1975 · S/N U20602821 N35952Johnson Deborah K · Fairbanks, AKBuilt 1974 · S/N U20602825 N35962Barker Aviation LLC · Spearfish, SDBuilt 1975 · S/N U20602833 N36GBSmokey Bay Air Inc · Homer, AKBuilt 1972 · S/N U20601854 N36MSFlying Medical Service Inc · Grosse Pointe, MIBuilt 1976 · S/N U20603244 N401SUWright Air Service Inc · Fairbanks, AKBuilt 1975 · S/N U20602932 N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438 N4226QVolatile Aero Ventures LLC · Boulder City, NVBuilt 1976 · S/N U20603041 N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042 N4291QRegistered aircraftBuilt 1976 · S/N U20603043 N442GRAk Air Leasing LLC · Homer, AKBuilt 1972 · S/N U20601811 N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052 N476LSHoffman Anthony J Trustee · Hillsboro, ORBuilt 1976 · S/N U20603283 N479HBDouble Bar Stationair LLC · Coeur D Alene, IDBuilt 1975 · S/N U20602923 N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156 N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549 N4991GAlderman Melvin R · Jacksonville, FLBuilt 1972 · S/N U20601823 N50233Garofalo Dawn L · Bellingham, WABuilt 1972 · S/N U20601911 N50937Tls Aviation LLC · Eldridge, IABuilt 1973 · S/N U20601953

Back to Cessna U206F