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.

N4127SKrall Jeff P · Mitchell, SDBuilt 1975 · S/N D-9738N412YMurrieta Humberto · San Antonio, TXS/N D-9292N4135SRazzyfish Inc · Colton, CABuilt 1975 · S/N D-9787N413GKKgc Holdings Ltd · Newark, TXBuilt 1973 · S/N D-9450N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307N4143SFrederickson Mark T · Cameron Park, CABuilt 1975 · S/N D-9743N4149SDelgado Dimitri Antonio · Tampa, FLBuilt 1975 · S/N D-9745N4151SMidland Avionics LLC · Louisville, KYS/N D-9746N4154SWilanco Inc · Berkeley, CABuilt 1975 · S/N D-9751N4163ASalida Aviation Partnership Group · Moffat, COBuilt 1970 · S/N D-9121N4164SFabien Turpaud Corp · Lewes, DEBuilt 1975 · S/N D-9753N416GFHahn Steven P · Hutchinson, MNBuilt 1964 · S/N D-7497N4175SBauman Loren A · Lewisville, NCS/N D-9756N4177SMiles Insurance Inc · Inverness, ILBuilt 1975 · S/N D-9757N4180SPalomino Princess Express LLC · Helena, MTS/N D-9755N4187SJ&S Aviation Services LLC · Hastings, NES/N D-9765N4192ARocky Mountain Aviation Inc · Wilmington, DEBuilt 1970 · S/N D-9128N4192SStecklein Aviation LLC · Colleyville, TXBuilt 1975 · S/N D-9766N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762N41CMClark Patrick L · Kenai, AKBuilt 1977 · S/N D-9967N41SBBrillaud Stephen A DBA · Germantown, TNBuilt 1964 · S/N D-7608N4212SColburn Reno Bryan · Turner, MTBuilt 1976 · S/N D-9954N4217SAnla Aviation LLC · Bentonville, ARBuilt 1977 · S/N D-9968N422GRHolden Virgil Gary Trustee · Upland, CABuilt 1966 · S/N D-8243N423MDSublett Charles M · Tulsa, OKBuilt 1964 · S/N D-7454N423WTCoons John K · Winston Salem, NCBuilt 1964 · S/N D-7426N4245AMac Flight LLC · Conway, ARBuilt 1970 · S/N D-9126N425MGGrinnan Michael · Stafford, VAS/N D-7813N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959N4275SEvergreen Aviation LLC · Franktown, COBuilt 1977 · S/N D-9961N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306N428TLJoe Rushing Plumbing Co Inc · Lubbock, TXBuilt 1967 · S/N D-8632N42ABGallaway Michael T · Dallas, TXBuilt 1965 · S/N D-7935N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140N42WKMariash Cary Norman · Indianapolis, INBuilt 1964 · S/N D-7390N4301WNash Matthew · Edmonds, WABuilt 1974 · S/N D-9578N4302WDagenhart Ronald Jason · Westerville, OHBuilt 1974 · S/N D-9582N4310SVelk Vincent F · Havre, MTBuilt 1975 · S/N D-9773N4312WBreitbarth Brian · Canby, ORBuilt 1974 · S/N D-9585N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587N4321EHarper Henry Jr · Mesquite, NVS/N D-8868N4321SBeech Peak Aviation LLC · Boulder, COBuilt 1964 · S/N D-7512N4322WSnell Steve · Scotts Valley, CABuilt 1974 · S/N D-9589N433DReyenga Steven G · Shreveport, LABuilt 1966 · S/N D-8094N433SBesedin Thomas E · Islandia, NYBuilt 1965 · S/N D-8006N4340WHanger Aviation Inc · Charleston, SCBuilt 1974 · S/N D-9577N4342AR&B Air LLC · Clayton, MOBuilt 1970 · S/N D-9133
Back to AD 75-01-07