OpenAirDocs.org
AD 74-24-09

Registered aircraft · 58

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:74-24-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-24-09')
  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.

N109BGAviation Leasing Group Inc · Wilmington, DEBuilt 1982 · S/N NA0310N10TNPacific Rim Management LLC · Downey, CAS/N 257085N1121RAlbert Lea Airport · Albert Lea, MNBuilt 1969 · S/N 125N118CDFirst Aviation Service Corp · Wilmington, DEBuilt 1977 · S/N NA0212N127HPHagerstown Aviation Museum Inc · Hagerstown, MDBuilt 1959 · S/N 33N141AELake Superior College · Duluth, MNBuilt 1981 · S/N NA0306N179CJIal Corp · Lewes, DES/N 176N184WWRoyal Air Freight Inc · Waterford, MIBuilt 1976 · S/N 352N189RBDodson International Parts Inc · Rantoul, KSBuilt 1972 · S/N 262N18CCTamcar Aviation LLC · Kennewick, WAS/N NA0222N200FJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1980 · S/N 408N200WKSkyview LLC · Wilmington, DEBuilt 1976 · S/N 261N201BRSky Bus Inc · North Miami Beach, FLBuilt 1968 · S/N 166N205DJDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N 399N212XXLegacy Aviation Trust Holdings Corp · Edmond, OKS/N 257093N230TSDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N NA700N234GAviation Buisness Corp · Saint Louis, MOBuilt 1965 · S/N 28N239CDRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 339N23CJGrzechowiak Gary L · Denison, TXS/N 25152N26MEJ Jets Inc · Los Angeles, CABuilt 1982 · S/N NA 0315N2787Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 257208N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222N380CJSkyview LLC · Wilmington, DES/N 380N401USCorsair Two LLC · Hillsboro, ORBuilt 1957 · S/N 45145N404HRBudget Jet LLC · Delray Beach, FLBuilt 1985 · S/N 455N438SJKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438N45KGAircraft Holding Solutions LLC · Newark, DEBuilt 1980 · S/N 257189N4887CDelta Air Transport Heritage Museum DBA · Atlanta, GAS/N 45351N511FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 122N518RRMidas Air Corp · Wilmington, DES/N NA0278N520AWGg Flight LLC · Findlay, OHBuilt 1981 · S/N 453N531FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 113N561PSTlc Aviation LLC · Bloomfield Hills, MIBuilt 1980 · S/N NA-0262N564BRKaleidoscope Charter Services Corp · Kansas City, MOS/N NA0287N600CDKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 377N600RARoyal Air Freight Inc · Waterford, MIBuilt 1984 · S/N 296N604PTR3hd Air LLC · Marietta, GABuilt 1969 · S/N 202N624MPLansing Community College · Mason, MIBuilt 1970 · S/N NA-756N6353CCorsair Two LLC · Hillsboro, ORBuilt 1958 · S/N 45486N700RMFlying Piggs LLC · Klamath Falls, ORS/N 5224N700RRDaxen Logistic LLC · Chino, CABuilt 1978 · S/N NA-0217N704FUK&A Advisors LLC Trustee · Wilmington, DES/N NA0335N710RMFlying Piggs LLC · Klamath Falls, ORBuilt 1977 · S/N 5213N725MKKen Sale Resources Inc · Southlake, TXBuilt 1968 · S/N 5123N72GWFlying Piggs LLC · Klamath Falls, ORBuilt 1976 · S/N 5205N744TZStarling Aviation Services LLC · Lewes, DES/N 2051N7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N NA 0320N777EAMissionary Wings Inc · Litchfield Park, AZS/N 45549N777EHMilligan Michael Zachery · Reno, NVS/N 257020N800GDSkyview LLC · Wilmington, DEBuilt 1977 · S/N 5219
Back to AD 74-24-09