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.

N936XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15201 N937EVSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 8042 N937SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7735 N937XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15210 N938SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7741 N939SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7742 N93EAElite Airways LLC · Portland, MEBuilt 2001 · S/N 7563 N940SASlate Aircraft Company LLC · Johnstown, PAS/N 7979 N941SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7750 N943SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7762 N944SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7764 N945LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 15077 N945SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7770 N946LRSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 15104 N946SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7776 N947LRSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15116 N947SASlate Aircraft Company LLC · Johnstown, PAS/N 7963 N947SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7786 N948LRSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15118 N949SJSierra Delta Romeo LLC · Scottsdale, AZBuilt 1996 · S/N 7136 N94PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15094 N950LRSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15119 N951LRSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15123 N951SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7795 N952SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7805 N953SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7813 N954SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7815 N955SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7817 N956SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7825 N957SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7829 N958SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7833 N959SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7840 N95PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15095 N960SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7853 N961SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7857 N962SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7859 N963SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7865 N964SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7868 N965SWSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 7871 N967SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7872 N969SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7876 N96EAAuburn-Lewiston Municipal Airport · Auburn, MEBuilt 2002 · S/N 7700 N970SWSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7881 N971SWSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 7947 N973SWSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 7949 N975SWSky West Airlines Inc · Saint George, UTBuilt 2004 · S/N 7951 N976SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7952 N978SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7953 N979EVLogos Aviation Inc · Fort Lauderdale, FLBuilt 2003 · S/N 7737 N979SWSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 7954

Back to AD 2011-21-07 R1