Skip to content

Registered aircraft · 252

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 ('2072818')
  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 ('2072818')
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.

N6XSWhere On Earth Services Inc · Saranac Lake, NYS/N 1851424 N70006Colorado Red LLC · Dillon, COBuilt 1971 · S/N 18501886 N70022Linford Robert M · Spokane, WABuilt 1971 · S/N 18501897 N70026Stephens Brandon J · North Pole, AKBuilt 1971 · S/N 18501901 N70037Bancroft Contracting Corporation · South Paris, MEBuilt 1971 · S/N 18501905 N70048Trident Resources LLC · Chino Valley, AZS/N 18501917 N70070Bay Air Inc · Dillingham, AKBuilt 1971 · S/N 18501939 N70071Bender Charles A Jr · Orrstown, PABuilt 1971 · S/N 18501940 N70083Air Pacific LLC · Port Angeles, WABuilt 1971 · S/N 18501950 N70084Bridges Pamela J · Calais, MES/N 18501951 N70085Embley Kenneth · Anchorage, AKS/N 18501952 N70091Franke Gordon D · Anchorage, AKBuilt 1972 · S/N 18501964 N70097Family Air Tours LLC · Ketchikan, AKBuilt 1972 · S/N 18501982 N70104Duclos Paul R III · Anchorage, AKBuilt 1972 · S/N 18501992 N70112Piper Meridian LLC · Mesa, AZBuilt 1972 · S/N 18501995 N70148Panting Edwin Allan · Anchorage, AKBuilt 1972 · S/N 18502020 N70162Nwops LLC · Woodinville, WABuilt 1972 · S/N 18502028 N70183Cranford Billy J · Wasilla, AKS/N 18502039 N70194Jelinek Spencer T · Erie, COBuilt 1972 · S/N 18502047 N70195Registration Pending · Anchorage, AKRegistration pendingBuilt 1972 · S/N 18502048 N70199Motonaga Gregg K · Soldotna, AKBuilt 1972 · S/N 18502052 N70200Stephl Matt J · Anchorage, AKBuilt 1972 · S/N 18502053 N70206Hayton James B · Sedro Woolley, WABuilt 1972 · S/N 18502057 N70208Jacobson Jack B · Redmond, WABuilt 1972 · S/N 18502058 N70219Ellis James F · Wasilla, AKFirst renewal noticeBuilt 1972 · S/N 18502063 N70221Greer Charles R · Chugiak, AKBuilt 1972 · S/N 18502065 N70230Michel Ross M · Camano Island, WAS/N 18502072 N70232Spencer Brian A · Albion, MIS/N 18502074 N70233Morris Gray S · Chugiak, AKBuilt 1972 · S/N 18502075 N70248L C Hanson Co Inc · Clancy, MTBuilt 1972 · S/N 18502080 N70253Claus Jay G · Palmer, AKBuilt 1972 · S/N 18502082 N70278Cooper Jeffrey A · Anchorage, AKBuilt 1972 · S/N 18502090 N70713Satre Olaf · Kiowa, COBuilt 1971 · S/N 18501878 N748WPParker Charles W III · Anchorage, AKBuilt 1967 · S/N 185-1207 N756ETF&W Construction Co Inc · Anchorage, AKBuilt 1969 · S/N 185-1477 N766MHoddenbach Jim · Woods Cross, UTS/N 18501795 N7703TRegistered aircraftBuilt 1972 · S/N 18502056 N7711LClick Justin T · Hobart, INBuilt 1969 · S/N 185-1521 N771XRanney Dorothy Gayle · Cordova, AKBuilt 1967 · S/N 185-1336 N7767BKline Paul · El Mirage, AZBuilt 1971 · S/N 18501945 N8482DJkt LLC · Douglas, WYBuilt 1968 · S/N 185-1370 N850MGHuston Joe L · Wasilla, AKBuilt 1966 · S/N 1851085 N8536KRegistered aircraftBuilt 1969 · S/N 18501573 N8536TLalonde Terrence E Trustee · Gardnerville, NVS/N 18501784 N85CFSutton Aircraft Salvage LLC · Palmer, AKFirst renewal noticeBuilt 1971 · S/N 18501904 N85SNSn Inc · Seattle, WAS/N 18501844 N860WBWings Of Blessing · Fort Worth, TXS/N 18502013 N863GWWellington Gregory D · Parkman, MEBuilt 1969 · S/N 185-1454 N87TMUniversal Aviation LLC · Macon, GAS/N 18501786 N8993WWagner Mitchell · Northlake, TXBuilt 1969 · S/N 185 1523

Back to Cessna A185E