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.

N50CLLopez Johnny · Henderson, NVBuilt 1976 · S/N 261-76N50CPAtkins Daniel E · Marlette, MIBuilt 1978 · S/N R18200246N50CSBoretsky Bryan F · Lolo, MTBuilt 1961 · S/N 23-1973N50CXChristmas Candy · Angel Fire, NMBuilt 1979 · S/N R18201040N50DCConrad David J · Wausau, WIBuilt 1993 · S/N 282N50DFCargille Joshua C · Kenosha, WIBuilt 1981 · S/N 122550N50DJWest Chester Air LLC · West Chester, PABuilt 1981 · S/N 32-8124021N50DMMiller Cory L · Winnsboro, TXBuilt 1960 · S/N TD-332N50DPRenkel Christopher P · Westlake, OHS/N BROUSSARD 0001N50DTHarrell Ag Aviation LLC · Oak Grove, LABuilt 1975 · S/N 167-75N50EHSands Thomas · Columbia Falls, MTBuilt 2000 · S/N 2083N50ERFisher-Smith Jotham · Soquel, CABuilt 1978 · S/N AA5B0908N50EXBob Hoover Academy · Salinas, CABuilt 1994 · S/N 050N50FABeck Frank · Arvada, COBuilt 1972 · S/N AA5-154N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128N50GWWomack Craig D · Carlsbad, CABuilt 1993 · S/N 20370N50HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020135N50HURovegno Paul C II · Burlington, NCBuilt 1996 · S/N 1320N50HYGrossman David G · Itta Bena, MSBuilt 2000 · S/N 2116N50JAAday B Joe · Las Cruces, NMBuilt 1979 · S/N 18-8009002N50JKPorter Judson · El Paso, TXBuilt 2001 · S/N 25405N50JPPowell John R · Baton Rouge, LABuilt 2013 · S/N 24118N50JTRiba Scott S · Montrose, COBuilt 1960 · S/N 22-7287N50KFBlade Capital Inc · Fort Lauderdale, FLBuilt 2009 · S/N 2035N50KMSexton David · Forney, TXBuilt 1991 · S/N 283N50KRVortex Air LLC · Philpot, KYBuilt 2014 · S/N 2379N50KSShuman Kenneth R · Adrian, MIBuilt 2001 · S/N 20535N50LEFoulk Justin W · Yeagertown, PABuilt 1999 · S/N LE001N50LHRegistration Pending · Pensacola, FLRegistration pendingBuilt 2004 · S/N 81170N50LRHester Truck Sales Inc · Bladenboro, NCBuilt 1995 · S/N 749-95N50MDBeifia Bedia Rafael · Winchester, VABuilt 1984 · S/N PA604N50MHWolpin Stephen A · Santa Paula, CABuilt 1984 · S/N 1403N50MRWhite Gordon · Bulverde, TXBuilt 1993 · S/N 21720N50MXPallozzi Francesco · Chadds Ford, PABuilt 1986 · S/N 0038N50PFMitchell Kenneth A · Uniontown, PABuilt 1984 · S/N 28-8416084N50PGDrawe Richard · Progreso, TXBuilt 1994 · S/N 109575N50PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N AA5B-0287N50PKGuinn Dennis R · Nevada, TXBuilt 1968 · S/N 17701311N50PSExecutive Airshares LLC · St Thomas, VIBuilt 1973 · S/N 31-7405165N50PVVose Robert · Rye, NHBuilt 2009 · S/N PV192N50PWHandi Corner Inc · Sandersville, GABuilt 1978 · S/N 32R-7885045N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087N50RJThomas Ken · Vancouver, WABuilt 2007 · S/N 1N50RNOn Three Angels Wings LLC · Melbourne, FLBuilt 1983 · S/N 31P-8414013N50RSStone Raymond J · Felton, DEBuilt 1977 · S/N 24-0177N50SELenfestey Thomas J Jr · Wasilla, AKBuilt 1974 · S/N 28-7415514N50SUOhio State University · Columbus, OHBuilt 1998 · S/N 17280440N50SWR & O Aviation LLC · Hammon, OKBuilt 1980 · S/N 28-8011098N50TDPa-30 LLC · Appleton, WIBuilt 1965 · S/N 30-827N50THD&J Aviation LLC · Sandy, UTS/N 18267759
Back to AD 87-10-06 R1