Skip to content

AD 2011-21-07 R1

Registered aircraft · 910

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

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:2011-21-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-21-07-R1') ORDER BY n_number

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

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:2011-21-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-21-07-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N776SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 10241 N778AVBank Of Utah Trustee · Salt Lake City, UTS/N 7784 N779SKSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 10276 N780SKSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 10277 N788CGCorning Inc · Corning, NYBuilt 2009 · S/N 8104 N78EAAuburn-Lewiston Muncipal Airport · Auburn, MEBuilt 2003 · S/N 10103 N791SASlate 791 Holdings LLC · Johnstown, PABuilt 2004 · S/N 7968 N800AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 8000 N800SKSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 15060 N801AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2004 · S/N 8001 N802SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15061 N803SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15062 N804SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15067 N804XNorthrop Grumman Systems Corp · El Segundo, CABuilt 1999 · S/N 10002 N805AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8005 N805SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15069 N805XNorthrop Grumman Systems Corp · El Segundo, CABuilt 2003 · S/N 10091 N806SKSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 15070 N806XNorthrop Grumman Systems Corp · El Segundo, CABuilt 2002 · S/N 10008 N807SKSkywest Airlines Inc · St George, UTS/N 15082 N809SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15086 N810SKDelta Air Lines Inc · Atlanta, GAS/N 15093 N811FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 1994 · S/N 7029 N812SKDelta Air Lines Inc · Atlanta, GAS/N 15098 N813AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8013 N813SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15099 N814SKSkywest Airlines Inc · St George, UTS/N 15100 N815SKSkywest Airlines Inc · St George, UTS/N 15101 N816SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15105 N817SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15107 N819AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8019 N820ASBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 7188 N820AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8020 N820SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 15108 N821AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8021 N821FLGulf & Caribbean Cargo Inc · Waterford, MIBuilt 2005 · S/N 8058 N821SKSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15109 N822SKSkywest Airlines Inc · St George, UTBuilt 2008 · S/N 15203 N823AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8023 N823SKSkywest Airlines Inc · St George, UTBuilt 2008 · S/N 15205 N824AYBeautech Power Systems LLC · Dallas, TXBuilt 2005 · S/N 8024 N824SKSkywest Airlines Inc · St George, UTBuilt 2008 · S/N 15208 N825AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8025 N825SKSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15212 N826AYSlate Crj Acquisitions 1 LLC · Johnstown, PABuilt 2005 · S/N 8026 N826SKBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 15449 N827AYLogos Aviation Inc · Fort Lauderdale, FLBuilt 2005 · S/N 8027 N827SKBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 15451 N829AYFrontera Flight Holdings Inc · Dover, DEBuilt 2005 · S/N 8029 N829SKBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 15452

Back to AD 2011-21-07 R1