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.

N2049ASouth Delta Aviation Inc · West Helena, ARBuilt 1978 · S/N E-1405N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190N2049ZObie Edgar L · Chinook, MTBuilt 1978 · S/N E-1398N204GAirmart Inc · Lexington, KYS/N TH-2042N204LPSteffenhagen Julian L Jr Trustee · Tustin, CABuilt 1988 · S/N CE-1262N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601N2050NPerks Andrew · Weatherford, TXBuilt 1978 · S/N E-1429N2050YSomerville Elizabeth M · West Dennis, MABuilt 1978 · S/N CE-826N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198N2051WLeiwant Alan J · Montville, NJBuilt 1978 · S/N E-1410N2051XArana Carlos · The Woodlands, TXBuilt 1978 · S/N E-1411N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247N2057ADesruisseaux Kemens · Clarksville, TNBuilt 1978 · S/N E-1420N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85N2058KCollins Jimmy · Spring, TXBuilt 1979 · S/N TK-66N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159N2059XK Wings LLC · Golden Valley, MNBuilt 1978 · S/N TH-994N205AGWing Men LLC · Cleveland, OHBuilt 1974 · S/N TH-516N205KTMha Interests LLC · Spring, TXBuilt 1981 · S/N TH-1286N205SAConner Brian J · Davenport, CAS/N EA-273N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173N20603Burlington Air Center Inc · Burlington, WIBuilt 1978 · S/N D-10207N2061AMckinney James C · Whitefish, MTBuilt 1978 · S/N E-1425N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161N2062BWalker Marshall E · Lancaster, SCBuilt 1979 · S/N D-10205N2063CKhumbu Flying Club · Wilmington, DEBuilt 1979 · S/N CE-838N2063GHolman Allen S · Knoxville, TNBuilt 1979 · S/N TH-1002N2064VGta Air Inc · Addison, TXBuilt 1979 · S/N TH-1004N20654Spatz Phillip D · League City, TXBuilt 1979 · S/N D-10212N2065QShalom Isaac R · New York City, NYBuilt 1979 · S/N E-1436N2065YAbel Instruments Inc · Riviera Beach, FLBuilt 1979 · S/N D-10211N2066ASky Time LLC · Wilmington, DEBuilt 1979 · S/N E-1431N2066NBobo Kenneth · Auburndale, FLBuilt 1979 · S/N D-10215N2069KFiloteo James · Woodinville, WABuilt 1978 · S/N TK-74N2069YBeach Helicopter Services LLC · Chesapeake, VABuilt 1979 · S/N TK-76N206CWAgri Med LLC · Belgrade, MTBuilt 1978 · S/N CE-836N206GPAdaptive Aero Inc · Wilmington, DEBuilt 1978 · S/N CE-754N206TMPale Horse LLC · Mishawaka, INBuilt 1975 · S/N E-775N2070LBaron 70 Lima LLC · Modesto, CABuilt 1976 · S/N TH-753N2071YRossiter Brahm J · Lemoore, CABuilt 1997 · S/N E-3120N2073LBravo Wings II LLC · Grants, NMBuilt 1976 · S/N TJ-73N2076LWhaley Keith · Pigeon Forge, TNBuilt 1976 · S/N E-869N2079LPlatinum Aviation LLC · Belvidere, TNS/N E-872N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308N207ZCBuha Holdings LLC · Paris, TXS/N E-3360
Back to AD 87-18-06 R1