OpenAirDocs.org
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.

N15DTBernal Cresencio · Pittsburg, CABuilt 1968 · S/N D-8725N15VMGagne Jay A · Dyersburg, TNBuilt 1976 · S/N D-9936N1601WSix Ten Ventures LLC · Grand Prairie, TXBuilt 1972 · S/N D-9360N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615N161WCater Christopher B · Lowell, MIBuilt 1965 · S/N D-7914N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365N1628WT W Air LLC · Worthington, KYS/N D-9366N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472N1684WHaller Philip L · Peoria, AZS/N D-9386N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388N168MNelson Lars C · Anchorage, AKBuilt 1968 · S/N D-8762N168ULeading Edge LLC · Scottsdale, AZBuilt 1969 · S/N D-8986N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392N16GMTate Joe D · Eufaula, OKBuilt 1967 · S/N D-8616N1701WJagz Aviation LLC · Akron, OHS/N D-9394N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303N1708WCassaday Jonathan A · Visalia, CABuilt 1964 · S/N D-7340N170MWilliams John R Jr · Marfa, TXFirst renewal noticeBuilt 1966 · S/N D-8317N1717WAdkins Zachary R · Scottsboro, ALBuilt 1972 · S/N D-9368N171HTodd Doug · De Witt, IABuilt 1965 · S/N D-7959N171JTropicaire LLC · Hamilton, MTBuilt 1965 · S/N D-7957N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092N1725WEdwards John G · Stoneville, NCS/N D-9400N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404N17505Trout Christopher S · Albuquerque, NMBuilt 1977 · S/N D-9966N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406N17516Gillis Alan · Richmond, TXBuilt 1977 · S/N D-9978N17561Demott Andrew Dolphus III · Hernando, FLBuilt 1977 · S/N D-9983N17568Chance Research Corp · Mineral Wells, TXBuilt 1977 · S/N D-9984N1756WIverson Bradley · Grinnell, IABuilt 1972 · S/N D-9409N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259N17629Haven Av LLC · New Braunfels, TXBuilt 1977 · S/N D-9991N1762WWillis Frederick A · Scottsdale, AZS/N D-9410N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003
Back to AD 75-01-07