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.

N8877DSale Reported · Crystal, MNSale reportedBuilt 1958 · S/N 22-6051 N8877EParrot Flying LLC · San Francisco, CABuilt 1976 · S/N 28-7625162 N8878DHamilton Clyde Leon · Forest, VABuilt 1958 · S/N 22-6052 N8878NCampbell Carl F · Amherst, NHBuilt 1969 · S/N 28-25741 N8879EFlickinger Charles P · Hermitage, PAS/N 28-7625163 N8879JDaddona John M · Oakville, CTBuilt 1965 · S/N 28-2852 N8879NBesheer Susan Anita · Palm Springs, CABuilt 1969 · S/N 28-25743 N8879YWelstad Blaine L · Newburg, NDBuilt 1973 · S/N 18-7409027 N887BCAustin Aviation LLC · Boise, IDBuilt 2023 · S/N 627-2023 N887CCMr Dent Inc · Manheim, PABuilt 1978 · S/N GA7-0044 N8880NAnderson Aviation LLC · Bulverde, TXS/N 28-25744 N8881VLien Ronald N · Gilford, NHS/N 17264240 N8882FCirrus Services Inc · Fargo, NDBuilt 1976 · S/N 28-7715294 N8882VTop Aircraft Leasing LLC · Wilmington, DEBuilt 1974 · S/N 17264241 N8883JRegistration Pending · Midlothian, TXRegistration pendingBuilt 1965 · S/N 28-2857 N8883NWarner Alexander Douglas · Grand Rapids, MIBuilt 1969 · S/N 28-25749 N8884DJ C Aero LLC · Yelm, WABuilt 1958 · S/N 6354 N8884NDubois Jerry · Oklahoma City, OKBuilt 1969 · S/N 28-25750 N8885HHoughton Patrick K · Villa Rica, GABuilt 1961 · S/N 24-2577 N8885JWeise David D · Marion, TXBuilt 1965 · S/N 28-2859 N8887JWeskap LLC · West Grove, PABuilt 1965 · S/N 28-2862 N8888JSnapp Steve J · Los Alamos, NMS/N 28-2863 N8888YPriebe Rodney M · Wasilla, AKBuilt 1973 · S/N 18-7409028 N8889EWestern New York Flying Club Inc · Bowmansville, NYBuilt 1976 · S/N 28-7690214 N8889VGarcia Hector A · Caguas, PRBuilt 1974 · S/N 17264247 N888AGKlingensmith John R · Santa Maria, CABuilt 1998 · S/N 1042 N888APAnderson Scott · Edgartown, MABuilt 1976 · S/N 28-7715105 N888AWCag International Inc DBA · Longmont, COBuilt 1973 · S/N 28-7305386 N888BMDeverapalli Vishnu Reddy · Duluth, GABuilt 1977 · S/N 28-7890282 N888BWAero Elite Inc · Wilmington, DEBuilt 1970 · S/N 28-5856 N888CBBenz James E · Pittsford, NYBuilt 1974 · S/N 17264417 N888CCStevens Terry L · New Plymouth, OHBuilt 1979 · S/N 28-7916324 N888CKRadel James C · Sunbury, PABuilt 1989 · S/N 888PM N888CMKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17267424 N888ERFrost Aviation Alliance LLC · Tampa, FLBuilt 1974 · S/N 28-7505087 N888EZRabideau Jacob N · Tehachapi, CABuilt 1983 · S/N 564 N888GCBachmann Aviation LLC · Marshall, VABuilt 2005 · S/N 3857 N888GHCardinal Gregory Joseph · Minneapolis, MNBuilt 1992 · S/N 52 N888GMStevens Ryan · Presque Isle, MEBuilt 1977 · S/N 28-7716264 N888LHReece Connor I · Green Cove Springs, FLBuilt 1997 · S/N 21045 N888SKKelly Erin C · Bend, ORBuilt 1978 · S/N 7-0407 N888TACurrier Winston F · Monroe, NHBuilt 1975 · S/N 17266196 N888TBBlock Scott · Chandler, AZFirst renewal noticeBuilt 1969 · S/N 17257895 N888TSSeher Jacob Scott · Reno, NVBuilt 2000 · S/N 80556 N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021 N888WTBoatman John Jr · Smyrna, TNS/N K-1 N888ZGNess Aviation LLC · Moriarty, NMBuilt 1974 · S/N 28-7525109 N8890JBlease Ronald B II · Moultrie, GABuilt 1965 · S/N 28-2865 N8890KFgds Aviation LLC · North Fort Myers, FLBuilt 1967 · S/N 28-23761 N8890VBig Q Aviation · Helena, MTBuilt 1974 · S/N 17264248

Back to AD 80-04-03 R2