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.

N7346PIntegrated Avionics Services Inc · Hampstead, MDBuilt 1978 · S/N P21000007N7347NAv8 LLC · Boise, IDS/N U20603624N734HW206 LLC · Portland, ORBuilt 1980 · S/N P21000602N734TMCorporate Air Service Inc · North Salt Lake, UTBuilt 1979 · S/N U20604870N734VSVitatoe Industries Inc · Chillicothe, OHBuilt 1980 · S/N P21000614N734WGStone Aviation LLC · Traverse City, MIBuilt 1980 · S/N P21000615N734WHObermeyer Keith · Excelsior, MNBuilt 1980 · S/N P21000616N734WXRegistration Pending · Kodiak, AKRegistration pendingBuilt 1979 · S/N U20604886N7351UBlue Waves Holding One LLC · Miami, FLBuilt 1977 · S/N 20700415N7357CPerson Donna Mae · Columbus, NEBuilt 1980 · S/N 21063945N7359CAhlem Charles D · Hilmar, CABuilt 1977 · S/N U20603897N735BTPtmm LLC · Columbus, OHBuilt 1979 · S/N U20604898N7361CFocused Holdings LLC · Wellsville, UTS/N U20603899N737ELCsi Flight Services LLC · Mcminnville, ORS/N EA-127N7384CFesco Holdings Inc · Alice, TXBuilt 1980 · S/N 21063951N7386CAgro Engineering Inc · Alamosa, COBuilt 1977 · S/N U20603916N7391PShph LLC · Edwards, ILBuilt 1978 · S/N P21000011N739MCaurus Power Inc · Santa Rosa, CABuilt 1978 · S/N P21000063N73EPColburn & Associates LLC · Woodruff, SCBuilt 1973 · S/N 340-0240N73HW73 Hotel Whiskey Llp · West Fargo, NDBuilt 1979 · S/N TJ-223N73LLT3 Aviation LLC · Oak Point, TXBuilt 1977 · S/N 21062163N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277N740WJAlm Holding LLC · Winton, CABuilt 1979 · S/N 340A0740N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633N74206Chinn Larry · Anatone, WABuilt 1974 · S/N U20602457N742NEPotkulski Daniel M · Locust Grove, GABuilt 1978 · S/N TK82N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658N745EPSumner Michael · Hahira, GABuilt 1974 · S/N 414-0498N746ZXSlater R Winston Trustee · St Charles, ILS/N 21064368N747SBCloud Transport Operations LLC · Kalispell, MTBuilt 1980 · S/N TJ-297N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080N747YVGreat Among The Nations Inc · Beverly Hills, CABuilt 1999 · S/N EA-642N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128N74DTEnjoy Life Flying LLC · Sunrise, FLBuilt 1999 · S/N EA-634N74ESValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N P21000279N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333N74LCLee County Sheriffs Office · Ft Myers, FLBuilt 1972 · S/N 21059755N74MFCarl Raymond Baker LLC · Brenham, TXBuilt 1981 · S/N TJ-397N74MMFief Ron C · Creede, COBuilt 1974 · S/N 21060375N74MTKopair LLC · Saint Louis, MOBuilt 2000 · S/N EA-659N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828N74RMGrimes Taylor · Odessa, TXBuilt 1976 · S/N 21061694N750NTEle Motorsports LLC · Dover, DEBuilt 1978 · S/N U20604230N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030N7532NEagle Air LLC · Morgantown, WVBuilt 1977 · S/N U20603664
Back to AD 89-24-01 R1