OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,007

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.

N300LW2340 LLC · Hellertown, PAS/N 62P09138165039N300MConway Frank P · Sneads Ferry, NCBuilt 1978 · S/N 24-0630N300MDHeywood Bruce N · Panguitch, UTS/N 400N300MKAgricultural Tours LLC · Kahuku, HIS/N 1151N300MMHamblin Kenneth · Stanton, TNBuilt 1965 · S/N 30-851N300MN10 G LLC · Kalispell, MTBuilt 2000 · S/N 120N300MPVictoria'S Wings LLC · Melbourne, FLBuilt 1975 · S/N 61P-0227-030N300MXCrimson Aviation LLC · Helena, MTBuilt 1998 · S/N 060N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206N300PG3 Star Aviation LLC · Miami, FLS/N 104N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501N300QRPdq Flight Inc · Garden City, NYBuilt 1979 · S/N 17273539N300RASharper Media LLC · Irvine, CABuilt 1993 · S/N 27-0166N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841N300RFRivers Robert A · Oxford, NCBuilt 1983 · S/N BJ-2N300RGRein Richard C · St George, UTS/N AA5A-0159N300RJTcj Kqc LLC · Robstown, TXBuilt 1976 · S/N 32R-7680286N300RMHiscall Enterprises Inc · Dickson, TNBuilt 1970 · S/N 32-7140003N300RVHall Farms Inc · Garfield, KSBuilt 2003 · S/N 24740N300RWWilliams Ray L · Chapmansboro, TNS/N 01N300SBGustafson Cody A · Corvallis, ORBuilt 1993 · S/N 001N300SKKayrouz Sebastien V · Richardson, TXBuilt 1978 · S/N R18200663N300SXSpencer Scott V · Washington, UTBuilt 2006 · S/N 38N300TFSouthern Cross Aviation Inc · Wilmington, DEBuilt 1978 · S/N 1001N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226N300UMMurray Air LLC · Patoka, ILBuilt 1982 · S/N 32R-8213043N300UPNeo Terra Aviation LLC · Setauket, NYBuilt 2005 · S/N 1199N300VCReam Real Estate LLC · York, PAS/N 2106N300VMDavis Laramie · Canyon, TXBuilt 1976 · S/N 32R-7780120N300VTCarroll James K · Klamath Falls, ORBuilt 1999 · S/N DM0276N300WBarn Miami Inc · Miami, FLBuilt 1995 · S/N 010N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294N300WDPlane Fun Inc Tr Trustee · Snellville, GAS/N 5081N300WEK & S Aero LLC · West Chester, PABuilt 1979 · S/N 32R-7985007N300WFAmoth Kurt J Trustee · White Salmon, WABuilt 1997 · S/N 18280015N300WLRosen Robert D · Lewisville, NCBuilt 1977 · S/N 32R-7780474N300WSOdyssey Aviation LLC · Raleigh, NCBuilt 1992 · S/N 687-92N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280N300XASale Reported · Henderson, NVSale reportedBuilt 1990 · S/N 021N300XTExtra300 LLC · Anchorage, AKBuilt 1991 · S/N 023N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167N3010GJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeS/N 18013CN3010KGoodwin David · Edinburg, NYBuilt 1978 · S/N 28-7911086N3010TBb Air Corp · Tulsa, OKBuilt 1979 · S/N 32-7940060N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961N30112Leonard Kevin J · Wagner, SDBuilt 1968 · S/N 17701066N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076N30116Registration Pending · Benson, AZRegistration pendingBuilt 1968 · S/N 17701068
Back to AD 87-10-06 R1