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.

N9415CSouthwest Plane Holdings LLC · Kalispell, MTBuilt 1983 · S/N T30300176N94202Gilsdorf David R Trustee · Pleasant Hill, MOBuilt 1974 · S/N 21060536N94203Frasier Air Inc · Tulsa, OKBuilt 1974 · S/N 21060537N94227Dodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N 21060549N94244Bryant Kenneth D · Black Diamond, WAS/N 21060559N94263Hitch Aviation Inc · Malta, MTBuilt 1974 · S/N 21060569N9426KO Max Aviation · Willowbrook, ILBuilt 1974 · S/N 21060572N942CPV1 Holdings LLC · Morgan Hill, CABuilt 1977 · S/N TK-61N9439YR C S Drilling Company Inc · West Lake Hills, TXBuilt 1981 · S/N 21064505N944DHSouth Delta Aviation Inc · West Helena, ARBuilt 1981 · S/N P21000712N944PACrebbs Ben H · Tucson, AZBuilt 1982 · S/N EA-300N945BGDavis James H · Corpus Christi, TXBuilt 1980 · S/N 421C-0870N945RCR&C Aviation Partners LLC · Tucson, AZBuilt 1978 · S/N P21000084N9465YWof Investments LLC · Dover, DES/N 21064515N9469CKinetic Concepts LLC · Pensacola, FLS/N 310R1419N9475RVon Imhof Rudi F · Anchorage, AKBuilt 1985 · S/N U20606872N9476CZulu Echo Assets LLC · Port Washington, NYBuilt 1982 · S/N T30300179N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679N9483YSioux Falls Technology LLC · Sioux Falls, SDBuilt 1981 · S/N 21064520N9488CGalloway Christopher · Davis, CABuilt 1982 · S/N T30300180N9493ZCcf Ventures Inc · Bangor, MEBuilt 1981 · S/N U20606527N9496MRegistered aircraftBuilt 1970 · S/N 21059396N9498YRamsgate Ltd · Sedalia, COBuilt 1981 · S/N 21064522N9499YMilhouse Richard J · Aguila, AZBuilt 1981 · S/N 21064523N949LHappy Mangos LLC · Anchorage, AKBuilt 1982 · S/N U20606639N94MACox Dennis J · Beach City, TXBuilt 1986 · S/N 46-8608056N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245N94PSBrierley Michael G Trustee · Sparks, NVBuilt 1980 · S/N P21000469N94RWWithers Dana Ruth Executor · Mount Vernon, ILBuilt 1981 · S/N 414A0662N94WMGrowth Caddie LLC · Vero Beach, FLBuilt 1988 · S/N 4608114N9502YBci Aviation LLC · Arroyo Grande, CABuilt 1981 · S/N 21064525N950DCParmelee Charles G Trustee · Reno, NVBuilt 1982 · S/N EA280N950PSPlane Services LLC · Twin Falls, IDS/N EA-337N950SRAcme Aero LLC · Kingman, KSBuilt 1979 · S/N 21063698N9528YHunt William R · Tucson, AZBuilt 1981 · S/N 21064538N9529CSilver Lining Carpet Care & Restoration LLC · Tallahassee, FLS/N T30300185N9531BLash Trucking LLC · Goleta, CABuilt 1979 · S/N 21063175N9533YN9533y Corp Trustee · Wilmington, DEBuilt 1981 · S/N 21064539N9535YSpectra Q LLC · Las Vegas, NVBuilt 1981 · S/N 21064540N953DMMainline Services Co · Wilmington, DEBuilt 1976 · S/N 340A0205N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749N954PWWeckbacher Paul J Jr · Inverness, FLBuilt 1981 · S/N U20606288N9556ZIsland Aircraft LLC · Anchorage, AKBuilt 1918 · S/N U20606543N955WGReich Stephen B · Kentfield, CABuilt 1978 · S/N P21000185N956EALopez Fabio · Denver, NCBuilt 1976 · S/N 340A-0085N9577YShort Notice Inc · Pensacola, FLBuilt 1981 · S/N 21064552N958PDrew Jensen Inc · Lincoln, NEBuilt 1978 · S/N TJ-139N958PBMo Elite Air LLC · Rolla, MOBuilt 1981 · S/N TJ-392N959DCKpp Air LLC · Navasota, TXBuilt 1980 · S/N 340A0942N959RHRd Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 414A0217
Back to AD 89-24-01 R1