AD 75-09-07

Registered aircraft · 617

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-07')
    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-07')
  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.

N321DDoyle Charles J · Sequim, WABuilt 1974 · S/N AA1B0321N32MLAnderson Seth A · San Marcos, TXBuilt 1972 · S/N AA1A-0350N342ASlater Trevor M · San Mateo, CAS/N AA1B0342N34WLSeaquist Gregory C · Oneida, WIBuilt 1975 · S/N AA1B-0522N3LCStimson Andrew J · Battle Ground, WABuilt 1970 · S/N AA1-0401N3LYBurkey Jeffery C · Stuart, FLBuilt 1973 · S/N AA1B-0287N400NCOkpysh Christina D · Santa Barbara, CAS/N AA1B-0323N4023LCenteno Ramon A · Oak Creek, WIBuilt 1973 · S/N AA1B-0267N41HBWalsh Bowen S · North Augusta, SCBuilt 1969 · S/N AA1-0277N41RCCurtis Craig C · Dacula, GAS/N AA1A-0143N470DWWhitesell Paul Trustee · Plano, TXBuilt 1973 · S/N AA1B-0255N4853LSipos Henry A · Huntington Beach, CABuilt 1973 · S/N AA1B-0110N495WDaniel Zachary T · Mckinney, TXBuilt 1974 · S/N AA1B-0389N513BASong Su H · Duluth, GABuilt 1972 · S/N AA1A-0450N525RTLester Wm Curtiss · Martinsville, VABuilt 1969 · S/N AA1-0207N529JHCoconut Racing Group LLC · North Miami, FLBuilt 1976 · S/N AA1B0669N52TN52t LLC · Pleasant Prairie, WIBuilt 1971 · S/N AA1A-0212N540GTMatthews Guy · Geneseo, NYBuilt 1974 · S/N AA1B-0460N553HBrantley Hugh L · Hazlehurst, GABuilt 1971 · S/N AA1A-0295N5601LManheimer Robert M · Marysville, WABuilt 1968 · S/N AA1-0003N5606LJones Andrew S · Greensboro, GABuilt 1968 · S/N AA1-0008N5612LHolden Jason K · Conroe, TXBuilt 1968 · S/N AA1-0014N5614LFiler Jacob Adam · Clarksville, TNBuilt 1968 · S/N AA1-0016N5615LAnthonson Ronald G · Cortland, NYBuilt 1968 · S/N AA1-0017N5619LEncarnacion Ramon A · Miramar, FLS/N AA1-0021N5620LRichardson Carl · Jonesboro, GABuilt 1968 · S/N AA1-0022N5627LFrattarelli Marco · Carrollton, TXBuilt 1968 · S/N AA1-0027N5631LKing Michael Wayne · Centreville, MDS/N AA1-0031N5632LLas Vegas Aerial Services LLC · Las Vegas, NVS/N AA1-0032N5634LOlson Mitch A · Silver Springs, NVBuilt 1968 · S/N AA1-0034N5635LCentury Air Inc · Fairfield, NJBuilt 1968 · S/N AA1-0035N5636LCrosby Thomas G · Saint Charles, MOS/N AA1-0036N5643LChaney Timothy W · Peoria, AZBuilt 1968 · S/N AA1-0043N5644LMartinez Pedro M · BreeNon-citizen corporation, flight hours not reportedBuilt 1968 · S/N AA1-0044N5645LT2tc LLC · Enka, NCBuilt 1968 · S/N AA1-0045N5646LHutcheson Bruce D · Anthem, AZBuilt 1968 · S/N AA1-0046N5653LUlpiano Amy · Carolina, PRBuilt 1969 · S/N AA1-0053N5657LSkyray LLC · Sugar Land, TXBuilt 1969 · S/N AA1-0057N5658LBores Scott J · Huron, OHS/N AA1-0058N5663LChino Aviation Inc · Chino, CAS/N AA1-0063N5669LGallien Justin A · Livermore, CABuilt 1969 · S/N AA1-0069N5670LCranford Julian Edward Jr · Lexington, NCFirst renewal noticeBuilt 1969 · S/N AA1-0070N5671LJudge Russell M · Newton, NJBuilt 1969 · S/N AA1-0071N5677LDuncan Lincoln · Dix, ILBuilt 1969 · S/N AA1-0077N5680LStackpole Thomas M · Temecula, CABuilt 1969 · S/N AA1-0080N5682LLahlum Steven R · Warroad, MNBuilt 1969 · S/N AA1-0082N5685LFritz Frank M · Milwaukee, WIBuilt 1969 · S/N AA1-0085N5686LBresson Kyle M · Roxbury, CTBuilt 1969 · S/N AA1-0086N5687LDedominici Kenneth · Vero Beach, FLS/N AA1-0087N5688LDolan John C · Sequim, WAS/N AA1-0088
Back to AD 75-09-07