Skip to content

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

N695CADelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15097 N701SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10133 N702PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10135 N702SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10136 N703PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10137 N703SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10139 N705PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10144 N705SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10145 N706PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10150 N706SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10149 N707SKSkywest Airlines Inc · St George, UTBuilt 1999 · S/N 10003 N708PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10160 N708SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10156 N709SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10159 N710PSDougherty Air Trustee LLC Trustee · Minneapolis, MNBuilt 2004 · S/N 10167 N710SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10170 N712PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10168 N713SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10174 N715SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10179 N716PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10171 N716SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10180 N718PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10175 N718SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10184 N719PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10177 N719SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10188 N720EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10115 N720PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10178 N722EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 10127 N723PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10181 N724SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10189 N725PSAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 10186 N726SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10190 N727SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10191 N728SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10192 N72PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15072 N730EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10141 N730SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10193 N732SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10194 N73PQDelta Air Lines Inc · Atlanta, GABuilt 2006 · S/N 15073 N740EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10151 N740SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10196 N741EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10155 N742SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10197 N743SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10199 N744EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10157 N744SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10200 N745SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10201 N746SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10202 N748EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10158 N748SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10203

Back to AD 2008-09-23 R1