AD 75-15-08

Registered aircraft · 10,106

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-15-08')
    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-15-08')
  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.

N11766Haig Dennis A · Andover, KSBuilt 1974 · S/N 15075621N1176YMay Jack R · Tallahassee, FLBuilt 1962 · S/N 15059576N11772Pope John P · Chehalis, WABuilt 1974 · S/N 15075624N11775Witzel Daryle L · Porterville, CABuilt 1974 · S/N 15075625N11779Talbert Robert David · Granbury, TXBuilt 1974 · S/N 15075627N11786Barbee Donald L · Columbus, OHBuilt 1974 · S/N 15075631N117DPMccollum Michael T · Camarillo, CABuilt 1950 · S/N D-2321N117TSRegistration Pending · Portland, MERegistration pendingBuilt 1968 · S/N 15069427N117WJMyles Winnfort · Madison, MSBuilt 1973 · S/N 15075427N11815Herman Nicholas A · Lyndhurst, VAS/N 15075645N11816Vanderwal Carter W · Pollock, SDBuilt 1974 · S/N 15075646N11821Rasberry Freddie L Jr · Roby, TXBuilt 1974 · S/N 15075649N11824Aircraft Partner Holdings Inc Trustee · BerlinBuilt 1974 · S/N 15075652N11826Burrows-Mcelwain James Bryan · Martinsburg, WVBuilt 1974 · S/N 15075654N11839Magee Ray C · Shelburne, VTBuilt 1974 · S/N 15075665N1183YCowan Ronnie C · Glasgow, KYBuilt 1962 · S/N 15059583N11840Gard Aviation LLC · Wooster, OHBuilt 1974 · S/N 15075666N11841Amor Aviation LLC · Chapin, SCBuilt 1974 · S/N 15075667N11846Stage Crew LLC · Davenport, FLBuilt 1974 · S/N 15075672N11849Ltf LLC · Soldotna, AKBuilt 1974 · S/N 15075675N1185YWilkerson Gale L · Paris, MOBuilt 1962 · S/N 15059585N11873French Justin T · Broken Bow, NES/N 15075677N11876Evans Ashley Eugene · Elizabeth, COBuilt 1974 · S/N 15075680N11880Carbaugh Nicholas C · Seattle, WABuilt 1974 · S/N 15075683N11883Bedell Samuel G · Fairbanks, AKBuilt 1974 · S/N 15075685N11886Thompson Strawberry Farm Inc · Bristol, WIBuilt 1974 · S/N 15075688N11891Livesay Gregory K · Mc Kinney, TXBuilt 1974 · S/N 15075691N11892Virani Sohail · Euless, TXBuilt 1974 · S/N 15075692N11893Cowand II Jerry H · Merry Hill, NCS/N 15075693N11899Mccrigler Luke N · Fortuna, CABuilt 1974 · S/N 15075696N118DHUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1960 · S/N 17937N118NSagouspe Consulting Services LLC · Hayden, COBuilt 1960 · S/N D-6427N11906Rodriguez Jose · Los Angeles, CABuilt 1974 · S/N 15075701N11909Weaver Craig A · Pickerington, OHBuilt 1974 · S/N 15075703N11910Destefano Dennis C · New Port Richey, FLS/N 15075704N11913Sharkey Peter T · Providence, RIBuilt 1974 · S/N 15075706N11927Omlid Robert · Watford City, NDBuilt 1974 · S/N 15075712N11935Legacy Pilot Training LLC · Annandale, MNBuilt 1974 · S/N 15075713N11936West Yayoi M · Sonoma, CABuilt 1974 · S/N 15075714N11938Johnson William L · Middleburg, VABuilt 1974 · S/N 15075716N11940Elkeberry Morgan T · Sycamore, OHBuilt 1974 · S/N 15075718N11942Puls Kurt V · Valparaiso, INS/N 15075720N11944Weed Ellen M · Gassaway, WVBuilt 1974 · S/N 15075722N11946Solari Michael R · Gilroy, CABuilt 1974 · S/N 15075724N11952Jones William Edward · Scottsdale, AZBuilt 1974 · S/N 15075730N11953Sanchez Chayanne R · Apex, NCBuilt 1974 · S/N 15075731N11957Kopecky Dawn D · Center, NDBuilt 1974 · S/N 15075735N11959Quyser Adil · Edison, NJBuilt 1974 · S/N 15075737N11962Aeroleasing Inc · Medford, ORBuilt 1974 · S/N 15075740N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596
Back to AD 75-15-08