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.

N354DAir Repair Inc · Deadwood, SDBuilt 1964 · S/N D-7659N354DJN354dj LLC · Gulfport, MSBuilt 1980 · S/N D-10326N354DPShaffer John · Virginia Beach, VABuilt 1966 · S/N D-8309N354DRRadwanski D · Westmont, ILBuilt 1978 · S/N D-10102N354DZDachnowicz Peter A · Avon, CTBuilt 1972 · S/N D-9336N354JMountain V-Tail LLC · Denver, COS/N D-7857N354KPTri County Flying Club Llp · Estelline, SDBuilt 1964 · S/N D-7612N354LCDelos Anesthesia Services Pc · Barstow, CABuilt 1966 · S/N D-8161N354MMission Aviation LLC · Billings, MTBuilt 1964 · S/N D-7516N354PFBillen Jerome · Hodges, SCBuilt 1972 · S/N D-9313N357DRegis Frederic · Denver, COBuilt 1967 · S/N D-8562N357SHill V35 LLC · Nashville, TNBuilt 1967 · S/N D-8679N358ALlewellyn Development LLC · Charlotte, NCBuilt 1978 · S/N D-10163N358SBolla Bruce B · San Francisco, CABuilt 1967 · S/N D-8671N3594AFlying Fur Animal Rescue · Kintnersville, PABuilt 1969 · S/N D-9072N359ERJames Chad · Needville, TXBuilt 1978 · S/N D-10182N35BCjs Aviation LLC · Methuen, MABuilt 1974 · S/N D-9588N35BKNiemi Brian R · Monterey, CABuilt 1964 · S/N D-7685N35BMBecker Lawrence D Md · Anacortes, WABuilt 1970 · S/N D-9191N35BNAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N D-9907N35BTMarconi Properties LLC · Westbrook, CTBuilt 1979 · S/N D-10255N35CGComesa Service Group · Middletown, DEFirst renewal noticeBuilt 1972 · S/N D-9373N35EKHaupt Erik · Great Barrington, MABuilt 1979 · S/N D-10238N35ESMurphy Joel · Flowermound, TXBuilt 1965 · S/N D-7918N35KAHacker Timothy J · Pangburn, ARBuilt 1979 · S/N D-10231N35KJBunn John Timothy · Winter Garden, FLBuilt 1972 · S/N D-9326N35KWCoy Walter Thomas · Titusville, FLBuilt 1975 · S/N D-9827N35LFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N D9820N35LVDelta Fox Aviation LLC · Fort Worth, TXBuilt 1969 · S/N D-8900N35MSimmons Dennis L · Wichita, KSBuilt 1970 · S/N D-9143N35MASidetrack Investments LLC · Flower Mound, TXBuilt 1969 · S/N D-8925N35MFFlying Barefoot Ranch LLC · Wilmington, DEBuilt 1980 · S/N D-10304N35MSHazeltine Hugh J · Saint Petersburg, FLBuilt 1964 · S/N D-7637N35MTToft Michael O · Brock, TXBuilt 1966 · S/N D-8338N35MVWeaver Kibwe · Kalamazoo, MIBuilt 1967 · S/N D-8617N35NBBert John Boyd III · Vero Beach, FLBuilt 1975 · S/N D-9802N35NYPerry Charles E · Aldie, VABuilt 1970 · S/N D-9193N35QTReady Aim Flyer LLC · New Castle, DES/N D-8839N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393N35REDakota Aero Inc · Steamboat Springs, COS/N D-8930N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985N35TJBeech D9462 LLC · Perry, OHBuilt 1973 · S/N D9462N35TPMccallister Mark A · Qulin, MOBuilt 1977 · S/N D-10018N35TTJ B & B LLC · Midwest City, OKBuilt 1965 · S/N D-7812N35UPBarker Terry · Purvis, MSBuilt 1965 · S/N D-7998N35VBEquipment Lessors Inc · Lake Hawatha, NJBuilt 1977 · S/N D-10000N35VSRcp3 Enterprises LLC · Chesterfield, MOBuilt 1966 · S/N D-8247N35XLWilliams James R · Scotts Valley, CABuilt 1964 · S/N D-7321
Back to AD 75-01-07