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.

N4198ZMcfarlane Bradley J · Port Alsworth, AKBuilt 1966 · S/N 18-8391N41992Stein Anthony J · Locust Grove, GABuilt 1974 · S/N 28-7415380N41995Columbus State Community College · Columbus, OHFirst renewal noticeBuilt 1974 · S/N 28-7415382N41997Caae Leasing LLC · Lake Zurich, ILBuilt 1974 · S/N 28R-7435235N4199HN4199h Club Llp · Oshkosh, WIBuilt 1978 · S/N 24-0661N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543N4199TEnga James Craig · Madison, SDBuilt 1998 · S/N 18280372N4199ZSymanowski Kevin · Reeder, NDBuilt 1966 · S/N 18-8392N419ACSimmons Scott · Anchorage, AKBuilt 2000 · S/N 408-99N419BCVagabond LLC · Baton Rouge, LABuilt 1982 · S/N 60-8265045N419CCHills Craig · Avon, INBuilt 1979 · S/N 28-7911268N419CMN419cm LLC · Bloomington, ILBuilt 2026 · S/N 43003N419DTurner Spencer A · Modesto, CABuilt 1995 · S/N 20419N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003N419FKlenoski Brian D · Fulton, MIBuilt 2000 · S/N 22690N419GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881176N419JNWheeler Kelly · Columbia Falls, MTBuilt 2017 · S/N 419N419JRRaf LLC · Lenexa, KSBuilt 1995 · S/N 759-95N419LJGowenmleah Jill · Lawrenceburg, TNBuilt 1977 · S/N 32-7840060N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787N419MGAnderson Todd · Bondurant, IABuilt 2007 · S/N 05-503N419PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843413N419PHTaylor Septic Services LLC · Deltona, FLBuilt 1979 · S/N 32-7940039N419RStruthers Robert J · Geneva, ILBuilt 2009 · S/N 0001N419RTPriddy Francis Wayne · Alvord, TXBuilt 1978 · S/N 32R-7887059N419SGilpin Nathan L · Cornelia, GAS/N 419-SN419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003N419SBLipscomb Brian · Fulshear, TXBuilt 1992 · S/N 2811034N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659N419SWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 32-40284N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001N419WPHole Jeffrey Wayne · Stockton, CABuilt 1996 · S/N 1331N419XBellamy William J · Duluth, MNBuilt 1976 · S/N 7048CN41ABBauermeister Aida · Tw 10 SjaBuilt 1991 · S/N 3204N41ACPitts Flying Club Of Stoughton · Stoughton, WIBuilt 1979 · S/N 321GN41AEBowen Haldor S · Sandpoint, IDS/N 24-637N41AGSkyline Agrinautics Inc · Osage, IABuilt 1996 · S/N 768-96N41AMStephens Calvin · Adrian, GABuilt 1974 · S/N 17262980N41APRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268890N41AWWalker James A · Birmingham, ALBuilt 1966 · S/N 28-21385N41BBVagabond Air LLC · Dover, DES/N 6007458061228N41BEVintage Aero Collection Inc · Wilmington, DEBuilt 2007 · S/N 1690N41BJJames Robert D · Anaheim, CABuilt 1991 · S/N 10036N41BKAmerican Classic Aero LLC · Kalispell, MTBuilt 1993 · S/N 1247N41BPSturdevant Harold L Jr · Kalispell, MTS/N 30-644N41CSSanders Aviation Services LLC · Hedgesville, WVBuilt 1996 · S/N 20403N41CVGoldfinger Chris · Albany, ORBuilt 2002 · S/N 160N41DBryson Zachary · Redondo Beach, CAS/N AA5B0993N41DDDurbano David · Jackson, WYBuilt 2017 · S/N CC19-0019
Back to AD 87-10-06 R1