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.

N54182Nelson Scott M · Eagle River, AKBuilt 1976 · S/N 18-7609043N54184Baros Justin E · Richmond, TXBuilt 1981 · S/N 17274910N54188Fallivene Gary M · Roseland, NJBuilt 1981 · S/N 17274913N5418WWolfers Dennis A · Rough And Ready, CABuilt 1962 · S/N 28-489N54190Shults Shawn O · Meeker, COBuilt 1976 · S/N 18-7609044N54195Decruz Peter John · Hattiesburg, MSBuilt 1974 · S/N 27-7405472N54198Valiair Lc Trustee · Casper, WYS/N 27-7405474N5419FJfl Aviation LLC · Big Rock, ILBuilt 1976 · S/N 28-7790117N5419PTrease Marvin R · Elwood, NEBuilt 1958 · S/N 24-473N5419SAberdeen School District · Aberdeen, MSBuilt 1971 · S/N 28-7125117N541AEHodgson Jerome D · Live Oak, FLBuilt 1996 · S/N 1311N541AMSzmiot Daniel Roy · Marble, COBuilt 2001 · S/N 2153N541BPEdge Aircraft LLC · Denver, COBuilt 1999 · S/N 3257087N541BSDalke Debbie R · Aumsville, ORBuilt 1980 · S/N R18201568N541CAVaughan Aviation LLC · Azle, TXBuilt 1976 · S/N 28-7790089N541CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881050N541DZLarson Alexis Kae · Bismarck, NDS/N 92N541FZExtremeaerosports.Com LLC · Corvallis, ORBuilt 2022 · S/N MXS-003N541GW2 Huskies LLC · Sheridan, WYBuilt 2013 · S/N 91659N541HFOpen Flight Plan LLC · Decatur, GABuilt 1973 · S/N 28R-7335335N541JBHuffman Aviation LLC · Burleson, TXBuilt 1981 · S/N R18201752N541JTThomson Jim · Emmett, IDBuilt 1998 · S/N 24884N541PPatch Philip J · Hollis Center, MEBuilt 1997 · S/N 3707N541PCLegacy Staining LLC · Monroe, GAS/N 1563N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097N541RJSwostar Holdings LLC · Brookhaven, GABuilt 1978 · S/N 28-7911087N541SLCarter Scott P · Dallas, TXBuilt 2009 · S/N 1N541TRegistered aircraftBuilt 2016 · S/N 2207N541VBCartier John · Cumberland, RIBuilt 2003 · S/N 3257334N54203Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17274915N54208Swain Brett L · Las Vegas, NVFirst renewal noticeBuilt 1981 · S/N 17274917N5420HChildress Bradley M · Rolling Prairie, INBuilt 1975 · S/N 17265431N5420LHughes Mormon Byrd · Rhome, TXBuilt 1974 · S/N AA5-0510N5420WGade Donald A · Antioch, ILS/N 28-491N54214Halo Aviation Texas LLC · Fredericksburg, TXBuilt 1981 · S/N 17274922N54219Kleb John S · Aurora, ILBuilt 1981 · S/N 17274925N5421KWings Over Texas Holdings LLC · Denton, TXS/N 17274104N5421LStanfill Michael O · Lucedale, MSS/N AA5-0321N5421SAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8080N5421WBrown David A · Olympia, WAFirst renewal noticeBuilt 1962 · S/N 28-492N54221Emission-Air Inc · Lexington, NCBuilt 1974 · S/N 27-7554014N54223Woodworth Brent J · Halliday, NDBuilt 1976 · S/N 18-7609045N54224Coosa Air LLC · Rome, GABuilt 1974 · S/N 27-7554017N54225Jpr Capital LLC · San Juan, PRBuilt 1974 · S/N 27-7554018N5422QMandeville James R · Bridgewater, MABuilt 1989 · S/N 111N5422SVanwagnen Brian J · Jackson, MIBuilt 1971 · S/N 28-7125118N54233Wenke Donald S · Big Lake, AKBuilt 1976 · S/N 18-7609047N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032N5423ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271854
Back to AD 87-10-06 R1