AD 2003-26-06

Registered aircraft · 1,564

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

N20EUWerking John William III · New Windsor, MDS/N 628N20FKJohnston Brian · Bethany Beach, DES/N 637N20FQJag Capital LLC · Cocoa, FLBuilt 1986 · S/N 638N20FRNorton Justin William · Albuquerque, NMS/N 639N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20FZSharp Randy L · Rocklin, CABuilt 1986 · S/N 644N20GFVerbil Christopher J Trustee · Los Altos, CABuilt 1987 · S/N 645N20GKHashmi Aijaz · Riverside, CAS/N 646N20GUBaldree Christian Blair · Roseville, CAS/N 655N20JZWest William D · Newton, NCBuilt 1986 · S/N 652N20KGAdspitalny LLC · Waynesville, MOBuilt 1986 · S/N 668N20KLBuell Kenneth B · Port Orange, FLBuilt 1986 · S/N 669N20KMMozur Matthew Allen · Danvers, MABuilt 1985 · S/N 558N20KNShaw William C · Carmel, NYS/N 682N20KPHulsey Ryan A · Cleveland, GAS/N 683N20LUCamas Wings LLC · Camas, WAS/N 685N20LVSilver Skyways LLC · Las Cruces, NMBuilt 1986 · S/N 686N20NBStauffer Michael S · Wichita Falls, TXS/N 557N20NCJohnson Professional Aviation LLC · League City, TXS/N 559N20NDSheff Donald · Redwood City, CAS/N 687N20RFAffinity Air LLC · Fort Worth, TXBuilt 2011 · S/N 605N20SNHealy Edward · Fort Atkinson, WIBuilt 1987 · S/N 746N20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2008N20TKVanguard Executive LLC · Elfers, FLBuilt 1987 · S/N 748N20TLN20tl LLC · Incline Village, NVBuilt 1987 · S/N 749N20VCDanny J Daigle LLC · Greenville, MES/N 782N20VTRegistered aircraftS/N 899N210CLPark Rapids Avionics Inc · Park Rapids, MNBuilt 2004 · S/N 303N211GRTribus Aviation LLC · Saint Louis, MOBuilt 2008 · S/N 494N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213N212BWBoerne Flight Options LLC · Wilmington, DEBuilt 2018 · S/N 1229N212MPMp 212 LLC · Charlottesville, VABuilt 2023 · S/N 1467N213REWhital Enterprises LLC · Dover, DEBuilt 2002 · S/N 230N214EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3163N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537N214GTAcba Inc Trustee · Wilmington, DEBuilt 2003 · S/N 2214N215EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3172N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184N217DCEasterly Capital LLC · Beverly, MABuilt 2014 · S/N 687N217EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3197N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221N217TMRegistration Pending · Boise, IDRegistration pendingBuilt 2001 · S/N 217N2188AAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 2188N218LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 1496N219RTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2003 · S/N 2189N219SDFreund Gregor · San Francisco, CABuilt 2001 · S/N 2050N219WEFinnegan Dennis M · Novato, CABuilt 1994 · S/N 1695N21AJAllcroft Roger A · Haydenville, MAS/N 754N21ARClarkson Jeffrey D · Park Rapids, MNS/N 755
Back to AD 2003-26-06