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.

N2374FTexas Department Of Public Safety · Austin, TXBuilt 2020 · S/N 8817N237BSSky High Leasing LLC · Montrose, COBuilt 2013 · S/N 7542N239AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2023 · S/N 9386N23HSVertical Corp · Kalispell, MTBuilt 2013 · S/N 7550N242ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7176N243GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4617N244CPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 7036N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408N247HHIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 6529N249AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9878N250AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 9741N250KMHeliec120 LLC · Wilmington, DEBuilt 2000 · S/N 1154N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975N252CHCoastal Helicopters Inc · Juneau, AKBuilt 1996 · S/N 2954N253AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9973N253CHCoastal Helicopters Inc · Juneau, AKBuilt 1997 · S/N 2974N253LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7158N255LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7140N255PJArk Aviation LLC · Central City, KYBuilt 2018 · S/N 8595N255SDSacramento County Sheriffs Office · Mather, CABuilt 2000 · S/N 1102N257AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7203N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N261NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8916N262TWRegistered aircraftBuilt 2012 · S/N 7333N263CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1324N2658Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8959N265CB210 Partners LLC · Lutz, FLBuilt 2006 · S/N 1458N266SDSacramento County Sheriffs Department · Mather, CABuilt 2000 · S/N 1133N267ADepartment Of Homeland Security · Washington, DCS/N 7222N267AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7215N267LALapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8267N268JAirbus Helicopters Inc · Grand Prairie, TXS/N 9916N26HXNs Air Leasing LLC · Wilmington, DEBuilt 2007 · S/N 4385N270PWTexas Parks And Wildlife Department · Austin, TXBuilt 2023 · S/N 9374N274CHWalker Kenneth E · Ford City, PABuilt 1989 · S/N 2306N275BPCity Of Burbank · Burbank, CAS/N 1930N2770KAirbus Helicopters Inc · Grand Prairie, TXNon-citizen corporation, flight hours not reportedS/N 9854N277SDSacramento County Sheriffs Office · Mather, CABuilt 2000 · S/N 1134N279AMAir Methods LLC · Greenwood Village, COS/N 4685N279CHCoastal Helicopters Inc · Juneau, AKBuilt 1979 · S/N 1149N279EHAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2002 · S/N 1279N27GTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1376N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N288JKCounty Of Sacramento · Mather, CAS/N 1400N288WSWorld Trade Enterprises LLC · Lucas, TXBuilt 1988 · S/N 2087N28LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3757N2907ADepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9216N295JAb Air Ltd · Canton, OHBuilt 2018 · S/N 8510N296PDCity Of Philadelphia · Philadelphia, PABuilt 2013 · S/N 7705N296SDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8850
Back to AD 2002-15-08