OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N96BDRoberts Aircraft Inc · West Chicago, ILBuilt 1974 · S/N TH457N96BMKm Medico LLC · Murrieta, CABuilt 1986 · S/N E-2297N96DWTom Wood Aviation Inc · Fishers, INBuilt 1977 · S/N E-1197N96GBEagle Equity Inc · Valparaiso, INS/N TH-882N96HPCzachor Richard J · Sun City Center, FLBuilt 1975 · S/N E-723N96JKKdk Aviation Ltd · Findlay, OHBuilt 1997 · S/N E-3132N96PSZsp Aviation LLC · Crestview, FLBuilt 1978 · S/N E-1426N96PTEidson Mark C · Weatherford, TXBuilt 1976 · S/N TJ-31N96VWWheatcroft Andrew D · Dallas, TXS/N E-1189N96WRegistered aircraftBuilt 1971 · S/N D-9269N96WEChase Aviation De LLC · Dover, DEBuilt 1996 · S/N TH-1782N96WFBrockman Leland Jay · Horseshoe Bay, TXBuilt 1990 · S/N TH-1595N970GCAurora Skies LLC · Fernandina Beach, FLBuilt 1981 · S/N TH-1313N971PCMaxwell Daniel T · Glenville, PAS/N E-2123N971PDSpyglass Aircraft LLC · Milford, CTBuilt 1997 · S/N TH-1808N971RBleriot LLC · East Hampton, NYBuilt 1993 · S/N E-2831N973PCTennessee Beach Boyz LLC · Soddy Daisy, TNBuilt 1992 · S/N E-2698N973SThompson Peter L · Portales, NMBuilt 2001 · S/N EA-688N974CPSale Reported · Wilmington, DESale reportedBuilt 1975 · S/N TE-1050N9750CJv Aviation LLC · Johnston, RIBuilt 1973 · S/N D-9469N975QCYoung Billy G · Livingston, TXBuilt 1970 · S/N D-9114N975RMclane Norman B · Mesa, AZBuilt 1979 · S/N D-10276N976DSFisher Samuel J · Nahant, MABuilt 1976 · S/N D-9931N976SRMs Baron LLC · Oxford, MSBuilt 2000 · S/N TH-1944N977CTPrecision Aerial Photography LLC · Oceanside, CABuilt 1993 · S/N E-2791N977GFBrown Bear Aircraft LLC · Hartland, MEBuilt 1972 · S/N TH-175N977JLLabrie James R · Southampton, MABuilt 1979 · S/N CE-872N978GKFox Whiskey Inc · Wilmington, DEBuilt 1996 · S/N E-3047N978JGColorado Orthopaedic Outreach Inc · Steamboat Springs, COS/N EA-637N979DMStarnes James W · Beaufort, SCBuilt 1978 · S/N TE-1132N979MAMeisner Aircraft Inc · Burlington, WIBuilt 1978 · S/N E-1294N979SSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N TH-1932N97AHKw Air LLC · Fallbrook, CABuilt 1980 · S/N EA-107N97BKA&D Machinery LLC · Hartsville, SCBuilt 1996 · S/N E-3064N97GWLeft Coast Transport LLC · Largo, FLBuilt 1977 · S/N E-1143N97RTeh LLC · Mccall, IDBuilt 1977 · S/N TK-45N97RSSchiffenhaus Robert · EspooBuilt 1984 · S/N TH-1414N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495N97WSPrestige Worldwide Enterprises LLC · Germantown, TNBuilt 1979 · S/N E-1433N980PADesantis Anthony · Memphis, TNS/N TH-1980N9836PTurbo Property LLC · Clovis, CABuilt 1998 · S/N E-3169N9836SForest Kevin · Langdon, NDBuilt 1998 · S/N E-3210N983DBBunke Jim Bradley · Denver, COBuilt 2000 · S/N EA-657N983GTOne Echo Romeo Inc · Sandy Springs, GABuilt 1988 · S/N CE-1295N984BCRegistered aircraftBuilt 1978 · S/N TH-984N986YDv Aviation Inc · Brainerd, MNBuilt 1985 · S/N E-2233N9876TJr Aviation LLC · Benton, KSBuilt 1975 · S/N E-795N987JSAmerican Star Aviation LLC · Ithaca, NYBuilt 1999 · S/N TH-1923N987KCAsberry Gregg J · Sidney, ARBuilt 1990 · S/N E-2556N987TTEllison Thomas Andrew · Parker, TXBuilt 1993 · S/N E-2776
Back to AD 87-18-06 R1