AD 75-06-01

Registered aircraft · 2,832

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-06-01')
    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-06-01')
  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.

N353KMPapareenie LLC · Pismo Beach, CABuilt 2003 · S/N 534N354BABlue Air Training Corp · Las Vegas, NVBuilt 1991 · S/N 554N354FGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1967 · S/N 2010N355HGHerricks Bobby · Midland, TXBuilt 2001 · S/N FL-320N355KAGlobal Transport Ten LLC · Fort Myers, FLBuilt 2025 · S/N 100-0355N355MBMio LLC · Satellite Beach, FLBuilt 2018 · S/N 100-0247N355PCEagles Wings Avaition LLC · Monroeville, ALBuilt 1984 · S/N LJ-1067N356BMfsr LLC · Rigby, IDBuilt 2015 · S/N 100-0152N356FRegistered aircraftBuilt 2001 · S/N 207N357LPKa350 LLC · Bluefield, WVBuilt 1991 · S/N FL-68N359ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 359N359CVWen LLC · Spokane, WABuilt 2000 · S/N 382N35BAC90 Air Inc · Lemoore, CABuilt 1980 · S/N LJ-909N3606TSunshine Aero Industries Inc · Crestview, FLBuilt 1970 · S/N B30N360EASai Flight Services Inc · Greer, SCS/N BB-1231N360RWAcc Integrated Services Inc · Milwaukee, WIBuilt 1983 · S/N SH3613N360VAAustin 1hp LLC · Austin, TXBuilt 2002 · S/N FL-356N361CESamish Specialty Equipment LLC · Bow, WABuilt 2025 · S/N K090N361TDSequoia Beverage Co Lp DBA · Visalia, CABuilt 1986 · S/N BL-128N3620MSanford Medical Center · Sioux Falls, SDBuilt 1991 · S/N BB-1396N362JBCentral Virginia Aviation Inc · Petersburg, VAS/N 4697050N363DFreeman Holdings Of West Texas LLC · Medford, ORBuilt 1995 · S/N BB-1503N363JHBering Air Inc · Nome, AKBuilt 2002 · S/N BB-1799N364WBWayne Ross Biddell · Oklahoma City, OKBuilt 2022 · S/N 4698208N3655BWoodley Aerial Leasing LLC · Walnut, ILBuilt 1980 · S/N 301-0291N3657TCentral Planes Aviation Inc · Sauk Centre, MNBuilt 1980 · S/N 301-0316N365ARTwin Otter International Ltd · Las Vegas, NVBuilt 1973 · S/N 365N365BTJaars Inc · Waxhaw, NCBuilt 1971 · S/N 729N365DHKodiak Aircraft Co Inc · Sandpoint, IDBuilt 2026 · S/N 100-0365N366KAPelican Equipment LLC · New York, NYBuilt 2026 · S/N 100-0366N367ACAcc Integrated Services Inc · Milwaukee, WIBuilt 1983 · S/N SH3626N367KAKodiak Aircraft Co Inc · Sandpoint, IDBuilt 2026 · S/N 100-0367N368ACAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3651N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291N36GHMustang High Flight LLC · Boise, IDBuilt 1966 · S/N 1636N36TGRv Holding LLC · Winchester, MABuilt 1996 · S/N LJ-971N3700MBoeing Co · Berkeley, MOBuilt 1980 · S/N LW-340N370UBoard Of Regents Of The University Of Oklahoma · Norman, OKS/N LJ-1428N373HDHinkle Air Spray Inc · Cavalier, NDBuilt 2001 · S/N 502B-0636N373KATvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2026 · S/N 100-0373N375BCYellowstone Leasing LLC · Pray, MTBuilt 1991 · S/N FL-56N375RDDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 4697003N377LAFickes Aerial & Ag Services LLC · Norfolk, NEBuilt 1996 · S/N 502B-0377N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378N378HHGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N 378N379PMSingle Otter Leasing LLC · Ketchikan, AKBuilt 1961 · S/N 379N37HDynamic Avlease Inc · Bridgewater, VABuilt 1967 · S/N LM-48N37TDTwin Disc Inc · Racine, WIBuilt 1990 · S/N FL-25N381MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3703N382MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3704
Back to AD 75-06-01