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.

N5175SBlu Skye Distribution Inc · Mount Holly, NCBuilt 1970 · S/N 28-7105029N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443N5176HBoyer Christopher A · Anchorage, AKBuilt 1948 · S/N 14-196N5176LMilliner Greg A · Kokomo, INBuilt 1967 · S/N 28-4462N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044N5176SNora Jet LLC · Granbury, TXS/N 28-7105030N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153N5176VVangorder Donna · Greenwood, ARS/N 172RG0459N51770Lrh Equipment LLC · Pendleton, ORS/N 445N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2N5177FPray Aviation Inc · Augusta, KSBuilt 1976 · S/N 28-7715096N5177HPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 1975 · S/N 17265361N5177PLi Steven Y · Warren, NJBuilt 1958 · S/N 24-197N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212N51782Ranger Lumber Corp · Springfield, MABuilt 2002 · S/N 18281096N51784Winingar Thomas M · Brock, TXBuilt 2002 · S/N 18281097N51785Photos Unlimited · Rancho Cordova, CABuilt 2002 · S/N 18281098N51787Holder Michael T · Whitesburg, GABuilt 1980 · S/N 1172N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2N5178AHale Mitchell D · Chugiak, AKBuilt 1962 · S/N 18-7483N5178HGage Scott M · Anchorage, AKS/N 14-200N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464N5178RHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17263395N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213N51790Tartock Russell L · Salisbury, NCBuilt 1979 · S/N AA5A-0850N51793Lindsey Richard A · Richmond, TXBuilt 1980 · S/N 17274347N5179BCorporate Flight Intl LLC · Glenwood Springs, COBuilt 2002 · S/N T18208137N5179CPersonal Air Transportation Inc · Wilmington, DES/N 31-7401252N5179HFlight Time Builders Inc · Memphis, TNBuilt 1975 · S/N 17265362N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199N5179VFairmont State University · Fairmont, WVBuilt 1980 · S/N 172RG0460N5179XKor Reese W · Piedmont, SDBuilt 1969 · S/N 189N517APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843753N517AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020046N517ATHodgson Christopher John · Santa Cruz, CABuilt 2017 · S/N 41237N517BWWomer Blaine A · Hemet, CABuilt 2007 · S/N 2843652N517DLDelta Leema Aviation LLC · Moncks Corner, SCBuilt 1977 · S/N 17268965N517EASchafer Erich S · Fremont, MIBuilt 1975 · S/N 27-7554125N517FDJoyner James M · Eagle River, AKBuilt 2001 · S/N 3257263N517GSPtag Flight Service LLC · Vidalia, GABuilt 1996 · S/N 2996N517HHart James A · Arlington, VABuilt 2021 · S/N 42219N517HWVogt Chancey · Becida, MNBuilt 2023 · S/N JA1308077N517JGollus Daniel T · Lockport, NYBuilt 1997 · S/N 22753N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098N517KBCorkins William J · Auburndale, FLBuilt 2025 · S/N 3300N517LBuchenroth Steven L · Huntsville, OHFirst renewal noticeBuilt 1969 · S/N BP1N517MMMiller Jeremy M · Hazle Township, PABuilt 1978 · S/N 32R-7885191
Back to AD 87-10-06 R1