Registered aircraft · 72,010

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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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:87-10-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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.

N5496WMaddux Dawayne E · Weeki Wachee, FLBuilt 1962 · S/N 28-582 N54972Snider Scott E · Turner, MTBuilt 1976 · S/N 18-7709027 N5497LCardelli Steve V · San Bruno, CABuilt 1973 · S/N AA5-0397 N5497SVerbovskiy Vitaliy Viktorovich · Clovis, NMBuilt 1980 · S/N R18201589 N5497WJethro Charter Flights LLC · Jacksonville, NCBuilt 1962 · S/N 28-583 N54983Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275098 N5498HGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 17265468 N5498PC & J Ventures LLC · Center, COS/N 24-559 N5498WBas Part Sales LLC · Greeley, COS/N 28-584 N54990Hoffman Maurice M · Bowdle, SDBuilt 1976 · S/N 18-7709035 N5499PLabelle Consulting Group Inc · OntarioBuilt 1958 · S/N 24-561 N5499WVerchick Peter A · Jacksonville, FLBuilt 1962 · S/N 28-495 N549ACWhitaker James C · Washington, NCBuilt 2001 · S/N 449-2000 N549BCMitchell Rosemary · Harbour IslandNon-citizen corporation, flight hours not reportedS/N 20608052 N549BKBarenfeld Marc F · Angels Camp, CABuilt 2000 · S/N 001 N549JBBlue Bird Aviation LLC · Ocean City, MDBuilt 1980 · S/N 31-8052108 N549JTPas Aviation Inc · Modesto, CAS/N 5339 N549MAHinkle Airspray Inc · Cavalier, NDBuilt 2005 · S/N 1384-2005 N549RVDelzell David Wayne · Heath, TXBuilt 2009 · S/N 70515 N549SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881341 N549TSAggregate Material Services LLC · Van Nuys, CABuilt 2006 · S/N 11075 N549WSBoraam Aviation Inc · Prospect Heights, ILBuilt 1997 · S/N 3246073 N549ZWMartin Riley J · Talkeetna, AKBuilt 2026 · S/N 1 N54AJDietz Daniel James · Springville, IABuilt 1980 · S/N 61P-0769-8063383 N54ALSouthshore Aviation LLC · Oklahoma City, OKBuilt 1976 · S/N 61P-0326-092 N54AWWilson Cecil P · Lithonia, GABuilt 1974 · S/N 27-7405392 N54BCloud Nine Ventures LLC · Riverview, FLBuilt 1956 · S/N 22-4150 N54BAEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1888 N54BG54 Bravo Golf LLC · Austin, TXS/N 32R-7887079 N54BWWalker D B · Rougemont, NCBuilt 1976 · S/N 18-7609069 N54CBCb Wings LLC · Eugene, ORFirst renewal noticeBuilt 1994 · S/N 3064 N54CSO'Shea James · West Grove, PAS/N 1808 N54CTBrubaker Calvin · Midvale, UTBuilt 2020 · S/N 40212 N54DLMorris Samuel A · Prineville, ORBuilt 1976 · S/N 28-7690213 N54ELCascade Air LLC · Trout Run, PABuilt 1989 · S/N 1809026 N54EMAvirone Ltd · Monsey, NYBuilt 1998 · S/N 18280399 N54FDDefibaugh Fred M · Chino Valley, AZBuilt 2005 · S/N 3823 N54GACrosswind Leasing LLC · Prescott, AZBuilt 2003 · S/N 10128 N54GDCulpepper Mark D · Chapmansboro, TNBuilt 2003 · S/N 006 N54GMCiommo William J · Spring Hill, FLBuilt 1975 · S/N 1 N54HMSky West Aviation Inc Trustee · Albuquerque, NMS/N 1754 N54HRAshcraft Matthew Q · Abbott, TXS/N RV-4#1751/HARMON ROCKET#01 N54HSHenderson State University · Arkadelphia, ARBuilt 1998 · S/N 17004C N54HYEngler Eric M DBA · Cass City, MIS/N 2130 N54JASan Carlos Flight Center Inc · San Carlos, CABuilt 1998 · S/N 17280607 N54JMAviation Institute Of Maintenance · Virginia Beach, VABuilt 1968 · S/N 17257026 N54KAPoint To Point Air LLC · Arlington, WABuilt 1978 · S/N 32-7840197 N54KHHertenstein Kevin Wayne · Lutz, FLBuilt 1979 · S/N 17272726 N54KKTemple Donald G · Amarillo, TXBuilt 2004 · S/N 1577 N54KPScheuers Alan · Murfreesboro, TNBuilt 2005 · S/N 18281542

Back to AD 87-10-06 R1