Skip to content

Registered aircraft · 347

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 ('2073356', '2073315', '2073314')
  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 ('2073356', '2073315', '2073314')
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.

N9489ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1981 · S/N U20606525 N94ELCehula James Douglas · Anchorage, AKBuilt 1977 · S/N U20604131 N9511RBrewer William B · Fairbanks, AKBuilt 1985 · S/N U20606881 N9573ZBangert Richard E III · Seattle, WABuilt 1981 · S/N U20606549 N9583MUsda Aphis Ppq · Edinburg, TXBuilt 1978 · S/N U20604552 N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901 N9613ZAlosanel Charter Inc · Concord, NHFirst renewal noticeS/N U20606575 N9617ZWright William F Trustee · Anchorage, AKS/N U20606578 N9623RUnited States Department Of Interior · Boise, IDBuilt 1985 · S/N U20606906 N9641ZWhitehead Michelle W · Centralia, WABuilt 1982 · S/N U20606592 N9698GCash Jeffery Scott · Gresham, ORBuilt 1977 · S/N U20603826 N9700ZHubbard Tyler · Atlanta, GABuilt 1982 · S/N U20606613 N9711ZT Skye LLC · Yakutat, AKBuilt 1982 · S/N U20606619 N9721ZRwr Inc · Wasilla, AKBuilt 1982 · S/N U20606625 N9725RLongitude 150 LLC · Anchorage, AKBuilt 1986 · S/N U20606950 N9752ZRocky Pointe Logistics LLC · Hayden, IDBuilt 1982 · S/N U20606644 N977GGAds Logistics LLC · Twin Falls, IDBuilt 1977 · S/N U20603828 N9791GAndreshak Thomas G · Bowling Green, OHBuilt 1977 · S/N U20603830 N9798ZWright Air Service Inc · Fairbanks, AKBuilt 1982 · S/N U20606665 N9802ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U206-06667 N9814GNoble Jeremy · Stanwood, WABuilt 1977 · S/N U20603831 N9815ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1982 · S/N U20606678 N9861ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1983 · S/N U20606708 N9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKBuilt 1983 · S/N U20606740 N9924RInzer James Clarence IV · Baton Rouge, LABuilt 1986 · S/N U20606983 N9928NScott J Steve Jr · Itta Bena, MSBuilt 1977 · S/N U20603730 N9932ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606753 N9933ZFreelance Air · Kennesaw, GABuilt 1983 · S/N U20606754 N9934ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606755 N9935RUsda Aphis Ppq · Edinburg, TXBuilt 1986 · S/N U20606988 N9938ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1983 · S/N U20606757 N9939ZRiver Front Akn LLC · Anchorage, AKBuilt 1983 · S/N U20606758 N9940MSofinme LLC · Missoula, MTS/N U20604590 N9941ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606760 N9943ZState Of Maine Department Of Agriculture · Old Town, MEBuilt 1983 · S/N U20606762 N9944RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1986 · S/N U20606993 N9944ZChaparral Air Group · Grapevine, TXS/N U20606763 N9952RBlanchard Ken E · Lumberton, MSS/N U20606997 N9952ZMcdougall Enterprises LLC · Tualatin, ORBuilt 1983 · S/N U20606771 N9957RScg Leasing LLC · Owensboro, KYBuilt 1986 · S/N U20606999 N9959RRusyniak Anthony J · Syracuse, NYBuilt 1986 · S/N U20607000 N9967RBravan Aviation · Fort Lauderdale, FLBuilt 1986 · S/N U20607005 N9970ZHartland Aviation LLC · Hartland, MIBuilt 1983 · S/N U20606783 N9974MAllmen David B · Valley Center, CABuilt 1978 · S/N U20604624 N9981NGagnon Matthew I · Fairbanks, AKS/N U20603745 N9983RHellmann Andrew P · Newark Valley, NYBuilt 1986 · S/N U20607011 N9992ZAdvanced Placement Aviation LLC · Eagle River, AKBuilt 1984 · S/N U20606800

Back to Cessna U206G