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.

N8987YHanson William D · Soldotna, AKBuilt 1974 · S/N 18-7409132 N8988JMerkle Hunter T · Mattawa, WABuilt 1966 · S/N 28-3011 N8988RYoung Andrew J · Eagle River, AKBuilt 1960 · S/N 7EC-732 N8988VWahle Daniel C · Missoula, MTBuilt 1974 · S/N 17264344 N8989JJohnston Family Clinic Inc · Meridian, MSS/N 28-3012 N8989XCascadia Aircraft LLC · Sandpoint, IDBuilt 2016 · S/N 001 N898AMWyatt LLC · Hot Springs, SDBuilt 1998 · S/N 1427 N898DANopat LLC · North Charleston, SCBuilt 2000 · S/N 2843377 N898JRKokosa Vernon R · Dennis, MABuilt 1975 · S/N AA5-0706 N898PTitus Aviation LLC · Fresno, CAS/N 28-7515403 N8990FDeon Esterhuizen Inc · Clearwater, FLBuilt 1974 · S/N 640313 N8990JStites Charles Harold · Chapel Hill, NCBuilt 1966 · S/N 28-3014 N8991JCavoto Allyn E III · Adrian, PABuilt 1965 · S/N 28-3015 N8991YWaldemar Mojica · Arecibo, PRBuilt 1974 · S/N 18-7409133 N8992JMid-Atlantic Air Ventures Inc · Richmond, VABuilt 1965 · S/N 28-3016 N8992RBcm Consulting Inc · Wilmington, DEBuilt 1992 · S/N 20605 N8992VFreeze Otis C · Frankston, TXBuilt 1974 · S/N 17264347 N8993DKey James M · Hermiston, ORBuilt 1958 · S/N 18-6397 N8993JHealy Law Offices Pc · Tyler, TXBuilt 1965 · S/N 28-3017 N8993RMiller Scott A · Piney Flats, TNBuilt 1960 · S/N 7GCB-22 N8993VBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 17264348 N8993YAirglas Inc · Anchorage, AKBuilt 1974 · S/N 18-7409135 N8994JBatham Carin C · Yuba City, CABuilt 1965 · S/N 28-3018 N8994RT & H Aviation LLC · Rector, ARS/N 45 N8995DGraham William Franklin III · Port Alsworth, AKBuilt 1958 · S/N 18-6403 N8995JBloomquist Eric R · Phoenix, AZBuilt 1965 · S/N 28-3019 N8996EHooligan Air LLC · Ponce Inlet, FLBuilt 1976 · S/N 28-7690217 N8996VBaumgartner Scot W · Colby, WIBuilt 1974 · S/N 17264351 N8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 18-7409138 N8997DFinley Peter T · Bismarck, NDBuilt 1958 · S/N 18-6405 N8997JKakuska Michael · Madison, WIBuilt 1965 · S/N 28-3021 N8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEBuilt 1974 · S/N 17264352 N8998EGeorgetson Michael J · Sayre, PABuilt 1976 · S/N 28-7690219 N8998JObrien Robert · Warrens, WIBuilt 1966 · S/N 28-3022 N89994Lon Aviation LLC · Aspen, COS/N 18-8510 N8999DPadgett Benjamin C · Anchorage, AKBuilt 1958 · S/N 18-6407 N8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1960 · S/N 7GCB-35 N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353 N899CVJolovich Matthew J · Cheyenne, WYBuilt 2001 · S/N 90040 N899JDMiranda Michael R · Enterprise, ALBuilt 1989 · S/N 856 N89BEToomey Michael S · Newark, OHBuilt 1989 · S/N 1851-L N89BYLickteig David Leo Trustee · Ellensburg, WABuilt 1988 · S/N 2890102 N89DGSale Reported · Martinez, GASale reportedBuilt 1987 · S/N 215 N89DKKubik Darrel J · Boise, IDBuilt 1996 · S/N 1188 N89EMojave Transportation Museum Foundation · Mojave, CABuilt 1980 · S/N 1177 N89HKSale Reported · Greenleaf, WISale reported, pending cancellationBuilt 1989 · S/N 1082 N89HMMiesler Hans U · Penrose, COS/N 1 N89JBEspelien Jay A · Sartell, MNBuilt 1981 · S/N M-2242 N89JMLavoie Kris M · Rancho Cucamonga, CAS/N 2578 N89LCDe Nora Christian G · San Antonio, TXBuilt 1988 · S/N 1634

Back to AD 80-04-03 R2