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.

N402TMShores Ag-Air Inc · Robstown, TXBuilt 2005 · S/N 402B-1164N402UWestern Ag Aviation Inc · Plains, KSBuilt 1999 · S/N 402A-1116N402VA + Aviation Services LLC · Goodland, KSBuilt 1998 · S/N 402A-1050N402WD402wd Holdings LLC · Corpus Christi, TXBuilt 1999 · S/N 402A-1090N40310Sugair LLC · Corpus Christi, TXBuilt 2004 · S/N T65HG-012N40358Tri-Rotor Spray & Chemical · Ulysses, KSBuilt 2005 · S/N T34-273N4036FSaffer Spray Service Inc · Fowler, COS/N 402A-1058N403EMMach Point Nine LLC · Phoenix, AZBuilt 1981 · S/N LJ1000N40428H And M Flying Service LLC · Osceola, ARBuilt 2005 · S/N T34-274N40475Ed-Air Inc · Oaktown, INBuilt 2005 · S/N T65HG-014N404DPValie Air LLC · Statesboro, GABuilt 1981 · S/N BB-819N404MAOlivia Aviation LLC · Minneapolis, MNBuilt 2017 · S/N 100-0212N4053HCosmos Holdings Group LLC · Newark, DEBuilt 2001 · S/N BB-1774N405PTDodson International Parts Inc · Rantoul, KSS/N BB-930N40699Plane LLC · Grove, OKBuilt 2005 · S/N T65HG-016N406CDGold Sky LLC · Albuquerque, NMBuilt 2001 · S/N 4697046N406CPCalcasieu Parish Police Jury · Lake Charles, LABuilt 1967 · S/N LM-9N406RLSkyline Construction Services Inc · Eatonton, GABuilt 1999 · S/N LJ-1574N406RSAero South Florida Inc · Deerfield Beach, FLBuilt 1979 · S/N 31T-7920048N406SMile High 1 LLC · Lakeway, TXBuilt 2022 · S/N 4698217N406SDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 0063N406SFNew Mexico State University · Las Cruces, NMBuilt 1977 · S/N LW-218N407GVPa1 208b-0616 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0616N4081PBenoit Aerial Spraying Inc · Bourbonnais, ILBuilt 2000 · S/N T660-103N408DCCity Of San Jose · San Jose, CABuilt 2025 · S/N 100-0364N409MNBohlke LLC · Kingshill, VIBuilt 2000 · S/N 208B0846N40GNNorthlend Logistics LLC · Belgrade, MTBuilt 2017 · S/N 100-0224N40GZAirtrex Aircraft Alpha Inc · Wichita, KSBuilt 2004 · S/N FL-400N40LAMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 802A-0182N40NERedding Aero Enterprises Inc · Redding, CABuilt 2000 · S/N 208B0874N40RDynamic Avlease Inc · Bridgewater, VABuilt 1975 · S/N BC-7N40RDAfh Interests LLC · Fort Worth, TXBuilt 2000 · S/N LJ-1615N40SBSan Bernadino County Sheriffs Office · San Bernardino, CABuilt 1976 · S/N BD-09N40TTHeiderscheidt Aerial LLC · Sleepy Eye, MNBuilt 1975 · S/N 31T-7520023N40XJBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N LJ-1640N410GVPa1 208b-0632 LLC · Fort Lauderdale, FLBuilt 1997 · S/N 208B0632N411CCSunshine Aviation LLC · Roseburg, ORS/N BB-1520N411GCWb Air2021 LLC · Cochran, GABuilt 1997 · S/N FL163N411GVPa1 208b-0672 LLC · Fort Lauderdale, FLBuilt 1998 · S/N 208B0672N411JPBluffside Aero LLC · Williamsburg, VABuilt 2022 · S/N 4698229N411RSm1019 LLC · Polson, MTBuilt 2006 · S/N 4697241N413AFBerry Genetics Inc · Portsmouth, NHBuilt 2024 · S/N 2413N414GJRegistered aircraftBuilt 1991 · S/N 20N415TMCrouch Aire LLC · Westcliffe, COS/N BB-1762N415TTT & T Capital Inc · Bangor, MEBuilt 1993 · S/N 208B0365N416DFUsda Forest Service · Mcclellan, CABuilt 1985 · S/N BL-124N4174VDalmore Estates LLC · Los Angeles, CABuilt 2000 · S/N 4697014N41783Fpg Agri Services LLC · Frost, TXBuilt 1987 · S/N T-34-092DCN417ARGreenway Air LLC · Orlando, FLS/N 611N417KCFeatherstone Two LLC · Tampa, FLBuilt 2001 · S/N 417
Back to AD 75-06-01