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.

N308CSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N LJ-1478N308MDGem City Properties LLC · Laramie, WYBuilt 1990 · S/N LJ1246N308RMN308rm LLC · Boca Raton, FLBuilt 1974 · S/N LJ628N3096PV V I P LLC · Cottonwood, AZBuilt 2004 · S/N 4697178N3098365 Whiskey Romeo LLC · Timnath, COBuilt 2004 · S/N 4697189N309CQFelicidad Holdings LLC · Winter Springs, FLBuilt 2018 · S/N 100-0260N309LTLebeouf Bros Towing LLC · Bourg, LABuilt 2021 · S/N 100-0294N30BEEllingson Craig Edward Trustee · Clive, IABuilt 2021 · S/N 4698194N30CCTalon Air Services Inc · Soldotna, AKBuilt 1964 · S/N 1566TB4N30EAEagle Air Transport Inc · Ottawa, ILBuilt 1968 · S/N 191N30HVCustom Fabricating & Repair Inc · Marshfield, WIBuilt 1989 · S/N FA-173N3104WBirch Tree Aviation LLC · Unadilla, GABuilt 1990 · S/N T34-151N3104YCrop Dusters LLC · Maurice, IABuilt 1991 · S/N T34-156N3105EJohnson Airspray Inc · Argyle, MNBuilt 1992 · S/N T34-177N31062Central Virginia Aviation Inc · Petersburg, VABuilt 2005 · S/N 4697208N310JKConnors Air Holdings LLC · Tierra Verde, FLBuilt 2001 · S/N 4697069N3110TWellborn Aviation LLC · Texarkana, TXBuilt 2005 · S/N 4697221N3117SBlue Horseshoe LLC · Brentwood, TNBuilt 2005 · S/N 4697230N3117VP&C Aircraft LLC · Chapel Hill, NCBuilt 2005 · S/N 4697234N311GCRte Enterprises Inc · Canoga Park, CABuilt 1980 · S/N LA-55N311KDTriple C Charters LLC · Carmel, INBuilt 2022 · S/N 100-0311N311MXInternational Air Services Inc Trustee · Carson City, NVBuilt 2022 · S/N 4698213N312BCWorldwide Option LLC · Lewes, DEBuilt 1994 · S/N 101N312RLNyati Worldwide LLC · Sinton, TXBuilt 1997 · S/N FL-164N312SBSwitchback Aviation LLC · Roscoe, MTBuilt 2022 · S/N 100-0309N313DWDurair Inc · Key West, FLBuilt 1996 · S/N LJ-1434N313HAValiair Lc Trustee · Casper, WYBuilt 1993 · S/N FL-96N314AWUS Government · Washington, DCBuilt 2004 · S/N FL-387N315AWUS Government · Washington, DCBuilt 1992 · S/N FL-91N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015N3160XWoodley Aerial Leasing LLC · Walnut, ILBuilt 1983 · S/N 301-0479N316LVBayne Air LLC · Whitefish, MTBuilt 2025 · S/N K097N316PDLonghorn Air LLC · Wilmington, DEBuilt 2003 · S/N 14038N316PMAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 241N316PWAl Force 1 LLC · North Salt Lake, UTBuilt 1991 · S/N FM2N316WRHoxie Sprayers Inc · Hoxie, KSBuilt 1995 · S/N 502A-0316N317XTN317xt LLC · Henderson, NVBuilt 2022 · S/N 100-0317N31941Gasper Air Spray Inc · Crookston, MNBuilt 1995 · S/N T45-008N319EEReveille Aviation LLC · Kurten, TXBuilt 2004 · S/N FL-401N319PDOrtiz Luis Emerito Nieves · Plantersville, TXBuilt 2004 · S/N 14040N319TBShuck Holdings LLC · Anderson, SCBuilt 2005 · S/N 319N319WWWin Win Aviation Inc · Wake Forest, NCBuilt 1992 · S/N SH3209N31JA100-042 LLC · Menlo Park, CABuilt 2010 · S/N 100-0042N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49N31WDWestern Dakota Holding Co · Timber Lake, SDBuilt 1980 · S/N 425-0012N31XXTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N FL-31N320N320 LLC · North Las Vegas, NVBuilt 2023 · S/N 100-0328N320KTRustair Inc · Anchorage, AKBuilt 1956 · S/N 73N321N321 LLC · North Las Vegas, NVBuilt 2021 · S/N 100-0299N3211RJohnson Airspray Inc · Argyle, MNBuilt 1978 · S/N 5100R
Back to AD 75-06-01