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.

N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421 N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079 N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616 N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130 N1157QRrc Inc · Madison, MSBuilt 1975 · S/N U20602848 N1191VWilmarth Rebecca C · Red Devil, AKBuilt 1974 · S/N U20602506 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832 N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540 N134RFMaverick Jet Leasing Inc · Wilmington, DES/N U20602719 N1361VLeduc Richard · Mazama, WABuilt 1974 · S/N U20602584 N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N1454QDarden Tyson · Wasilla, AKS/N U20602900 N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228 N1542UWarner Walt M · Willow, AKBuilt 1973 · S/N U20602249 N1569USchoolcraft Carl L · West Harrison, INBuilt 1973 · S/N U20602262 N1571UFavero Michael R · Sacramento, CABuilt 1973 · S/N U20602263 N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269 N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719 N164VPConservation Aviation LLC · Washington, DCS/N U20601942 N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501 N171RMMckinney Mark · Meadowview, VABuilt 1972 · S/N U20601938 N1733RNorthstar Holdings LLC · Anchorage, AKBuilt 1973 · S/N U20602068 N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383 N1834QStrohmeyer Gregory Charles · Wasilla, AKBuilt 1975 · S/N U20602941 N1853QSend North · Anchorage, AKBuilt 1975 · S/N U20602943 N1905ULeichtfuss Brad · Lake Havasu City, AZBuilt 1973 · S/N U20602275 N1926UBarrett Michael D · Anchorage, AKBuilt 1973 · S/N U20602287 N1982RLaughlin Michael · Anchorage, AKBuilt 1975 · S/N U20602913 N1998VLedbetter Zachary S · Wasilla, AKBuilt 1973 · S/N U20602035 N2033KAlcyone Trust Corp Trustee · Wichita, KSS/N U20601918 N206DCAri Air LLC · Anchorage, AKBuilt 1976 · S/N U20603198 N206EJSzymanski Collin Andrew Sr · Anchorage, AKBuilt 1974 · S/N U20602507 N206FMoreau Aviation LLC · Wasilla, AKBuilt 1975 · S/N U20603015 N206GRCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601753 N206JMSouthside Truck And Trailers Inc · San Antonio, TXBuilt 1973 · S/N U20602195 N206MMHoistad Rick A · Forman, NDBuilt 1976 · S/N U20603318 N206NMSug-Air LLC · Lubbock, TXS/N U20603132 N206PYGreen Todd · Anchorage, AKBuilt 1975 · S/N U20602795 N206QVan Valin Scott E DBA · Craig, AKBuilt 1976 · S/N U20603259 N206SUNorton Edward H · New York, NYBuilt 1976 · S/N U20603184 N206USKandle Douglas A · Boise, IDBuilt 1974 · S/N U20602628 N206WBOffice Of Aviation Services · Boise, IDBuilt 1973 · S/N U20602058 N206XLVaughn Chris · Decherd, TNBuilt 1975 · S/N U20603035 N208LHOtt Grosvenor LLC · Dillingham, AKBuilt 1974 · S/N U20602642 N212DARegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N U20601901 N2185ULethin Savanna C · Anchorage, AKBuilt 1974 · S/N U20602354 N2216URegistered aircraftBuilt 1974 · S/N U20602355

Back to Cessna U206F