AD 2002-22-17

Registered aircraft · 1,016

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-22-17')
    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-22-17')
  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.

N208SMGrant Aviation Inc · Anchorage, AKBuilt 1999 · S/N 208B0749N208SNStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 2009 · S/N 208B2112N208SVBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 208B1306N208TFMartinaire Aviation LLC · Addison, TXBuilt 1997 · S/N 208B0592N208TMRedding Aero Enterprises Inc · Redding, CABuilt 1994 · S/N 208B0413N208TRSouth Aero Inc · Albuquerque, NMBuilt 2005 · S/N 208B1151N208TWCaravan Air LLC · Oxford, CTBuilt 1998 · S/N 208B0671N208UUSpeedstar Express LLC · Carson City, NVBuilt 1997 · S/N 208B0604N208WSilver Mountain LLC · Port Alsworth, AKBuilt 2015 · S/N 208B5224N208WBAlgot Bernhard Ltd · Anchorage, AKS/N 208B2230N208WFWipaire Inc · South Saint Paul, MNBuilt 2003 · S/N 208B1042N208WWWestwind Aero Group LLC · Phoenix, AZBuilt 1998 · S/N 208B0721N208YYAircraft Structures International Corp · Enid, OKBuilt 1995 · S/N 208B0453N208ZZSpeedstar Express LLC · Carson City, NVBuilt 1991 · S/N 208B0260N209JPBeta Fleet LLC · South Burlington, VTBuilt 2007 · S/N 20800409N20AWWilliams Aviation Assets LLC · Jupiter, FLBuilt 2019 · S/N 208B5534N2114GMission Aviation Fellowship · Nampa, IDBuilt 1999 · S/N 208B0782N212CPTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1996 · S/N 208B0531N213LAJet Rider LLC · Middletown, DEBuilt 2004 · S/N 208B1096N215BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5232N215BTScreen Star Inc Trustee · Wilmington, DEBuilt 2009 · S/N 20800517N215MCTatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1999 · S/N 208B0730N215TXTexas Dept Of Public Safety · Austin, TXBuilt 2012 · S/N 20800542N216RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0379N218LCWright Air Service Inc · Fairbanks, AKBuilt 2018 · S/N 208B5476N218PAPreferred Airparts LLC · Kidron, OHS/N 20800384N21955Pah 6 Inc · Houston, TXBuilt 2017 · S/N 208B5341N220EAEagle Air Transport Inc · Ottawa, ILS/N 208B0151N220XWMartinaire Aviation LLC · Addison, TXBuilt 2000 · S/N 208B0822N223KHAirprop Inc · Portsmouth, NHBuilt 2021 · S/N 208B5621N227GHCarlen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 20800688N228NMpe Beaver LLC · Seattle, WABuilt 2020 · S/N 208B5601N228NDNorth Dakota Dept Of Transportation · Bismarck, NDBuilt 2010 · S/N 20800520N22KWFinn Capital LLC · San Mateo, CABuilt 2015 · S/N 208B5210N22TENv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2007 · S/N 208B1266N22W22w LLC · Tacoma, WABuilt 2020 · S/N 208B5614N2329FFlorida Aeronautical Survey Technologies · Fort Lauderdale, FLBuilt 2011 · S/N 208B2312N233PCWright Air Service Inc · Fairbanks, AKBuilt 2006 · S/N 208B1179N2343XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 208B2343N234WLGalaxy Sea Lift LLC · New York, NYS/N 208B5794N236KAKamaka Air LLC · Honolulu, HIBuilt 2008 · S/N 208B2034N239JRBrykin Leasing Corp · Celina, TXBuilt 2003 · S/N 20800368N240GSCessna 208b-0994 Inc Trustee · Wilmington, DES/N 208B0994N241BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5208N242EWEco Window Systems LLC · Medley, FLBuilt 2015 · S/N 208B5180N242RG242rg LLC · Miami, FLBuilt 2026 · S/N 208B5922N243PWTexas Parks And Wildlife Department · Austin, TXBuilt 2025 · S/N 208B5855N245JSFe Caravan LLC · Kinston, NCBuilt 2014 · S/N 208B5154N247HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800720N247JPSpirit Air Inc · Salmon, IDBuilt 2013 · S/N 208B5047
Back to AD 2002-22-17