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.

N4847JLittle River Corp · Anchorage, AKBuilt 1966 · S/N D-8346N4850JCardamone Rayner Mark Gibson · Manistique, MIBuilt 1966 · S/N D-8345N4852JStoffel Christopher David · Colorado Springs, COS/N D-8349N4853JNaca 130 LLC · Cameron Park, CABuilt 1966 · S/N D-8350N4856JN4856j LLC · Boulder, COBuilt 1967 · S/N D-8536N4871JGray Robert R · Granbury, TXBuilt 1966 · S/N D-8356N4889JRegistered aircraftBuilt 1967 · S/N D-8424N488FDLittleton Darrell D · Atlanta, TXBuilt 1968 · S/N D-8700N4894JCapri Blue Aviation LLC · Norcross, GABuilt 1967 · S/N D-8430N4896JMyshatyn Michael · Eaton, COBuilt 1967 · S/N D-8435N48KUWildcat Aviation LLC · Wilmington, DEBuilt 1979 · S/N D-10303N48LFKraxberger Scotty L · Salida, COBuilt 1964 · S/N D-7489N48MHSeventh North Hangar LLC · Bolton, MAS/N D-9184N48RSColin A Oerton · Miami Beach, FLBuilt 1966 · S/N D-8250N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140N499DSDelta Sierra Aviation · Wilmington, DEBuilt 1967 · S/N D-8316N499MBCook Joshua D - Trustee · Nashville, TNBuilt 1964 · S/N D-7587N49PGVasiloff Mark · Barberton, OHBuilt 1967 · S/N D-8452N49TRVincent T Remcho Phd LLC · Corvallis, ORBuilt 1974 · S/N D-9628N4FHWall Jacob · Grapevine, TXBuilt 1976 · S/N D-9973N4HHAndrews Terry · Camp Verde, AZS/N D-8422N4JXCosta James J · Tulare, CABuilt 1974 · S/N D-9642N4WRShoemaker David J · Menlo Park, CABuilt 1967 · S/N D-8497N4XPPazdziora Ronald G · St Charles, ILBuilt 1982 · S/N D-10401N500PFHumphries Stephen A · Kingwood, TXBuilt 1964 · S/N D-7484N506HPPedden Patrick M · Fort Wayne, INBuilt 1969 · S/N D-9073N5092NMill-Run LLC · Lewes, DES/N D-9893N509JMRegistered aircraftBuilt 1980 · S/N D10352N50BDGoodrich Gilbert Joseph · Katy, TXS/N D-8175N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141N50ZTackes Steven · Carson City, NVBuilt 1969 · S/N D-8929N510CHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9999N512BDTurbo Aviation LLC · Chesterfield, SCS/N D-9398N514CSTomco Stores Ltd · Ruidoso, NMBuilt 1964 · S/N D-7533N514PCParsons Donald E · Clarksville, TNBuilt 1969 · S/N D-8967N516WClearwater Holding LLC · Parkersburg, WVBuilt 1975 · S/N D9744N517KGRegistration Pending · Pittsburg, TXRegistration pendingBuilt 1980 · S/N D10350N518MMull Jason E · Chester, NYBuilt 1970 · S/N D-9111N51HMDw Peterson Inc · Warren, MNBuilt 1966 · S/N D-8288N521VRMyers Jonathan A · Dieterich, ILBuilt 1965 · S/N D-7922N523QNixon John H · Ormond Beach, FLBuilt 1967 · S/N D-8582N523TCSmith Ranch Bonanza LLC · San Francisco, CABuilt 1964 · S/N D-7613N523ZARegistration Pending · Perryton, TXRegistration pendingBuilt 1974 · S/N D-9596N525BHWalker Craig · Pleasant View, TNBuilt 1982 · S/N D-10400N529DDSchwertfeger Dean · Woodruff, WIBuilt 1970 · S/N D-9151N52AUUllman Aaron L · Barksdale Afb, LABuilt 1967 · S/N D-8484N530CContinental Title Trust LLC Trustee · Wichita, KSBuilt 1976 · S/N D-9927N531BFLouis F Olberding Dds Pc · Lincoln, NEBuilt 1973 · S/N D-9541N533SZilz Tammy S · Saint Peters, MOBuilt 1965 · S/N D-8028
Back to AD 75-01-07