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.

N9750JBaltz Aviation Services LLC · Mercer, WIBuilt 1967 · S/N 28-3897N9750LLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1986 · S/N 17276608N9750QPurdy Adrian · Missouri City, TXBuilt 1975 · S/N 17265789N9751JR&A Aviation LLC · Flower Mound, TXBuilt 1967 · S/N 28-3944N9751MSchott Milbert F · Richland Center, WIBuilt 1967 · S/N 670045N9751UCox Glenn E · Denton, NEBuilt 1976 · S/N AA5A-0151N97528Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276308N9752BUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1981 · S/N 172RG1012N9752CAero-Sphere Inc · Longmont, COBuilt 1978 · S/N 28-7816524N9752LHickox Richard E · Las Cruces, NMBuilt 1971 · S/N MC-102N9752NDearman Larry · Stonyford, CABuilt 1978 · S/N 7241CN9752QStrojny Andrew P Jr · Strongsville, OHBuilt 1976 · S/N 61P-0370-118N9752UBg Aero Ltd Co · Coyle, OKBuilt 1976 · S/N AA5A-0152N9753UJ&M Aviation LLC · Atkinson, NEBuilt 1976 · S/N AA5A-0153N9753WSeppala Matthew T · Hortonville, WIS/N 28-23236N9754DLaney Charles A · Maiden, NCS/N 22-6668N9754MZiaja Rebecca · Virginia Beach, VABuilt 1967 · S/N 670048N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227N9755JDesroches John · Scottsdale, AZS/N 28-3947N9755LClendenen William M · Spencer, TNBuilt 1975 · S/N MC-104N9755WAncheta Kai A · Anchorage, AKBuilt 1967 · S/N 28-23239N9756JJackson Robert L · Leesburg, VABuilt 1967 · S/N 28-3948N9757JCarbiener Diane M · Kewanee, ILBuilt 1967 · S/N 28-3949N9757LGasper Joseph · New Port Richey, FLBuilt 1972 · S/N M-1378N9757UFairchild James C · Pinson, TNS/N AA5A-0157N9757WTld And Company LLC · Trenton, FLBuilt 1967 · S/N 28-23241N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N9758DEvans Michael K · Nome, AKS/N 22-6672N9758JKiarsis Stephen G · West Wareham, MABuilt 1967 · S/N 28-3950N9759HHavelka Glen C · Boerne, TXBuilt 1981 · S/N 18268001N9759JLazy H LLC · Carleton, NEBuilt 1967 · S/N 28-3951N975AAEmez Holdings LLC · Boca Raton, FLBuilt 1974 · S/N 3175N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121N975BESaucerman & Company LLC · Hampstead, NCBuilt 1996 · S/N 3246040N975BSSaurdiff Benjerman D · Two Rivers, AKBuilt 1979 · S/N 302-79N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718N975DGPhillips Duke · Hyattville, WYBuilt 2000 · S/N 2112N975DSJpm Aviation LLC · Irvine, CABuilt 2009 · S/N 40.1065N975GPSalah Danny · Moraga, CABuilt 2017 · S/N 90975N975LEBlue Borracho LLC · Manitou Springs, COBuilt 1975 · S/N 28-7690001N975LLWoodhouse William H · Power, MTS/N 975N975PKMaisel Chad · Plano, TXBuilt 1971 · S/N 480N975RVArvai Joseph · Elkridge, MDS/N 40976N975SGage Christopher R · Truckee, CABuilt 1999 · S/N 1263-99N975VTDodd Park A · Richmond, VABuilt 2011 · S/N 40309N976Green Alexander · Germantown, TNBuilt 1985 · S/N 673N9760CStreet Steven J · Rochester, MIBuilt 1978 · S/N 28-7816526N9760DDavis Michael P · Midway, UTBuilt 1959 · S/N 22-6675N9760JHanks Cathy J · Danville, KYBuilt 1967 · S/N 28-3953N9760MNeal Alan B · Cherry Valley, CABuilt 1967 · S/N 670054
Back to AD 87-10-06 R1