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.

N131EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15217 N132EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15219 N133EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15222 N134EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15223 N135EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15225 N136EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15226 N137EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15227 N138EVDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15235 N146PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15146 N147PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15147 N153PQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15153 N161PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15161 N162PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15162 N166PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15166 N170PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15170 N176PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15176 N181GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15204 N181PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15181 N182GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15175 N183GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15209 N184GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15169 N185GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15185 N186GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15165 N186PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15186 N187GJDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15180 N187PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15187 N195PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15195 N197PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15197 N200PQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15200 N207HBank Of Utah Trustee · Salt Lake City, UTS/N 15207 N228LHAerovision Aircraft Services LLC · Norton Shores, MIS/N 10028 N228PQDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15228 N232PQDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 15232 N239LHAerovision Aircraft Services LLC · Muskegon, MIS/N 10039 N242LRBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 15076 N244LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15233 N245LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15234 N246LRSkywest Airlines Inc · St George, UTBuilt 2009 · S/N 15239 N247LRSkywest Airlines Inc · Saint George, UTBuilt 2011 · S/N 15273 N248LRSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 15274 N249LRSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 15275 N272PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15272 N279PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15279 N292PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15292 N293PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15293 N294PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15294 N295PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15295 N296PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15296 N297PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15297 N298PQDelta Air Lines Inc · Atlanta, GABuilt 2013 · S/N 15298

Back to AD 2008-09-23 R1