OpenAirDocs.org
AD 2002-22-13

Registered aircraft · 1,287

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-13')
    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-13')
  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.

N453AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7838N453GLDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1992 · S/N 5107N453SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7743N453TMWheels Up Partners LLC · New York, NYBuilt 2008 · S/N RK581N454AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7842N454SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7749N455AWCsi Aviation Inc · Killeen, TXBuilt 2003 · S/N 7848N455CALogos Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 7592N455SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7760N456ZWRi Voyager LLC · Beverly, MABuilt 2003 · S/N 7849N457AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7854N457SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7773N458AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7861N458SFAcme Leasing III LLC · Nashville, TNBuilt 1994 · S/N RK-90N459AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7863N459SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7782N45RKTeam Aero LLC · Shawnee, KSS/N RK-43N460AWCsi Aviation Inc · Killeen, TXBuilt 2003 · S/N 7867N460SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7803N460TMJersey Aviation LLC · Stamford, CTBuilt 2007 · S/N RK-516N461SJFlight Options LLC · Cleveland, OHBuilt 2001 · S/N RK-327N461SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7811N462AWAir Wisconsin Airlines LLC · Appleton, WIBuilt 2003 · S/N 7875N462SJFlight Options LLC · Cleveland, OHBuilt 2001 · S/N RK-317N463AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 7878N463SJFlight Options LLC · Cleveland, OHBuilt 2003 · S/N RK-368N463SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7820N464AWCsi Aviation Inc · Killeen, TXS/N 7890N464SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7827N465AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 7893N465SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7845N466AWAir Wisconsin Airlines LLC · Appleton, WIS/N 7899N466SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7856N467AWM&D Aviation LLC · Sachse, TXS/N 7900N468AWAir Wisconsin Airlines LLC · Appleton, WIS/N 7916N468CASkywest Airlines Inc · St George, UTS/N 7649N469AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 7917N469EDEjd Air III LLC · Memphis, TNBuilt 2006 · S/N 5746N470ZWCsi Aviation Inc · Killeen, TXBuilt 2004 · S/N 7927N471CASkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7655N471ZWCsi Aviation Inc · Killeen, TXBuilt 2000 · S/N 7457N472CACorporate Flight Management Inc · Smyrna, TNBuilt 2002 · S/N 7667N472EMCarver Air LLC · Albany, NYBuilt 2006 · S/N RK-472N472GJAlliance Aviation Group LLC · Wilmington, DES/N RK-481N473FLNam Jet LLC · Great Neck, NYBuilt 2004 · S/N RK-397N475AE4s Air LLC · Valdosta, GABuilt 2001 · S/N 5516N475TCMtj Aviation LLC · Mooresville, NCBuilt 1997 · S/N RK158N475XPL And P Air 1 LLC · Lees Summit, MOBuilt 2006 · S/N RK-475N476BJDodson International Parts Inc · Rantoul, KSBuilt 1998 · S/N RK-176N477CASkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7670
Back to AD 2002-22-13