OpenAirDocs.org
AD 2015-17-01 R1

Registered aircraft · 953

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:2015-17-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-17-01-R1')
  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.

N184SDCounty Of Orange - Air Support · Costa Mesa, CAS/N 4009N185SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2016 · S/N 8125N186AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3872N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N188EULashinski Robert D Trustee · Sebastopol, CABuilt 2011 · S/N 7188N191NRMaryland Natural Resources Police · Stevensville, MDBuilt 2023 · S/N 9382N191TXTexas Dept Of Public Safety · Austin, TXBuilt 2010 · S/N 4841N192ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7184N193BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2894N194AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3338N1964LDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9179N1977GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9192N197BHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1992 · S/N 2666N198AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3371N1997GAirbus Helicopters Inc · Grand Prairie, TXS/N 9970N1CRComanche Maverick Air LLC · Houston, TXBuilt 2016 · S/N 8165N1MZA Star 350 LLC · Henderson, NVS/N 7300N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N202SCNs Air Leasing LLC · Wilmington, DEBuilt 1982 · S/N 5204N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N203ZDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8811N204CHCoastal Helicopters · Juneau, AKBuilt 1981 · S/N 2054N20AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9714N2108JDeparment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9200N211LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9910N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213N212CMAerospace Trust Management LLC Trustee · Wilmington, DES/N 2232N212KPitch Link LLC · New York, NYBuilt 2010 · S/N 7030N212LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9919N213PFLapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8340N214EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3163N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537N214STBank Of Utah Trustee · Salt Lake City, UTS/N 2141N215EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3172N215GHBase Camp Aviation LLC · Mccall, IDBuilt 1998 · S/N 3147N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184N2171CNs Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3427N217EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3197N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221N217HPNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3628N218SHSuperior Helicopter Services LLC · Indianapolis, INBuilt 2018 · S/N 8458N21FYH125 Aviation LLC · Wailea, HIBuilt 2024 · S/N 9465N220CFMercy Air Helicopter Inc · Fort Lauderdale, FLBuilt 2001 · S/N 3411N221LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7900N221MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8680N221PAFa Aviation Logistics Inc · Houston, TXBuilt 2014 · S/N 7851N223LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7956N223MTMed-Trans Corp · Denton, TXBuilt 2019 · S/N 8659N224LALapd Air Support Division · Los Angeles, CABuilt 2022 · S/N 9185
Back to AD 2015-17-01 R1