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.

N191CCCarter Cleveland M · Willacoochee, GABuilt 1972 · S/N CE-399N191JHJack Henry And Associates Inc · Monett, MOBuilt 1982 · S/N E-2042N191JKN191jk LLC · Brunswick, GABuilt 1982 · S/N E-1943N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720N191WEFs Mickey LLC · East Lansing, MIBuilt 1975 · S/N TE-1059N1928TWalters Jonathan · Malvern, OHBuilt 1990 · S/N CE-1533N1932NChubb Stanley C · Mason, MIBuilt 1973 · S/N CE-417N1949SDovetail Aviation LLC · Wilmington, NCBuilt 1977 · S/N E-1011N194ABennett Jay D · Indian Harbour Bch, FLBuilt 1990 · S/N CE-1465N1950XArgyll Aviation II LLC · Kiefer, OKBuilt 1998 · S/N E3174N1952Wti Aviation LLC · Wilmington, DEBuilt 1984 · S/N E-2176N195FLInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N E-2619N1964ARex Air LLC · Madisonville, LABuilt 1993 · S/N E-2822N1970NDaniel Arthur D · Fishtail, MTBuilt 1969 · S/N E-186N1973Registered aircraftBuilt 1972 · S/N TE-886N1974DN822js LLC · Norcross, GABuilt 1973 · S/N E-493N1975ADayspring Aviation LLC · Bend, ORBuilt 1976 · S/N E-860N1975KFly By Night Management LLC · Downers Grove, ILBuilt 1974 · S/N D-9715N1978SWatson Jeffry T · Colorado Springs, COBuilt 1976 · S/N CE-640N1979Whitley Jason · Southlake, TXBuilt 1979 · S/N E-1568N197DHHintz Donald C · Punta Gorda, FLBuilt 1997 · S/N E-3084N197FMGainey Mark P · San Antonio, TXBuilt 1987 · S/N CE-1131N197RDean Clay · Cleveland, TXBuilt 1974 · S/N E520N1983WTailwinds LLC · Houston, TXBuilt 1988 · S/N E-2423N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936N198STaylor Quarter Circle T Ranch Llp · Taylor, NEBuilt 1978 · S/N E-1161N199KMOrloff Kenneth Lee Trustee · Groveland, CABuilt 1979 · S/N D-10243N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137N199RPId Corporation · Shepherd, MTS/N EA-344N19CAPoulton Bruce A · Fremont, CABuilt 1994 · S/N E-2877N19ESRegistered aircraftBuilt 1980 · S/N TJ-296N19FSCole Properties LLC · Foley, ALBuilt 1983 · S/N TJ-441N19KYChi Yang · Lafayette, COS/N TE-1073N19LLDsr-Cherokee 180 LLC · Dallas, TXBuilt 1970 · S/N E-224N19MNShields Charles F · Gilberts, ILBuilt 1978 · S/N E-1347N19MTDaviation Inc · Willoughby, OHBuilt 1976 · S/N E798N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N19REEtcheverry Ray L · Bakersfield, CABuilt 1970 · S/N CE-299N19RFLynn Air Flying Club Inc · Woodinville, WABuilt 1974 · S/N E-627N19SASierra Aviation LLC · Hendersonville, TNBuilt 1980 · S/N E-1795N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19VChoi Mark · Allentown, PABuilt 1977 · S/N E-1107N1BFRussell Kellum LLC · Saratoga, CABuilt 1973 · S/N TE-961N1BWMbs Ventures Inc · Wilmington, DEBuilt 1977 · S/N D-9963N1DJOwyhee Air LLC · Murphy, IDBuilt 1987 · S/N CE-1116N1EVGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1979 · S/N E-1463N1LXDix Justin T · South Boston, VABuilt 1973 · S/N E-419N1MFNvision LLC · Frisco, TXS/N TH-835N1MQGc4 Aero LLC · Birmingham, ALBuilt 1976 · S/N TH-731N1PHRegistered aircraftBuilt 1983 · S/N CE-1018
Back to AD 87-18-06 R1