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.

N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640N1455TKenmore Air Harbor LLC · Kenmore, WAS/N 1647TB26N145SLCash Depot Ltd · Green Bay, WIBuilt 2004 · S/N 1093N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046N146SLDodson International Parts Inc · Rantoul, KSS/N 1091N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813N148SAZuni LLC · Kirkland, WAS/N 409N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148N149CCCianbro Corp · Baltimore, MDS/N FA-145N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149N14GVScott T LLC · Portland, ORS/N 4697092N14RPAs350 LLC · Missoula, MTBuilt 2024 · S/N 100-0338N1500EVaughans Aircraft Leasing LLC · Claremore, OKS/N 402-0820N1502BAeroag LLC · Portland, INBuilt 1998 · S/N 502B-0476N1502UCentral Ag Air LLC · Marion, KSBuilt 1991 · S/N 502-0139N15054Air-Ag Inc · Tarboro, NCBuilt 1991 · S/N 402A-0823N15074Wells Flying Services LLC · Holdrege, NEBuilt 1991 · S/N 402A-0825N1507KDakota Air Spray LLC · Huron, SDBuilt 1991 · S/N 502-0142N150ACJohnson Airspray Inc · Argyle, MNBuilt 1991 · S/N T34-150N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531N150KReilly John P · Friendsville, PABuilt 2011 · S/N 100-0051N15102Moes Crop Dusting Service Inc · Marysville, CABuilt 1991 · S/N 502-0146N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156N151BCBrc Az Aviation LLC · Scottsdale, AZBuilt 2020 · S/N 100-0289N151CAAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3653N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153N153KDMec International Trading LLC · Mission, TXBuilt 1968 · S/N 153N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153N153SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2002 · S/N 1054N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171N1544RRas Aviation LLC · Elyria, OHBuilt 1992 · S/N 401-0864N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085N154CLAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0212
Back to AD 75-06-01