AD 75-09-13

Registered aircraft · 4,787

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

N4AFN4af LLC · Conroe, TXBuilt 1968 · S/N 421-0142N4AHHand Kevin D · Anchorage, AKBuilt 1982 · S/N U20606655N4ARN4ar LLC · Marienthal, KSBuilt 1979 · S/N P21000273N4CGAffordable Avionics Ind DBA · Chino, CABuilt 1965 · S/N T210-0033N4GKDalessandro Janet E · Park Falls, WIBuilt 1975 · S/N 310R0219N4HAArrington Harold M · Detroit, MIBuilt 1984 · S/N T30300283N4LFMacys Flying Service Inc · Tulelake, CABuilt 1977 · S/N U20603705N4MCCoberly Adrian R · Manhattan, KSBuilt 1984 · S/N TJ-461N4MUBlusky Properties & Investments LLC · Cameron, MOBuilt 1970 · S/N 421B0054N4VWPronk Glen R · Crittenden, KYBuilt 1974 · S/N 21060277N4YYWilliams Scott Griffin · Salt Lake City, UTBuilt 1979 · S/N 21063553N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N5005JDowding Industries Inc · Eaton Rapids, MIBuilt 1974 · S/N 310R0129N500AWMcnulty Kim E · Tehachapi, CAS/N 310R0077N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N500CHAchiro David P · Truckee, CABuilt 1976 · S/N 310R0734N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585N500WPWelker Franklin W · Agoura, CAS/N EA-582N501DCExecutive Aviation LLC · Peoria, AZBuilt 1981 · S/N 340A1267N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21N501SFNomarco Inc · Woodburn, ORS/N 21061808N5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLBuilt 2001 · S/N EA-677N5026VPiland Kenneth Eldon Jr · Carlsbad, CABuilt 1975 · S/N 21060822N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547N502RARichland Aviation Inc · Sidney, MTBuilt 1977 · S/N 4040066N5037QSayler Ben · Thief River Falls, MNBuilt 1971 · S/N 340-0012N5038JKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 310R0158N503ATRegistered aircraftBuilt 1975 · S/N 21060924N5047JAir Transport Arm Of Christ Inc · Hurst, TXBuilt 1975 · S/N 310R0167N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232N505CNLes Amis Air LLC · Dorado, PRBuilt 1978 · S/N 414A0201N505LTLaufer Air Inc · Hartford, WIBuilt 1978 · S/N 421C0617N505SFLux William E · Newman Lake, WABuilt 1977 · S/N 340A0261N5061QLepper Michael J · Ward, COBuilt 1971 · S/N 340-0017N5062HCoati Aviation LLC · San Diego, CABuilt 1967 · S/N D-8379N5072CThomas Robert Allan Jr · Phoenix, AZBuilt 1978 · S/N 310R1414N5073CInternational Air Services Inc Trustee · Carson City, NVS/N EA-667N5075YAlkota Of Kansas LLC · Wichita, KSBuilt 2001 · S/N EA-675N507HHGrossetete Nugget S · Edgewood, NMBuilt 1980 · S/N P21000481N5083JKrs Aerial Inc · Galloway, OHS/N 310R0203N5083TClaar Brian · Spring, TXBuilt 1982 · S/N EA-287N5083WJtc Investments LLC · Tyrone, GABuilt 1980 · S/N P21000635N5089C5089c LLC · Fairhope, ALBuilt 1979 · S/N 21063701N508TCFisher Travis L · Odessa, TXBuilt 1982 · S/N 21064741N50901United Indian Missions Inc DBA · Tucson, AZBuilt 1973 · S/N U20601951N5091CMartin Steven J · Phoenix, AZBuilt 1982 · S/N T30300132N5098QM&L Engine LLC · Schriever, LABuilt 1971 · S/N 340-0024
Back to AD 75-09-13