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.

N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393N200XLCondor Aviation LLC · Bethlehem, PABuilt 1981 · S/N 31T-8166010N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201N202FHTr Flying Service LLC · Milan, MNBuilt 1992 · S/N 402A-0867N202UXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-202N203KQBridger Aviation Services LLC · Belgrade, MTBuilt 2017 · S/N 100-0203N203RDAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 1976 · S/N LW-203N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164N204PEWorsham Farms Flying Service Inc · Camilla, GABuilt 2003 · S/N T660-109N204WState Of Wisconsin · Madison, WIBuilt 1998 · S/N FL-204N20551Lane Christopher A · Lakeland, GAS/N T15-035N205RMLissie Flying Service Inc · Lissie, TXBuilt 1998 · S/N 502A-0491N2067BAgricair Leasing LLC · Bancroft, WIBuilt 1998 · S/N T34-246N206KQDc3 Properties LLC · Sacramento, CABuilt 2017 · S/N 100-0206N2076BArrowhead Aviation LLC · Louisville, ALBuilt 1998 · S/N T34-249N207HBState Of Washington · Olympia, WABuilt 1995 · S/N BB-1516N207KQArizona Game And Fish Department · Phoenix, AZBuilt 2017 · S/N 100-0207N207LALocker Fred · Muleshoe, TXBuilt 2005 · S/N 802A-0207N207PDale Aviation · Rapid City, SDBuilt 1995 · S/N LJ-1406N207RS5m Consulting LLC · Uvalde, TXBuilt 1984 · S/N 4250195N207WWDarling'S Agency LLC · Brewer, MEBuilt 2023 · S/N 4698287N208BMerlin Labs Inc · Boston, MABuilt 2003 · S/N 208B1023N208BABoeing Co · Renton, WABuilt 2008 · S/N 208B2027N208BLCaravan International Leasing Inc · Carson City, NVBuilt 1989 · S/N 208B0182N208BVRegistered aircraftBuilt 2001 · S/N 208B0913N208CEArctic One LLC · Fairbanks, AKBuilt 1995 · S/N 208B0466N208CGAspen Homes And Development LLC · Coeur D Alene, IDBuilt 1995 · S/N 132N208EBUS Government · Washington, DCBuilt 2004 · S/N 208B1047N208GSouth Aero Inc · Albuquerque, NMBuilt 2002 · S/N 208B0940N208HFStart Skydiving LLC · Middletown, OHBuilt 1987 · S/N 20800116N208HWRedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0118N208JHWatermakers Air Inc · Fort Lauderdale, FLBuilt 2005 · S/N 208B1144N208JKBaker Aviation Consulting LLC · Summerland Key, FLBuilt 1998 · S/N 20800281N208KREcho Matrix LLC · Bentonville, ARFirst renewal noticeBuilt 1999 · S/N 208-00304N208KTAircraft Structures International Corp · Enid, OKBuilt 1991 · S/N 208B0258N208LBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 20800378N208MQCountry Flyin Inc · Homestead, FLBuilt 1999 · S/N 208B0771N208NRNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2005 · S/N 208B1126N208PGRedding Aero Enterprises Inc · Redding, CABuilt 1999 · S/N 208B-0799N208PKSchuman Carriage Co Ltd · Honolulu, HIBuilt 2005 · S/N 208B1143N208SMGrant Aviation Inc · Anchorage, AKBuilt 1999 · S/N 208B0749N208SRBardoo Urias L · Massapequa, NYBuilt 1974 · S/N B208N208TFMartinaire Aviation LLC · Addison, TXBuilt 1997 · S/N 208B0592N208TRSouth Aero Inc · Albuquerque, NMBuilt 2005 · S/N 208B1151N208TWCaravan Air LLC · Oxford, CTBuilt 1998 · S/N 208B0671N208VVT&T Highcountry Flying Service LLC · Saint Anthony, IDS/N 502B-0560N208WWWestwind Aero Group LLC · Phoenix, AZBuilt 1998 · S/N 208B0721
Back to AD 75-06-01