AD 2012-22-10

Registered aircraft · 501

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

N678CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15125N679CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15132N681SKSkywest Leasing Inc · St George, UTS/N 10036N686SKSkywest Leasing Inc · St George, UTS/N 10096N689CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15133N690CADelta Air Lines Inc · Atlanta, GAS/N 10182N690SKSkywest Leasing Inc · St George, UTS/N 10264N691CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15136N692CADelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15092N693CADelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15096N695CADelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15097N701SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10133N702PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10135N702SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10136N703PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10137N703SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10139N705PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10144N705SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10145N706PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10150N706SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10149N707SKSkywest Airlines Inc · St George, UTBuilt 1999 · S/N 10003N708PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10160N708SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10156N709SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10159N710PSDougherty Air Trustee LLC Trustee · Minneapolis, MNBuilt 2004 · S/N 10167N710SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10170N712PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10168N713SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10174N715SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10179N716PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10171N716SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10180N718PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10175N718SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10184N719PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10177N719SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10188N720EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10115N720PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10178N722EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 10127N723PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10181N724SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10189N725PSAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 10186N726SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10190N727SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10191N728SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10192N72PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15072N730EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10141N730SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10193N732SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10194N73PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15073N740EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10151
Back to AD 2012-22-10