OpenAirDocs.org
AD 87-10-06 R1

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
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.

N5273XToledo Jorge A · Miami, FLBuilt 1969 · S/N 175N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573N5274SHap'S Air Inc · Ames, IABuilt 1980 · S/N R18201534N5274XStallings Aircraft Propeller LLC · Wynne, ARBuilt 1969 · S/N 176N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164N52756Fowler Jon E · Cal Nev Ari, NVBuilt 1943 · S/N 245N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165N5275RNorth Matthew E · Oro Valley, AZBuilt 1978 · S/N R18200641N5275XKirschner David R · Mckeesport, PABuilt 1969 · S/N 177N52766Krobkrua Tio LLC · Snowflake, AZBuilt 2003 · S/N T20608398N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575N5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeBuilt 1962 · S/N 28-323N5276XSanders Curtis E · Morrison, MOBuilt 1969 · S/N 212N5276YPadlock Ranch Co · Ranchester, WYBuilt 2002 · S/N T18208176N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908N5277WPerkins Nathan Zachery · Bonanza, ORBuilt 1962 · S/N 28-325N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488N5278PRoebuck David M · Hamilton, GABuilt 1958 · S/N 24-317N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492N5278SN5278s LLC · Katy, TXBuilt 1970 · S/N 28-26911N5278WJohns Tyler B · Folsom, CABuilt 1962 · S/N 28-326N5278XFisher Bryan S · Galveston, TXBuilt 1969 · S/N 221N5279DDay Aviation Inc · Wilmington, DEBuilt 1979 · S/N 17272489N5279GArnold Jason Mcree · Watkinsville, GABuilt 1979 · S/N 17273558N5279LCarverair LLC · Lakeland, FLBuilt 1967 · S/N 28-4578N5279MTownsend Tod N · White Sulphur Spgs, MTBuilt 1949 · S/N 18-119N5279TDicecco Jennifer · West Chester, PABuilt 1972 · S/N 28-7225386N5279WAmerican Aviator LLC · Arlington, TXBuilt 1962 · S/N 28-328N527ABPriest Justin E · Arlington, WABuilt 1995 · S/N 774N527AWSkyhawk Td LLC · Siloam Springs, ARBuilt 1988 · S/N 1455N527BCYager Greg J · Columbia Falls, MTBuilt 2005 · S/N 22465N527BKShires Patrick O · San Andreas, CABuilt 1978 · S/N 28-7890310N527CGGibbs Tyler · Gilbert, AZS/N 686N527ECRdec LLC · Wilmington, DEBuilt 2020 · S/N 41855N527FPhillips Flying Inc · Saluda, NCS/N 71072N527FLPatterson Roy A · Cameron, TXS/N 28-7125354N527GTSchellhase Walter S · Kerrville, TXBuilt 1980 · S/N 14528N527JBSoutheast Anesthesia Plc · Mcdonald, TNS/N 1243N527JPPerritt John Olin III · Clayton, NCBuilt 2003 · S/N JP-5N527LMacan Ed · Overland Park, KSBuilt 1975 · S/N 28-7505228N527RJGonzales Denise E · Fort Worth, TXBuilt 1996 · S/N 24-3382N527SPRose Arthur K · Florence, ALBuilt 1991 · S/N 849N527TBN527tb LLC · Missoula, MTBuilt 1998 · S/N 4636166N527VMBradley Christopher · Orange, TXBuilt 2002 · S/N 11337N527WPProctor Justin Paul · New Bern, NCBuilt 1968 · S/N 28R-30977
Back to AD 87-10-06 R1