Skip to content

Registered aircraft · 1,121

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 ('2072821', '2070107')
  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 ('2072821', '2070107')
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.

N8360QU S Department Of The Interior · Boise, IDBuilt 1978 · S/N 18503666 N8367QDashiell Paul · Fairfield, WABuilt 1978 · S/N 18503669 N8373QBassham Clark · Anchorage, AKBuilt 1978 · S/N 18503670 N8375QSt George Edward · Henderson, NVBuilt 1978 · S/N 18503671 N8377QAafedt Aaron B · Belgrade, MTBuilt 1978 · S/N 18503672 N8379QLaumeyer Richard H · Wilson, WYBuilt 1978 · S/N 18503673 N8383QThompson Gordon H · Anchorage, AKBuilt 1978 · S/N 18503675 N8395QN8395q LLC · Ketchum, IDBuilt 1978 · S/N 18503680 N83RBBerning Ron D · Lino Lakes, MNBuilt 1980 · S/N 18504069 N83SSSomd Seaplanes LLC · Lexington Park, MDBuilt 1973 · S/N 18502166 N8400QSpillman Aviation LLC · Colorado Springs, COS/N 18503682 N8401QJoseph Kenneth W DBA · Canton, OHBuilt 1978 · S/N 18503683 N8403QWallace Andrew M · Salt Lake City, UTBuilt 1978 · S/N 18503684 N8414QSkywaggin LLC · Wilmington, DEBuilt 1978 · S/N 18503689 N8425QPerrycook Flight Services LLC · Gig Harbor, WABuilt 1978 · S/N 18503695 N8446QHarms Harvey D · Chugiak, AKBuilt 1978 · S/N 18503704 N8456QHappy Wings LLC · Erie, COBuilt 1978 · S/N 18503707 N8466QAirtime LLC · Dayton, IDBuilt 1978 · S/N 18503710 N84735Christensen Rod C · Fairbanks, AKBuilt 1976 · S/N 18503152 N8484QRohl Eugene A · Soldotna, AKBuilt 1978 · S/N 18503716 N84TMRealm Group Transport Inc · Las Vegas, NVBuilt 1978 · S/N 18503702 N851AKIncline Tahoe Ventures LLC · Incline Village, NVBuilt 1980 · S/N 18504029 N8548QKlein Flying Service Inc · Lawrenceville, ILBuilt 1978 · S/N 18503730 N859DLBryant Charles Martel · Dallas, TXBuilt 1976 · S/N 18503134 N85AJBha Leasing Inc · South Portland, MEBuilt 1977 · S/N 18503424 N85DTPolashenski Christopher · Fairbanks, AKBuilt 1978 · S/N 18503474 N85GH185f LLC · East Troy, WIBuilt 1975 · S/N 18502655 N85JXKahonees Air Service LLC · Bozeman, MTBuilt 1973 · S/N 18502298 N85KAMancini Christopher S · Houston, TXBuilt 1977 · S/N 18503404 N85LCCoyote Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502643 N85LZJacques Jerry J · Iliamna, AKBuilt 1975 · S/N 18502777 N85QAmiculum LLC · Black Eagle, MTBuilt 1978 · S/N 18503703 N85XYWilliams Jerome L · Forkland, ALBuilt 1977 · S/N 18503370 N86109State Of Utah · Salt Lake City, UTBuilt 1976 · S/N 18503153 N861WBWings Of Blessing · Ft Worth, TXS/N 18502340 N862WBWings Of Blessing · Ft Worth, TXS/N 18502381 N863WBWings Of Blessing · Fort Worth, TXS/N 18502624 N864AKNorthern Waters LLC · Livingston, MTBuilt 1980 · S/N 18504066 N86567Ireys Charles G · Tok, AKBuilt 1976 · S/N 18503128 N8659QAlexander Harold W Trustee · West Richland, WABuilt 1979 · S/N 18503755 N866CSGlobal Air Concepts LLC · Anchorage, AKBuilt 1975 · S/N 18502866 N866PHPhobos 185 LLC · Cody, WYFirst renewal noticeBuilt 1977 · S/N 18503167 N86PRAdams Bob L · Chugiak, AKBuilt 1977 · S/N 18503281 N86SSAerobanc Of America Inc · Camarillo, CABuilt 1977 · S/N 18503334 N8700ZBergh Gene H · Roberts, WIBuilt 1975 · S/N 18502896 N8702ZSutton Aircraft Salvage LLC · Palmer, AKBuilt 1975 · S/N 18502897 N8710ZBurnham Kenneth J · Carr, COBuilt 1975 · S/N 18502899 N8717QState Of Alaska · Nome, AKBuilt 1979 · S/N 18503757 N8717ZBoucher Kenneth G · Scotland, CTBuilt 1975 · S/N 18502901 N8722QPrice Scott · Eagle Point, ORBuilt 1979 · S/N 18503758

Back to Cessna A185F