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.

N906XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15138 N907EVSkywest Airlines Inc · St George, UTS/N 7648 N907SALead And Steel 2 LLC · Fountain Valley, CABuilt 2004 · S/N 7934 N907XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15139 N908EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7654 N908FJSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 15008 N908SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7540 N908XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15140 N909EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7658 N909SWSkywest Airlines Inc · Saint George, UTBuilt 2001 · S/N 7558 N909XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15141 N910EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7727 N910FJSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 15010 N910SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7566 N910XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15143 N911FJSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 15011 N912EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7728 N912FJSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 15012 N912SWSkywest Airlines Inc · St George, UTBuilt 2001 · S/N 7595 N912XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15144 N913EVSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 7731 N913XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15148 N914EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7752 N914XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15149 N915EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7754 N915FJSkywest Airlines Inc · St George, UTS/N 15015 N915SWSkywest Airlines Inc · St George, UTS/N 7615 N915XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15150 N916EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7757 N916SWSkywest Ailines Inc · St George, UTBuilt 2002 · S/N 7634 N916XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15154 N917EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7769 N917SWSkywest Airlines Inc · Saint George, UTS/N 7641 N917XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15155 N918FJSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 15018 N918SWSkywest Airlines Inc · St George, UTS/N 7645 N918XJDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15156 N919EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7780 N919FJSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 15019 N919SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7657 N919XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15163 N920EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7810 N920FJSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 15020 N920SWCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2002 · S/N 7660 N920XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15167 N921EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7819 N921FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15021 N921XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15172 N922EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7822 N922FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15022

Back to AD 2011-21-07 R1