Skip to content

AD 2008-09-23 R1

Registered aircraft · 492

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:2008-09-23-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:2008-09-23-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:2008-09-23-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:2008-09-23-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:2008-09-23-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:2008-09-23-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.

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 2008-09-23 R1