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.

N4886USkycase Leasing LLC · Wasilla, AKBuilt 1979 · S/N U20605144 N4891ZRustair Inc · Anchorage, AKBuilt 1980 · S/N U20606044 N490DBPybus Air LLC · Alpine, UTS/N U20604472 N4939ZStaheli Lee E · Kiana, AKS/N U20606053 N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810 N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055 N4978CRwr Air Inc · Tok, AKBuilt 1977 · S/N U20603870 N4YZLackerdas Harry · Melba, IDBuilt 1977 · S/N U20603702 N507DGLynn John Earl Jr · Anchorage, AKBuilt 1977 · S/N U20603680 N50HWMills Charles K · Hernando, FLBuilt 1978 · S/N U20604558 N50MBCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1980 · S/N U20605577 N5120XZimmerman Tom V · North Pole, AKBuilt 1980 · S/N U20605572 N514TPactolus Investments LLC · Blounts Creek, NCBuilt 1980 · S/N U20605940 N518MJPursuit 53 · College Station, TXBuilt 1981 · S/N U20606535 N5194TBrown Helicopter Inc · Pensacola, FLS/N U206-06660 N51AKSchroth Charles D DBA · Gustavus, AKS/N U20603785 N5200XRwr Air Inc · Tok, AKBuilt 1980 · S/N U20605591 N5293XBaker Leasing LLC · Kotzebue, AKS/N U20605612 N5303XRedemption Inc · Kodiak, AKBuilt 1980 · S/N U20605622 N535AKWilson Thomas Henry III · Anchorage, AKS/N U20604357 N5370UPogany Steve C · Anchorage, AKBuilt 1979 · S/N U20605251 N5371XMarks Max · Cape Elizabeth, MES/N U20605687 N5411XUsda Aphis Ppq · Edinburg, TXBuilt 1980 · S/N U20605727 N5427XRegistered aircraftBuilt 1980 · S/N U20605743 N5428UCordova Air Service Inc · Cordova, AKBuilt 1979 · S/N U20605290 N5433XMk Air LLC · Lewistown, MTBuilt 1980 · S/N U20605749 N545DHaskell Corporation · Bellingham, WABuilt 1985 · S/N U20606892 N5461XState Of Alaska · Anchorage, AKBuilt 1980 · S/N U20605775 N550MGGriggs Matthew J · Tunkhannock, PABuilt 1981 · S/N U20606173 N550ZKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N U20604466 N5525USheriffs Department · Oakland, CABuilt 1979 · S/N U20605311 N5620GWilliams Dean Nelson · San Antonio, TXS/N U20603751 N567JGRapid River Aviation LLC · Boulder City, NVS/N U20604816 N56AKLonghorn Leasing LLC · Anchorage, AKS/N U20605353 N574STState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606116 N5755GDestination Alaska Air Service LLC · Homer, AKS/N U20603758 N5888CCwf Enterprises Inc · Grove, OKS/N U20605888 N600NUN600nu LLC · New Meadows, IDBuilt 1977 · S/N U20603976 N602LTKincaid James B · Hamilton, MTS/N U20605798 N6124ZMulchatna Air Taxi LLC · Dillingham, AKS/N U20606150 N6153ZJaars Inc · Waxhaw, NCBuilt 1981 · S/N U20606162 N6163UMcevoy Steven T · Aniak, AKBuilt 1980 · S/N U20605357 N6166UBb Aviation LLC · Prescott, AZBuilt 1979 · S/N U20605359 N6181ZDittrich James G · Anchorage, AKBuilt 1981 · S/N U20606178 N61PTWings Of Faith Ministries Inc · Tustin, CABuilt 1978 · S/N U20604538 N6238UInland Crop Dusters Inc · Shafter, CABuilt 1979 · S/N U20605393 N6243ZSeattle Seaplanes LLC · Seattle, WABuilt 1981 · S/N U20606199 N626KTRustair Inc · Anchorage, AKS/N U20604426 N6271BCountry Flyin Inc · Homestead, FLBuilt 1977 · S/N U20603839 N628YTAdventist World Aviation · Wilson, NCBuilt 1977 · S/N U20603816

Back to Cessna U206G