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.

N113VSaravis Darren S · Long Beach, CABuilt 1965 · S/N D-7958N113XClement James G · Cresson, TXBuilt 1966 · S/N D-8112N114JDVintage Motors Inc · Beattyville, KYBuilt 1973 · S/N D-9420N114TPGrj LLC · Lexington, SCBuilt 1975 · S/N D-9801N114WRRib Runner LLC · Sioux Falls, SDS/N D-10052N1156TAero 1 LLC · Kalispell, MTBuilt 1975 · S/N D-9761N115CA8k Entertainment Inc · Wells, MEBuilt 1981 · S/N D-10371N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777N1183ABronson Nw Inc · Redmond, ORBuilt 1969 · S/N D-9006N118VSmith Gregg W · Lake Jackson, TXBuilt 1966 · S/N D-8096N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298N11HTJet X Leasing Inc · Johnson, KSBuilt 1967 · S/N D-8534N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234N11JQLosey Charles N Jr · Oneida, TNBuilt 1965 · S/N D-7786N11KSFaulkner Dale R · Burnet, TXBuilt 1969 · S/N D-9017N11RTBraly And Braly Pc · Ada, OKBuilt 1967 · S/N D-8420N11VBRobertson Matthew · Nashville, TNBuilt 1969 · S/N D-9031N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248N121BEKrdm LLC · Fallon, NVS/N D-7920N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794N1234VFrailey Randy J · Chouteau, OKBuilt 1979 · S/N D-10221N123CTPastor Jordan D · Riverside, CABuilt 1967 · S/N D-8590N123ECJohnson Howard A · Lake Forest Park, WABuilt 1972 · S/N D-9412N123RGChurch Brett L · Whitefish, MTBuilt 1968 · S/N D-8816N1240AAlfa Monkey LLC · Wolfforth, TXBuilt 1969 · S/N D-9028N124DRendezvous Island Air LLC · Fort Collins, COS/N 10002N125PCRegistered aircraftBuilt 1978 · S/N D-10148N125TR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1973 · S/N D-9560N126HBockman Ltd · Milford, IABuilt 1967 · S/N D-8544N126WGN126wg LLC · Oak Brook, ILBuilt 1972 · S/N D-9315N1273SSullivan Stephen G · Mize, MSBuilt 1969 · S/N D-8937N1296AN1296a LLC · Asheville, NCBuilt 1969 · S/N D-9030N129XSwarts Robert · Cincinnati, OHBuilt 1967 · S/N D-8586N12GBOliver Jonathan F Sr · Waxahachie, TXBuilt 1975 · S/N D-9789N12KCHeath David A Trustee · Cottonwood, AZBuilt 1965 · S/N D-7867N12PMFlying Bald Eagles Inc · New Lenox, ILBuilt 1964 · S/N D-7514N12RCSkipper Thomas · Coburg, ORS/N D-9308N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393N135BEJeff Proctor Holding Lc · Park City, UTBuilt 1973 · S/N D-9524N135DWWagner Dennis L · Zionsville, INBuilt 1982 · S/N D-10399N135JAD & K Aviation Inc · Milford, IABuilt 1967 · S/N D-8478N135PGKom Aviation LLC · Southern Pines, NCS/N D10394
Back to AD 75-01-07