AD 2002-15-08

Registered aircraft · 1,064

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

N20AHAirbus 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 7851N222JTJ & T Aviation LLC · Dover, DEBuilt 2005 · S/N 1401N223LALapd 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 9185N224MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9221N225LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8628N226LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8636N226MTLendingclub Bank Na · Boston, MABuilt 2019 · S/N 8671N226PDAnaheim Police Dept · Fullerton, CABuilt 2004 · S/N 3879N227MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 8892N227NDHillsborough County Sheriff · Tampa, FLBuilt 2022 · S/N 9296N227TXTexas Department Of Public Safety · Austin, TXBuilt 2025 · S/N 9786N228LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3316N229AHMiller Jason · Scottsdale, AZBuilt 2023 · S/N 9353N229LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3317N229MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9203N230AHAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9674N230LALapd Air Support Division · Los Angeles, CABuilt 2020 · S/N 8794N232LACity Of Los Angeles · Los Angeles, CABuilt 2023 · S/N 9298N232SHJc Aircraft Leasing LLC · Wasilla, AKS/N 7850N233LACity Of Los Angeles · Los Angeles, CABuilt 2024 · S/N 9428N233PAComanche Maverick Air LLC · Houston, TXBuilt 2018 · S/N 8507N234BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2012 · S/N 7398N234BUHeli-USA Corp · Houston, TXS/N 1210N234VMIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6548
Back to AD 2002-15-08