AD 2002-03-52

Registered aircraft · 1,115

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-03-52')
    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-03-52')
  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.

N249AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9878N250AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 9741N251HIsland 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 8595N255RMCgcpr LLC · Canovanas, PRBuilt 2009 · S/N 4855N257AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7203N259AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7050N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869N261NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8916N262TWRegistered aircraftBuilt 2012 · S/N 7333N2658Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8959N267ADepartment 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 8267N267RCBank Of Utah Trustee · Salt Lake City, UTS/N 7393N268JAirbus 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 9854N279AMAir Methods LLC · Greenwood Village, COS/N 4685N279CHCoastal Helicopters Inc · Juneau, AKBuilt 1979 · S/N 1149N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792N288WSWorld 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 8850N296WAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9717N297PDCity Of Philadelphia · Philadelphia, PABuilt 2014 · S/N 7810N297SHJc Aircraft Leasing LLC · Wasilla, AKS/N 7429N29GFAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2023 · S/N 9523N29HDHelinet Aviation Services LLC · Van Nuys, CABuilt 1995 · S/N 2874N29LBCity Of Long Beach · Long Beach, CABuilt 2003 · S/N 3760N29LWTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4485N2SDPinellas County Sheriff'S Office · Clearwater, FLBuilt 2006 · S/N 4099N2SWEcho Matrix LLC · Bentonville, ARBuilt 2019 · S/N 8746N301CHCoastal Helicopters Inc · Juneau, AKBuilt 2014 · S/N 7942N302CHCoastal Helicopters Inc · Juneau, AKBuilt 2016 · S/N 8198N302SCUsaircraft Inc · Newark, DEBuilt 2002 · S/N 3564N302TPCity Of Tulsa · Tulsa, OKBuilt 2019 · S/N 8617N304MPMiami-Dade Sheriff'S Office · Doral, FLBuilt 2011 · S/N 7153N305MPMiami-Dade Sheriff'S Office · Doral, FLBuilt 2009 · S/N 4759
Back to AD 2002-03-52