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.

N8740QHampton Harvey E · Simms, MTS/N U20603493 N8754QD2 Holdings LLC · Salt Lake City, UTBuilt 1976 · S/N U20603507 N8755QMartensen Marten · Anchorage, AKBuilt 1976 · S/N U20603508 N8763QArtic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1976 · S/N U20603516 N8788QKochert Timothy B · Anchorage, AKBuilt 1975 · S/N U20602730 N888JNLeis Steven S Trustee · Ansonia, OHBuilt 1975 · S/N U20602999 N888WCStephens Milton D · Birmingham, ALBuilt 1975 · S/N U20602893 N899AHAerospace Asset Holdings LLC · Wilmington, DES/N U206-01940 N915NGWillard Theron K · Anchorage, AKBuilt 1975 · S/N U20602946 N9183JRuggiero George J · Whitney Point, NYS/N U20601857 N942JMPogany Steve C · Chugiak, AKBuilt 1976 · S/N U20603365 N947ETGranite State Aerial Topography LLC · Wolfeboro, NHBuilt 1973 · S/N U20602271 N9513GThomas David · Boise, IDBuilt 1971 · S/N U20601713 N9514GP51d Mustang LLC · Bigfork, MTBuilt 1971 · S/N U20601714 N9515GRegistration Pending · Kenai, AKRegistration pendingS/N U20601715 N9518GKomer Thomas B Jr · Woodburn, ORBuilt 1971 · S/N U20601718 N9554GMorse Donald · Priest Lake, IDBuilt 1972 · S/N U20601754 N9563GLitzen Guide Service · Kenai, AKBuilt 1972 · S/N U20601763 N9572GJones Robert D Jr · Chugiak, AKBuilt 1972 · S/N U20601772 N9574GKreiner Kurt · Rch Palos Vrd, CABuilt 1972 · S/N U20601774 N9575GGolden Eagle Outfitters · Delta Junction, AKBuilt 1972 · S/N U20601775 N9585GBillmyer Services Inc · Friday Harbor, WABuilt 1972 · S/N U20601785 N9595GRegistration Pending · Wantage, NJRegistration pendingBuilt 1972 · S/N U20601795 N9608GCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601808 N9610GChoice Aviation LLC · Hamilton, MTBuilt 1972 · S/N U20601810 N9626GFly 2 Crp LLC · Cleveland, TXBuilt 1972 · S/N U20601826 N9644GKatmai Air LLC · Anchorage, AKS/N U20601844 N9655GMiddle Fork Aviation Inc · Challis, IDBuilt 1972 · S/N U20601855 N969SBBostyancic Stanley J · Cohasset, MNBuilt 1975 · S/N U20602724 N993PPCc Bar Ranch LLC · Texarkana, TXBuilt 1975 · S/N U20602634

Back to Cessna U206F