AD 89-18-08

Registered aircraft · 1,772

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:89-18-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-18-08')
  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.

N1366RParodi Carlos Guillermo · Austin, TXBuilt 1975 · S/N AA5-0766N1369RRyals Jon Harris · Billings, MTBuilt 1975 · S/N AA5-0769N1376RParker Brian L · Columbus, GABuilt 1975 · S/N AA5-0776N1377RHendrix David S · Benbrook, TXBuilt 1975 · S/N AA5-0777N1385RCulleton Frederic · Flowery Branch, GABuilt 1975 · S/N AA5-0785N1388RTrybe LLC · Frisco, TXBuilt 1975 · S/N AA5-0788N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798N141ACGann Steve W · Southaven, MSS/N AA5-0743N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84N144RLHanshew James M · Phoenix, AZS/N AA5B1034N148RRDunbar Richard · El Dorado Hills, CABuilt 1978 · S/N AA5B-1008N1502RSale Reported · San Diego, CASale reported, pending cancellationBuilt 1974 · S/N AA5B-0002N1503RBeck Wally J · Davenport, IABuilt 1974 · S/N AA5B-0003N1504RFlying Tiger LLC · Broomfield, COBuilt 1974 · S/N AA5B-0004N1508RAmspoker David A · Kingman, AZBuilt 1975 · S/N AA5B-0030N1515ROwen Ray M · Columbia Station, OHBuilt 1974 · S/N AA5B-0015N1516RMckenzie Pools Inc DBA · Springfield, ORFirst renewal noticeBuilt 1974 · S/N AA5B-0016N1519RSims John · Ingleside, TXBuilt 1974 · S/N AA5B-0019N1520Littler David E · Largo, FLBuilt 1978 · S/N AA5B0957N1520RCastro Jose M · Conway, ARS/N AA5B-0020N1521RPerkins J R III · The Dalles, ORBuilt 1975 · S/N AA5B-0021N1523RDement Myers Michael W · Newberg, ORBuilt 1975 · S/N AA5B-0023N1527RFilkins Barbara L · Fillmore, CABuilt 1975 · S/N AA5B-0027N1529RBall Chad M · Delaware, OHBuilt 1975 · S/N AA5B-0029N1531RMorgan Virginia K · Artesian, SDBuilt 1975 · S/N AA5B-0031N1532RAdkins Todd D · Manassas, VABuilt 1975 · S/N AA5B-0032N1533RAnderson Michael · Byhalia, MSBuilt 1975 · S/N AA5B-0033N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038N1540RPolar Tigers Inc · North Oaks, MNBuilt 1975 · S/N AA5B-0040N1541RHall Daniel · Haskell, OKBuilt 1975 · S/N AA5B-0041N1542RHoose Michael J · Cortland, NYS/N AA5B-0042N1543RHettlinger Eric R · Terre Haute, INBuilt 1975 · S/N AA5B-0043N1545RSanders Harrison S · West Columbia, TXBuilt 1975 · S/N AA5B-0045N1548RJohnson Jimmy G A III · Edmond, OKBuilt 1975 · S/N AA5B-0048N154GRRussell Gregory · Stevensville, MDBuilt 1976 · S/N AA5A-0213N1555RDickenson William P · Lockport, NYBuilt 1975 · S/N AA5B-0055N1558RTaylor Scott Douglas · Bethlehem, CTFirst renewal noticeBuilt 1975 · S/N AA5B-0058N1559RMoore Kira G · Newcastle, CABuilt 1975 · S/N AA5B-0059N155BYYount Brian C · Fullerton, CAS/N AA5-0184N1560RAbria Consulting LLC · New Milford, NJS/N AA5B-0060N1561RKimmerer William J · Berkeley, CABuilt 1975 · S/N AA5B-0061N1562RArnesen Thomas · Sioux Falls, SDBuilt 1975 · S/N AA5B-0062N1568RRobinson Leonard C · Boca Raton, FLBuilt 1975 · S/N AA5B-0068N1572RBurke Kenneth L · Colleyville, TXBuilt 1975 · S/N AA5B-0072N1573RGrand Scott LLC · Okemos, MIBuilt 1975 · S/N AA5B-0073
Back to AD 89-18-08