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.

N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158N385MQAcc Integrated Services Inc · Milwaukee, WIS/N SH3707N386AFBank Of Utah Trustee · Portsmouth, NHBuilt 2024 · S/N 2386N386ARRustic Corp · Fort Worth, TXBuilt 1999 · S/N 208B0787N386GABarnes Inc · Lewiston, IDBuilt 1978 · S/N LJ-775N387SCHeritage Aviation Management Ltd · Conroe, TXBuilt 1999 · S/N FM-10N388EERegistered aircraftBuilt 2019 · S/N 100-0276N388TWTl Lobo Group LLC · Rockwall, TXBuilt 2000 · S/N 4697018N38JVKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1992 · S/N BB-1439N38VDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-105N38VSNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1988 · S/N BB-1313N390PSMcm Holdings Inc · Lincoln, NES/N LW-279N391ACAmerican Champion Aircraft Corp · Rochester, WIBuilt 1979 · S/N 400-98N391HCFly-Area LLC · Charleston, SCBuilt 1988 · S/N FA165N394LAAerial Solutions Of Tennessee LLC · Milan, TNBuilt 1994 · S/N 502B-0242N394SFCity Wings Inc · St Thomas, VIBuilt 2005 · S/N 20800394N395AAAdvanced Air LLC · Hawthorne, CABuilt 1991 · S/N FL39N395ABFr Air LLC · Palm Harbor, FLBuilt 1999 · S/N LJ-1575N395MBAdvanced Air LLC · Hawthorne, CABuilt 2002 · S/N FL-347N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021N396MFRango Aviation LLC · Mesa, AZBuilt 1992 · S/N BB-1421N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012N398RKAir Worthy Inc · Lyon, MSBuilt 1998 · S/N 602-0484N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91N399TWArx Air LLC · Windermere, FLBuilt 1983 · S/N LA-203N399WSGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1547N39GKBusiness & Pleasure Air Charter LLC · Bakersfield, CABuilt 2000 · S/N 1039N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2N3BAConstruction Enterprises Inc · Franklin, TNBuilt 1997 · S/N FL-181N3GCTexas Air & Space Museum · Amarillo, TXBuilt 1973 · S/N LJ-576N3MHN3mh LLC · Kalispell, MTBuilt 1985 · S/N BB-1228N4005JPettis Aviation LLC · Atlantic, IABuilt 2004 · S/N T660-111N4006YHendrickson Flying Service Inc · Rochelle, ILBuilt 1978 · S/N 6008N400ACFly Pilatus LLC · Naples, FLBuilt 2002 · S/N 472N400GWGpw LLC · Laurel Springs, NCBuilt 1997 · S/N BB-1583N400SCN400sc LLC · Walterboro, SCBuilt 1982 · S/N BB-1040N401JTN401jt LLC · Denver, COS/N 42-5501023N40269Freefall Express Inc · Gardiner, NYBuilt 1968 · S/N 152N402CSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 402A-0816N402DEDeby Ag Leasing Lp · Wakarusa, INBuilt 1991 · S/N 402-0807N402GKGress Air LLC · Dunbar, NEBuilt 2004 · S/N 402A-1151N402JDefenbaugh Matthew J · Biggsville, ILBuilt 2000 · S/N 402A-1117N402LTBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 402B-1163N402REKingrey William S III · Richmond, TXBuilt 1997 · S/N 402A-1027N402SKOli Grow LLC · Baskin, LAS/N 402-0895N402SROli Grow LLC · Baskin, LABuilt 1994 · S/N 402-0939N402TSunflower Aero Inc · Atwood, KSBuilt 1998 · S/N 402A-1060
Back to AD 75-06-01