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.

N50939Heart X Aviation LLC · Salmon, IDBuilt 1973 · S/N U20601954 N50958Stangel Richard C · Enterprise, ORBuilt 1973 · S/N U20601961 N5108QPardue William C Jr · Leesville, LABuilt 1975 · S/N U20603060 N5378PBlue Skies Today LLC · Eagan, MNBuilt 1974 · S/N U20602492 N58441Tall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N U20602604 N58466Aerial Transport LLC · Dover, DEBuilt 1974 · S/N U20602609 N58502H E Fly Float LLC · Virginia Beach, VABuilt 1974 · S/N U20602618 N59146Universal Charter Service Inc · Auburn, CABuilt 1974 · S/N U20602624 N59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKBuilt 1974 · S/N U20602626 N59237Boland Matthew S · Anchorage, AKBuilt 1974 · S/N U20602637 N592KBCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601770 N59WAAdventist World Aviation Inc · Wilson, NCBuilt 1975 · S/N U20602958 N5EA310 LLC · Conover, NCBuilt 1975 · S/N U20602711 N5VAVirginia Department Of Aviation · Richmond, VABuilt 1976 · S/N U20603223 N60134Smith Eddie D · Wasilla, AKBuilt 1973 · S/N U20602011 N60529My Holdings Inc · Anchorage, AKBuilt 1973 · S/N U20602030 N60597Ritchie James E · Grand Junction, COBuilt 1973 · S/N U20602036 N60766Congdon Douglas J · Fairbanks, AKBuilt 1973 · S/N U20602044 N60768Mcgee Jacob Quinton · Anchorage, AKS/N U20602045 N61105Dorsey Sage · Bend, ORBuilt 1973 · S/N U20602063 N61273Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602067 N61276Sonnys Aviation Inc · Miami, FLBuilt 1973 · S/N U20602069 N61599Freebird Aviation LLC · Eagle, IDBuilt 1974 · S/N U20602350 N625KWSchmoker William C · Eden Prairie, MNBuilt 1974 · S/N U20602635 N66RHBoniek Johann C · Nederland, COBuilt 1972 · S/N U20601873 N67DGD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1974 · S/N U20602375 N67DJSunrise Aero LLC · Nikiski, AKBuilt 1974 · S/N U20602326 N7032QRegistration Pending · Oakwood, OHRegistration pendingBuilt 1976 · S/N U20603067 N70506Roesner Liselotte A · Hilton, NYBuilt 1973 · S/N U20602073 N70594Non-Typical Airplanes LLC · Malad City, IDS/N U20602084 N70598Routh Lucas R · Albert Lea, MNBuilt 1973 · S/N U20602087 N707KWWaters Aero Marine Inc · South Thomaston, MEBuilt 1975 · S/N U20602619 N70810Wrangell Mountain Air Inc · Palmer, AKBuilt 1973 · S/N U20602097 N70822Southern Seaplane Inc · Belle Chasse, LABuilt 1973 · S/N U20602099 N7103QLord Hill Aviation LLC · Snohomish, WABuilt 1975 · S/N U20603073 N710MHK Bay Air LLC · Homer, AKBuilt 1974 · S/N U20602383 N7138QArctic Aviation Leasing LLC · Anchorage, AKBuilt 1975 · S/N U20603074 N7144QJungle Breezes Youth Ministries · East Earl, PABuilt 1975 · S/N U20603075 N71MVVolatile Aero Ventures LLC · Boulder City, NVBuilt 1974 · S/N U20602365 N71PHPlh Air LLC · Post Falls, IDBuilt 1975 · S/N U20602651 N722SJJackson Stephen L · Belvidere, ILBuilt 1976 · S/N U20603361 N731MJLake Chelan Helicopters LLC · Manson, WABuilt 1974 · S/N U20602362 N7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKBuilt 1973 · S/N U20602192 N7476QSmith Keith S · Fredericksburg, TXBuilt 1973 · S/N U20602216 N7487Q206 LLC · Anchorage, AKBuilt 1973 · S/N U20602221 N748KPKalinin Partners LLC · Juneau, AKBuilt 1976 · S/N U20603279 N749RVTime Machine LLC · Kailua Kona, HIS/N U20603480 N74PSOrion Works Inc · Denali Park, AKBuilt 1973 · S/N U20601894 N75DKPaul Mark A · Warren, OHS/N U20603217 N75PJJohnson Peter G · Tower, MNBuilt 1975 · S/N U20602705

Back to Cessna U206F