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.

N1870WMahoney Michael A · Daphne, ALBuilt 1973 · S/N E-435N1872LFreeman Gary M · Richmond Hill, GABuilt 1976 · S/N CE-648N1873LJanzen Mark · Chico, CABuilt 1976 · S/N D-9892N18748Board Of Trustees Of Southern Illinois Univ · Carbondale, ILS/N TH-875N1874LRegistration Pending · Dover, DERegistration pendingBuilt 1976 · S/N CE-649N18752Morgantown Flying Club LLC · Morgantown, WVBuilt 1977 · S/N TH-877N1875LRib-Cjr Aero LLC · Los Altos Hills, CABuilt 1976 · S/N E-852N1875WN1875w LLC · Nashville, TNBuilt 1973 · S/N E-437N18760Twinfin LLC · Port Orange, FLBuilt 1977 · S/N D-10070N18763Registration Pending · San Jose, CARegistration pendingBuilt 1977 · S/N E-1158N1876WHeadsets Incorporated · Amarillo, TXBuilt 1973 · S/N CE-443N1877LShrauner Reid E · Elkhart, KSBuilt 1976 · S/N E-857N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13N187CSNorris Marvin D · Georgetown, TXBuilt 1999 · S/N E-3232N1880LSouth Regional Aviation Enterprise · Boynton Beach, FLBuilt 1976 · S/N D-9894N1885WS35s LLC · Stevens Point, WIBuilt 1973 · S/N D-9485N1886W86 Whiskey Corporation · Vineland, NJBuilt 1973 · S/N E-441N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N1891WSchwartz Eric · Timnath, COBuilt 1973 · S/N E-440N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897N1893LHarlan Blake · Trinity Center, CABuilt 1976 · S/N E-863N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N18998Duffer Management LLC · Carlsbad, CABuilt 1977 · S/N D-10073N189CRPelco Investments Inc · Wilmington, DEBuilt 1981 · S/N TE-1187N189FTeag Leasing LLC · Edmonds, WABuilt 2001 · S/N EA-680N18AWayman Ian A · Medford, ORS/N CE-629N18BEStarkey Thomas David · Nashville, TNBuilt 1977 · S/N CE-726N18DRBurns Donald N DBA · Watkinsville, GABuilt 1978 · S/N E1228N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18KFNelco Inc · Blanchard, OKBuilt 1978 · S/N E-1251N18LLPiping Technology Consultants Inc · Monee, ILBuilt 1978 · S/N E-1332N18MJFleeman Julie · Laguna Niguel, CABuilt 1978 · S/N E-1250N18RBDuval Kenneth M · Richardson, TXBuilt 1973 · S/N CE-461N18SCSpencer Clyde V · Queen Creek, AZBuilt 1977 · S/N TJ-111N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860N18XBecker James · Crystal Lake, ILBuilt 1978 · S/N E-1353N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754N1903LN1903l LLC · Jacksonville, FLBuilt 1976 · S/N D-9900N1909L52 Foxtrot Aviation LLC · Billings, MTBuilt 1976 · S/N D-9901N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804N1911JD M C Aviation LLC · Jennings, LABuilt 1971 · S/N E-298N1912LRegistered aircraftBuilt 1976 · S/N E-866N1913LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N CE-656N191BFKoziura Sebastian · Evanston, ILBuilt 1991 · S/N CE-1577
Back to AD 87-18-06 R1