Skip to content

AD 2005-13-02 R1

Registered aircraft · 493

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:2005-13-02-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:2005-13-02-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:2005-13-02-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:2005-13-02-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:2005-13-02-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:2005-13-02-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.

N919XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15163 N920FJSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 15020 N920XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15167 N921FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15021 N921XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15172 N922FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15022 N922XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15174 N923FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15023 N923XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15177 N924FJBank Of Utah Trustee · Salr Lake City, UTBuilt 2004 · S/N 15024 N924XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15179 N925FJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15025 N925XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15183 N926LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 15026 N926XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15184 N927LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15027 N927XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15188 N928LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15028 N928XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15190 N929LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15029 N929XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15191 N930LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15030 N930XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15192 N931LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15031 N931XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15193 N932LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15032 N932XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15194 N933LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15033 N933XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15196 N934XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15198 N935LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 15035 N935XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15199 N936XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15201 N937XJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15210 N945LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 15077 N946LRSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 15104 N947LRSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15116 N948LRSkywest Airlines Inc · St George, UTBuilt 2007 · S/N 15118 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 N95PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15095 N99KUSkywest Leasing Inc · St George, UTBuilt 2002 · S/N 10032

Back to AD 2005-13-02 R1