OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,243

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.

N36MNKad Enterprises LLC · Everett, WABuilt 1980 · S/N EA-79N36NCrossman Kyle D · Monroe, MIBuilt 1980 · S/N 3350004N36NMFrost Cavin Bert · Odessa, TXS/N EA-316N36PKGoodman Ronald · Dos Palos, CABuilt 2000 · S/N EA-654N36PVLong Wing Aviation LLC · Houston, TXBuilt 2002 · S/N EA-695N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691N36TEGary Vaughan Construction Inc · Leland, MSBuilt 1983 · S/N EA-389N36TKKinsey & Co Inc · Las Vegas, NVBuilt 1985 · S/N EA-444N36TMPendragon LLC · Stuart, FLBuilt 1979 · S/N EA-7N36TRClark Tj · Saint George, UTS/N EA-159N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650N36YBGrey Fox Corp · La Canada Flt, CAS/N EA-331N36YMRankay Air LLC · Sanger, CABuilt 1983 · S/N EA-369N3701NGreat Lakes Aero Marine LLC · Green Bay, WIBuilt 1980 · S/N EA-141N3704GGap Holdings LLC · Dover, DEBuilt 1980 · S/N EA-145N3708KWard Ron · Oklahoma City, OKBuilt 1980 · S/N EA-153N37126Robison Charles T · Pierre, SDBuilt 1980 · S/N EA-156N3714ZQuick Foam Insulation LLC · Lubbock, TXBuilt 1980 · S/N EA-160N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N37236Nay Richard B · Gunnison, UTBuilt 1981 · S/N EA202N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N37285Java Air LLC · Visalia, CABuilt 1979 · S/N 340A0953N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215N37302Elrod Jason A · Seattle, WABuilt 1977 · S/N 340A0334N37306Frescomar USA LLC · Miami, FLS/N 340A0336N37315Atlantic Coast Contractors Inc · Denver, NCBuilt 1977 · S/N 340A0341N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906N37343Bearings & Belts LLC · Carlsbad, NMBuilt 1977 · S/N 340A0358N37356Congregation Rosh Hagivah Inc · Waterbury, CTBuilt 1977 · S/N 340A0364N37360Tkn Holdings LLC · Pima, AZBuilt 1978 · S/N 340A0402N3737Qualitair LLC · MichelstadtBuilt 1985 · S/N 468508060N37376Trans Western Leasing LLC · Sheridan, WYBuilt 1977 · S/N 340A0374N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308N373DHigh Flight Baron LLC · Holland, MIBuilt 1980 · S/N TJ-299N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N373STLassen Peter C · Ventura, CAS/N EA-308N37402Viking Construction Inc · Hayden Lake, IDBuilt 1980 · S/N EA-165N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818N3752CMiller Robert G · Clear Lake, IAS/N 414-0819N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468N3761PSky Rollers LLC · Merritt Island, FLBuilt 1978 · S/N P21000053N376RHSeckel Dean · Mount Vernon, WABuilt 1998 · S/N EA-612N377CFCohen Rolando S · New York, NYBuilt 1974 · S/N 20700275N377JS270 Aviation LLC · Elizabethtown, KYBuilt 1979 · S/N 340A0672N378SStarr William E · Eagle River, AKBuilt 1979 · S/N U20604967N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914
Back to AD 89-24-01 R1