AD 75-01-07

Registered aircraft · 2,118

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-01-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-01-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.

N2267AWilson Ronald W · Bluffton, SCBuilt 1969 · S/N D-9027N2272LBaum Jeffrey · Sheridan, WYBuilt 1976 · S/N D-9944N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523N2283LMoser Jerald L · Tucson, AZS/N D-9948N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949N228QDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N D-8135N2292LGenzoli Steven · Hughson, CABuilt 1976 · S/N D-9947N2295ASemper Primus LLC · Las Vegas, NVBuilt 1969 · S/N D-9039N2296DBonanza Flyers L3c · Murray, UTBuilt 1977 · S/N D-9997N229QMike Lima Partners LLC · Wilmington, DEBuilt 1966 · S/N D-8169N22AGMavridoglou Theo A · Brandon, MSBuilt 1973 · S/N D-9499N22BYDelton LLC · Pembroke Pines, FLBuilt 1964 · S/N D-7609N22NPPayne David · Maryville, TNS/N D-7354N22PKRegistered aircraftS/N D-8647N22QWCaiati Ulysses H · Fresno, CABuilt 1964 · S/N D-7487N22TNNewman William L · Breckenridge, TXBuilt 1965 · S/N D-8032N22VHSchiltz David A · Ankeny, IABuilt 1973 · S/N D-9458N22XFishburn James R III · Wooster, OHBuilt 1966 · S/N D-8064N22XGPixton Thomas J · Incline Village, NVBuilt 1966 · S/N D-8369N231SVinegaroon Aviation LLC · Franklin, TNBuilt 1966 · S/N D-8058N2323AOutdoorsmans Dream LLC · Kalispell, MTBuilt 1969 · S/N D-9032N233GKGoodwin Joseph N · Grass Valley, CABuilt 1968 · S/N D-8777N233RPlane Jane Aviation LLC · Sylvania, GABuilt 1975 · S/N D9811N233SCMattoso Ricardo Q · Spicewood, TXBuilt 1974 · S/N D-9599N2340BHenefeld Mark J · Milton, GABuilt 1964 · S/N D-7451N234DHCarrell Evan Paul · Queen City, TXBuilt 1969 · S/N D-8966N234EBArbuckle James H · Bellevue, NEBuilt 1966 · S/N D-8157N234WBDrake Colin · Mendocino, CABuilt 1969 · S/N D-8952N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085N2354BHigh Sky LLC · Rogers, ARBuilt 1968 · S/N D-8831N23583Ingersoll David K · Trinity, ALBuilt 1978 · S/N D-10087N235RRegistered aircraftBuilt 1966 · S/N D-8360N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088N23609Wiebelhaus John J · Strasburg, COBuilt 1978 · S/N D-10089N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034N239SMelton Michael D · Afton, VABuilt 1965 · S/N D-7893N23AGParker Robert B · Trussville, ALBuilt 1975 · S/N D-9834N23DLKnight Robert T · Baton Rouge, LAS/N D-7363N23RMMurray Michael G · Olathe, KSBuilt 1964 · S/N D-7311N240MBail Air LLC · Port Saint Lucie, FLBuilt 1970 · S/N D-9211N24131Hicks Chad A · Dalhart, TXBuilt 1978 · S/N D-10117N24161Diamond Scenery LLC · Red Oak, TXBuilt 1978 · S/N D-10103
Back to AD 75-01-07