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.

N922XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15174 N923EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7826 N923FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15023 N923SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7664 N923XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15177 N924CNCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2001 · S/N 7494 N924FJBank Of Utah Trustee · Salr Lake City, UTBuilt 2004 · S/N 15024 N924SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7681 N924XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15179 N925EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7831 N925FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15025 N925SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7682 N925XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15183 N926EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7843 N926LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15026 N926SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7687 N926XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15184 N927EVFrontera Flight Holdings Inc · Dover, DEBuilt 2003 · S/N 7844 N927LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15027 N927SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7693 N927XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15188 N928EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 8006 N928LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15028 N928SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7701 N928XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15190 N929EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 8007 N929LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15029 N929SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7703 N929XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15191 N930EVSkywest Airlines Inc · St George, UTS/N 8014 N930LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15030 N930SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7713 N930XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15192 N931EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8015 N931LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15031 N931XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15193 N932EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8016 N932LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15032 N932SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7714 N932XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15194 N933EVSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 8022 N933LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15033 N933XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15196 N934SWSkywest Airlines Inc · Saint George, UTBuilt 2002 · S/N 7722 N934XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15198 N935LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15035 N935SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7725 N935XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15199 N936EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8038 N936SWSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7726

Back to AD 2011-21-07 R1