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.

N8155ASkylane Ventures LLC · Keizer, ORS/N 310R0025N8166GRohrer John D · Belmont, CABuilt 1993 · S/N EA-546N8167KHues Oulton A · Norwood, MABuilt 1993 · S/N EA-547N816GHSteim Joseph M · Shirley, MABuilt 1978 · S/N 310R1507N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635N817GCMountain View Aeromotive Inc · Del Norte, COBuilt 1975 · S/N 310R0264N817JPOdom Johnny C · Fredericksburg, TXBuilt 1976 · S/N 414-0850N817NMWest Bound Hound LLC · Sheridan, WYBuilt 1979 · S/N EA-27N817RMOmega Metals Inc · Douglasville, GABuilt 1981 · S/N EA-203N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501N818JPN818jp LLC · Los Angeles, CABuilt 1984 · S/N 46-8408047N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095N819DKBankston David P · Horseshoe Bay, TXBuilt 1983 · S/N EA-387N81AJAircraft Propulsion Leasing LLC · Holland, OHBuilt 1976 · S/N TK-12N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794N81RYRedding Dermatology Medical Group Inc · Redding, CABuilt 1981 · S/N 340A1238N81TBMalachi Leasing Co · Wilmington, DEBuilt 1978 · S/N TJ-147N81VRRaviele Vincent · Richmond, TXBuilt 1986 · S/N P21000868N820AHBuffaloe Thomas N · Mancos, COBuilt 1981 · S/N U20606123N8215MJnk Equipment LLC · Deer Harbor, WABuilt 1993 · S/N EA-548N8223QBas Part Sales LLC · Greeley, COS/N 414-0153N822MBLx7 Air LLC · Newark, DES/N 4608086N822VWWetherbee Rodney A · Florence, ORBuilt 1978 · S/N 340A0630N8234MFontenot Shane B Dr · Jennings, LABuilt 1991 · S/N EA-520N8237QAircon LLC · New Franklin, OHBuilt 1974 · S/N 340-0524N8241NSpecial Services LLC · Magnolia, DEBuilt 1991 · S/N EA-522N8243QAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 414-0173N8249MRancho Bonito LLC · Oxnard, CABuilt 1977 · S/N 21062039N824BCAonvo Investment LLC · North Miami, FLBuilt 1977 · S/N 340A0306N824MAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1981 · S/N P21000763N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411N8259AParisien Robert · Bow, NHS/N EA-529N8263GFitzpatrick Dennis B · Mccall, IDBuilt 1977 · S/N U20603784N8263VPrecision Service Mtr Inc · Addison, ILBuilt 1990 · S/N EA-504N8264QMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1975 · S/N U20603125N826MTG T Acft Inc · Franklin Square, NYBuilt 1979 · S/N TK-109N8274QBravo Delta II LLC · Steamboat Springs, COBuilt 1976 · S/N U20603135N8275QAbel Derek R · Rio Vista, CABuilt 1976 · S/N U20603136N827RPJireh Aviation LLC · Zeeland, MIBuilt 1980 · S/N P21000541N828PMRobinson Shannon D · Fair Oaks Ranch, TXBuilt 1987 · S/N 4608057N828RJNielsen Ron E · Lindon, UTS/N 21063836N828SBEa Aircraft Lease LLC · Dayton, MNS/N EA-111N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154N8299ZCoachair Inc · Groveland, CABuilt 1993 · S/N EA-545
Back to AD 89-24-01 R1