OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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-24-01-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:89-24-01-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.

N87481Petersen Donald W · Bullhead City, AZBuilt 1976 · S/N 310R0587N87536Krull Jesse L · Bismarck, NDBuilt 1981 · S/N 340A1254N8756QTriple 2 LLC · Burlington, COBuilt 1976 · S/N U20603509N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605N8792KTornado Venture Once LLC · San Antonio, TXBuilt 1980 · S/N 340A0985N87CGPro Aire Cargo & Consulting Co Inc · Oshkosh, WIBuilt 1975 · S/N 402B0883N87JSLvyqt LLC · Menlo Park, CABuilt 1988 · S/N EA-476N87MMKing Randall · Palestine, TXBuilt 1980 · S/N 210-63980N87RDDougs Glass Shop Inc · Bridgewater, CTS/N 46-08069N87RJNorris Aviation LLC · Mansfield, TXBuilt 1976 · S/N 310R0676N87RRBahnair LLC · Oklahoma City, OKS/N TJ-34N8801GAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1980 · S/N 340A0986N880AMj Aviation LLC · Denham Springs, LABuilt 1973 · S/N 414-0397N881PJJohnson Patrick Allen · Olive Branch, MSBuilt 1973 · S/N 310Q0754N881TJBarron Eddie T · Amarillo, TXBuilt 1972 · S/N 414-0259N8823HBowers Phillip P · Clayton, NCBuilt 1970 · S/N 21059314N882BCTechnology Aviation Services LLC · Covington, GABuilt 1973 · S/N 414-0470N8851KJac Leasing LLC · Fort Myers, FLBuilt 1979 · S/N 414A0239N88521Godfrey Pharis · Missouri City, TXBuilt 1981 · S/N 340A1260N8853K8853k LLC · New Bedford, MABuilt 1979 · S/N 414A0240N88549Seed Richard J IV · Holmes Beach, FLBuilt 1981 · S/N 340A1261N88555Iverson Douglas B · Sammamish, WABuilt 1981 · S/N 340A1262N8856KHerrmann Alan J · Laguna Niguel, CABuilt 1981 · S/N 340A1264N8857KBall Bearing Aviation LLC · Lowell, ARBuilt 1979 · S/N 340A0642N886ALHogue James B · Spencer, TNBuilt 1986 · S/N 4608037N886BATerzo Richard E · Lake Zurich, ILBuilt 1981 · S/N 340A1269N886KHLexi Air LLC · Boise, IDBuilt 1977 · S/N 21061727N887WQuad City Area Flying Eagles Inc · Milan, ILBuilt 1975 · S/N 21060976N888BPXyz1234 LLC · Addison, TXBuilt 1979 · S/N 340A0737N888CAInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 468408030N888EAAustin E H Jr · San Antonio, TXBuilt 1976 · S/N U20603286N888ECArrow Aviation LLC · Noblesville, INS/N P21000076N888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeBuilt 1973 · S/N 421B-0421N888HFFlight1 Hsw LLC · Norwood, COBuilt 1981 · S/N P21000658N888HLPermian Basin Blue Sky Inc · Odessa, TXBuilt 1985 · S/N 46-8508081N888JWRedd Brand Aviation LLC · Twin Falls, IDBuilt 1986 · S/N P21000872N888KBAarons Plumbing LLC · Grand Ledge, MIBuilt 1973 · S/N 21059894N888KPRunway 321 LLC · Hilton Head Island, SCBuilt 1977 · S/N 310R0918N888MBsa Vending · Rohnert Park, CABuilt 1981 · S/N EA-262N888MTSpelts Mark Warren Trustee · Chico, CABuilt 1979 · S/N 340A0763N888NNorman James R · San Diego, CABuilt 1973 · S/N 340-0312N888PJPatterson Edward · Midland, TXBuilt 1981 · S/N 21064244N888SALyman Joseph Scott · Kimberly, IDBuilt 1978 · S/N 21062542N890CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1978 · S/N 402C0006N893BWLahbak Enterprises LLC · Hilton Head Island, SCBuilt 1980 · S/N P21000498N8941GHawks Eye View LLC · Roanoke, VAS/N 340A0327N894JGMeasured Approach LLC · Wooster, OHBuilt 1972 · S/N 340-0098N895ACTejas Cavu LLC · Wilmington, DEBuilt 1978 · S/N 340A0558
Back to AD 89-24-01 R1