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.

N364TWVo Thien T · Amarillo, TXBuilt 1985 · S/N EA-449N364VKPetts Adam · Waukee, IABuilt 1981 · S/N E-1973N364WPPorter Flying Service · Durham, CAS/N E-1914N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077N365ACEvalidate LLC · Birmingham, MIBuilt 1988 · S/N EA-479N365HPVasi LLC · Dripping Springs, TXBuilt 1980 · S/N E-1756N365RVTwin Oaks Aviation Inc · Pipersville, PAS/N E-1840N3663KEvans And Evans Properties Inc · Santa Cruz, CABuilt 1980 · S/N EA-84N3663QOmalley Edward · Boulder, COBuilt 1980 · S/N E-1691N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N3664TJdm Aviation LLC · Marceline, MOBuilt 1980 · S/N E-1692N3664YWindswept Aviation LLC · North Canton, OHBuilt 1980 · S/N E-1693N36664Strauss Steven Trustee · Tempe, AZBuilt 1980 · S/N EA-89N36665Flynn Michael · Weybridge SurreyBuilt 1980 · S/N E-1696N3666ASandow Dean · Scappoose, ORBuilt 1969 · S/N E-190N36673Gta Air Inc · Addison, TXBuilt 1980 · S/N TH-1143N3668DLkj Holdings LLC · Amarillo, TXS/N EA-92N3668URedmond John L · Santa Clarita, CABuilt 1980 · S/N E-1701N366HPRey Del Cielo LLC · San Antonio, TXBuilt 1974 · S/N E-632N366PSkyway Unlimited Inc · New London, NCBuilt 1997 · S/N E-3099N366PSA-Team Family LLC · Ashland, ORBuilt 1974 · S/N TE-971N366PWEuroaviation Inc Trustee · KematenBuilt 1992 · S/N EA-530N366ZMendel Carl · Port Charlotte, FLBuilt 1975 · S/N E-769N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124N3671FHenson Ronald E · Bonita Springs, FLS/N EA-94N3671MFigvam LLC · New York, NYBuilt 1980 · S/N E-1705N3673RArtie Aircraft LLC · Trenton, MOBuilt 1980 · S/N TH-1150N3673UCastor Care LLC · Mount Pleasant, SCBuilt 1980 · S/N TH-1149N3674GSudduth Ronald C · Lineville, ALBuilt 1980 · S/N TH-1151N3675RCl1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1711N3675TFairbairn Stephen C · Carmel, INBuilt 1980 · S/N E-1672N3676YYesco Administration LLC · Salt Lake City, UTBuilt 1980 · S/N D-10306N36787Manairco Inc · Wooster, OHBuilt 2004 · S/N E-3587N3679ZKlein Eric · Tenino, WABuilt 1980 · S/N E-1730N367BCVc Air LLC · Midland, TXBuilt 1989 · S/N CE-1409N367DMarquardt James H · Warner Robins, GABuilt 1979 · S/N E-1619N367HPN367hp LLC · Aberdeen, SDBuilt 1981 · S/N E-1811N3680RYatra Global LLC · Bedford, MABuilt 1980 · S/N E-1717N3680UMoughon Kirby W · Melbourne, FLBuilt 1980 · S/N E-1718N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157N36829Prime Aviation LLC · Wilmington, DEBuilt 1980 · S/N E-1720N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159N36847Thrash Howard G II · Lubbock, TXBuilt 1980 · S/N EA-115N3684ARegistered aircraftBuilt 1980 · S/N CE-916N3684HAvex X Corp · Coral Gables, FLBuilt 1981 · S/N TE-1180N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298N36855Aerial Digital Images LLC · Huntington Beach, CABuilt 1980 · S/N EA-117N3685WJewell Warren · Seattle, WABuilt 1980 · S/N EA-113N36877Stilwell Aviation LLC · Stilwell, KSBuilt 1980 · S/N EA-119N36884Main Aviation Inc · Visalia, CABuilt 1980 · S/N EA-121
Back to AD 87-18-06 R1