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.

N24183Smither Tom M · Marietta, GABuilt 1978 · S/N D-10107N24195Barrett Group LLC · Farwell, TXBuilt 1978 · S/N D-10110N242FFThomas Leslie R · Kosse, TXBuilt 1971 · S/N D-9220N242SFCurtin Christopher C · Ashburn, VABuilt 1977 · S/N D-10064N2435ACooper Timothy J · Spearman, TXBuilt 1969 · S/N D-9036N244JNShepherd Jacob · Lake Havasu City, AZBuilt 1964 · S/N D-7698N2458ALeger Bryan · Gulf Breeze, FLBuilt 1969 · S/N D-9038N246WBToavs Brent J · Wolf Point, MTBuilt 1969 · S/N D-8951N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337N24LSickels Henry C · El Cajon, CABuilt 1964 · S/N D-7503N24WKCannizzaro Charles DBA · North Syracuse, NYBuilt 1967 · S/N D-8431N250GWasalo And Luby Air LLC · La Fayette, GABuilt 1967 · S/N D-8600N250TCGroth William B · Hixson, TNBuilt 1969 · S/N D-9048N25632Struck Larry G · Gardnerville, NVS/N D-9435N25633Paolercio Alan D · Grants Pass, ORBuilt 1973 · S/N D-9438N25662Atcnavion LLC · Hinckley, OHBuilt 1973 · S/N D-9522N25717Vaadi LLC · Babson Park, FLBuilt 1973 · S/N D-9542N25719Brunner Robert L · Jefferson, ORBuilt 1973 · S/N D-9540N258TCDunn Mark A · Lufkin, TXBuilt 1966 · S/N D-8351N259JHall James A · Bozeman, MTBuilt 1973 · S/N D-9430N259TTaylor Ted H · Corsicana, TXBuilt 1967 · S/N D-8664N25BTFernandez Sergio R · Port Saint Lucie, FLBuilt 1981 · S/N D-10373N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841N260AACarpenter Timothy A · Phoenix, AZBuilt 1966 · S/N D-8325N2667Marlow Air LLC · Gilmanton Iw, NHBuilt 1965 · S/N D-7997N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045N2701TGray Stephen T · Lafayette, CAS/N D-8436N2714TVertical Flight Leasing LLC · Wilmington, DEBuilt 1967 · S/N D-8438N2717AMitchell Matthew · Roanoke, TXBuilt 1969 · S/N D-9049N2720TMiller Mark · Bellevue, WABuilt 1967 · S/N D-8441N2721TGalvin Peter · Laytonsville, MDBuilt 1967 · S/N D-8443N2722AMontgomery Douglas Tanner · San Antonio, TXBuilt 1969 · S/N D-9050N2728TMilk Ranch LLC · Stephenville, TXBuilt 1967 · S/N D-8447N2729TWasileski David J · Auburn, NYS/N D-8451N272MSHinkle Paul · Broken Arrow, OKBuilt 1964 · S/N D-7429N272SBofinger Jr John M · Hewitt, NJBuilt 1965 · S/N D-8002N2731TFocus LLC · Missoula, MTBuilt 1967 · S/N D-8454N2735TWhite Michael W · Key Largo, FLBuilt 1967 · S/N D-8455N2736TM & N Leasing Co · Marietta, GAS/N D-8458N2739TPickering Kevin P · Lakeland, TNBuilt 1967 · S/N D-8457N2740AMcdaniel Joseph Stewart II · Henderson, TXS/N D-10113N2746TFranklin Ronald C · Las Vegas, NVBuilt 1967 · S/N D-8460N2749TCaudle Nathan · Fort Worth, TXBuilt 1967 · S/N D-8475N274HSWebb Alan J · Medford, ORBuilt 1976 · S/N D-9922N274SScott Joseph Brian · Sarasota, FLBuilt 1966 · S/N D-8329N2753AThomas Dale A · Gooding, IDBuilt 1969 · S/N D-9052N27550Anderson Herman A · Basalt, COBuilt 1967 · S/N D-8465
Back to AD 75-01-07