Skip to content

Registered aircraft · 40,471

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N9876QRegistered aircraftBuilt 1975 · S/N 17265820 N9876VDelhotal Raymond K · West Brooklyn, ILBuilt 1974 · S/N 17264541 N9876WFoster John D · Grapevine, TXBuilt 1967 · S/N 28-23396 N98772Solberg Aviation Co Inc · Whitehouse Station, NJBuilt 1985 · S/N 17276347 N98774Simplifly LLC · Mesa, AZBuilt 1985 · S/N 17276349 N98776Melbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276350 N9877BAndra Joshua Corey · Riverton, UTBuilt 1982 · S/N 172RG1066 N9877DAdams Bob L · Eagle River, AKBuilt 1959 · S/N 18-6899 N9877GRowse Larry G · Plain City, OHBuilt 1971 · S/N 17259777 N9877UNaval John A · Auburn, WABuilt 1976 · S/N AA5A0277 N9878GRoyal Aviation Academy LLC · Sarasota, FLBuilt 1971 · S/N 17259778 N9878QNesland Patricia M · Burton, WAS/N 17265822 N9878URock N Roll Flying Club LLC · Omaha, NEBuilt 1976 · S/N AA5A0278 N9878WBenton Michael L · Gilbert, SCBuilt 1967 · S/N 28-23398 N9878YWaterman David N · Amery, WIS/N 7KC-3 N98792Stanzione Daniel F · Antelope, CABuilt 1985 · S/N 17276355 N98795Richmor Aviation Inc · Scotia, NYBuilt 1985 · S/N 17276357 N9879DGlenwood Farm LLC · Edgerton, MOBuilt 1959 · S/N 18-6901 N9879QCoker Design Group LLC · Campobello, SCS/N 17265823 N987ACKnight Tracy D · Reno, NVBuilt 2004 · S/N 987 N987BBTime Building LLC · Lake Oswego, ORBuilt 1988 · S/N 1004 N987EDupre Alan A · Shelbyville, KYBuilt 1990 · S/N 01 N987JBCassill Aircraft Leasing Inc · Cedar Rapids, IAS/N 987JB N987PGriffith Robert G · Sacramento, CABuilt 2001 · S/N 2133 N987TReady Aim Flyer LLC · New Castle, DES/N TD-405 N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780 N9880QAircraft Resource Center Inc · Lakeville, MNBuilt 1975 · S/N 17265824 N9880WJuhl Aaron · Overland Park, KSBuilt 1967 · S/N 28-23400 N9880YMerrick Shane · Redgranite, WIBuilt 1961 · S/N 7GCB-73 N98811Kadena Aero Club · Apo Ap, CABuilt 1985 · S/N 17276359 N98819Oxford Flying Club Inc · Oxford, CTBuilt 1985 · S/N 17276362 N9881GFortenberry Robert N · Pascagoula, MSBuilt 1971 · S/N 17259781 N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192 N9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeBuilt 1975 · S/N 17265825 N9881UChristensen Myra J Storms · Pierre, SDBuilt 1976 · S/N AA5A0281 N9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1974 · S/N 17264544 N98824Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276363 N9882DUsda Aphis Ws Atoc · Cedar City, UTBuilt 1959 · S/N 18-6904 N9882UNordbye Newell · Eden Prairie, MNBuilt 1976 · S/N AA5A0282 N9883GLagor Mark D · Parshall, NDBuilt 1971 · S/N 17259783 N98843American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276367 N9884DMartensen Marten · Anchorage, AKS/N 18-6905 N9884GBarbour John P · Dexter, MOBuilt 1971 · S/N 17259784 N9884PVandegriff Cody E · Eagle River, AKBuilt 1976 · S/N 18-7709007 N9884VShockley James F · Loves Park, ILBuilt 1974 · S/N 17264546 N9884YRoberts Colton C · Bluebell, UTS/N 7GCB-119 N98851Jacques Jerry Joseph · Iliamna, AKS/N 18-7188 N9885DBarney Jeff S · Fairbanks, AKS/N 18-6907 N9885PTriple Cub Aviation LLC · Greenbush, MIBuilt 1976 · S/N 18-7709008 N9885QAngel Aviation Inc · Peoria, AZBuilt 1975 · S/N 17265829

Back to AD 80-04-03 R2