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.

N9288QKarle John F · Long Beach, CABuilt 1971 · S/N E-288N9289QCoutu Bobby L · Plano, TXBuilt 1971 · S/N D-9289N928HBRegistration Pending · New Brunswick, NJRegistration pendingS/N TH-172N928KMSchmoker William C · Eden Prairie, MNBuilt 2001 · S/N EA-672N928RSEzskies Air Service LLC · Hayden, IDBuilt 1978 · S/N TJ-138N9293QChalk 2 Inc · Apple Valley, CABuilt 1971 · S/N D-9293N9296QReichert Aviation Enterprises LLC · El Cajon, CABuilt 1971 · S/N D-9294N929D929 Delta LLC · Dublin, VABuilt 1985 · S/N TH-1453N929JDMake Aviation Great Again LLC · Kalispell, MTBuilt 1987 · S/N E-2387N92FFAircraft 2 Go ! Inc · Wilmington, DES/N TH-1167N92HJWoolley Air LLC · Kilgore, TXBuilt 1991 · S/N TH-1621N92JWKennedy Donald R Jr · New Philadelphia, OHBuilt 1974 · S/N E600N92RWInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N CE-972N92SEN92se LLC · Santa Barbara, CABuilt 1973 · S/N CE-463N92TTKent Oscar Kevin · Lucas, IABuilt 1972 · S/N TH-226N92WWMoran Richard J · Balsam, NCBuilt 1994 · S/N CE-1779N9302QSmith Winston C · Colleyville, TXBuilt 1971 · S/N E-294N9304QK Factor Aircraft Corp · Jupiter, FLBuilt 1971 · S/N D-9296N9309QBehrent Carl D · Granbury, TXBuilt 1971 · S/N D-9295N930AAN930aa LLC · Memphis, TNBuilt 1977 · S/N E-1139N930BDMomentum Air LLC · Brighton, MIBuilt 1973 · S/N TH-307N930DBKropp Christian Trustee · Azle, TXBuilt 1980 · S/N EA-184N930PCTrust Aviation LLC · Columbia, SCS/N E-3442N9310QMc Types II LLC · Jacksonville, FLBuilt 1971 · S/N TH-180N931PCJac Tay LLC · Saint Louis, MOBuilt 2002 · S/N E-3446N9326QLoyd Tracy · Broken Arrow, OKBuilt 1971 · S/N TH-186N933ARah Aviation Inc · Fort Myers, FLBuilt 1991 · S/N CE1568N933JL&N Aviation LLC · Wilmington, DEBuilt 1990 · S/N CE1448N933TMPlanet Aviation LLC · Pinehurst, NCS/N CE-1744N9343QMorris Mark · Jasper, GABuilt 1971 · S/N D-9304N934PCBennell Ltd LLC · Naples, FLBuilt 2002 · S/N E-3448N934VFinke Wailes · Charleston, MSBuilt 1975 · S/N D-9739N9351QBaldwin Joseph · Stow, MABuilt 1971 · S/N CE-351N9352QVoges Airlines LLC · Millstadt, ILBuilt 1971 · S/N CE-352N935JWGross Todd D · Minden, NVBuilt 1982 · S/N E-1945N9361Q61q LLC · Brookfield, WIBuilt 1971 · S/N CE-359N9363QPearson James Clyde · Lake Junaluska, NCS/N CE-360N936ACBiggs Aircraft East LLC · Deland, FLBuilt 1971 · S/N CE-336N936PHataway Clayton Scott · Leesburg, VABuilt 1985 · S/N E-2244N936SIrving Holdings LLC · Greensboro, NCBuilt 1999 · S/N E-3258N936SAHalpin Cuyler · Lewisville, TXBuilt 1999 · S/N E-3277N936VN936v LLC · Knoxville, TNBuilt 1975 · S/N E-686N936WDCorporate Velocity Inc · Pawleys Island, SCBuilt 1997 · S/N E-3130N9370QS & L Skyview Aviation LLC · Wilmington, DEBuilt 1972 · S/N CE-361N9371QAshe Industries LLC · Murrieta, CABuilt 1972 · S/N D-9309N9379QSale Reported · Pottsboro, TXSale reportedBuilt 1972 · S/N E-305N937DJBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N CE-626N937WB7wb LLC · Middletown, DEBuilt 1989 · S/N CE-1421N9380QRegistered aircraftBuilt 1972 · S/N CE-363N9385QOxer James E · Lake Placid, FLBuilt 1970 · S/N TH-49
Back to AD 87-18-06 R1