Skip to content

AD 2009-21-10 R1

Registered aircraft · 4,274

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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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.

N552UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4957 N553AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53083 N553ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34594 N553NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26500 N553SXUmb Bank Na Trustee · Salt Lake City, UTS/N 3171 N553UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4960 N554JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1898 N554NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26501 N554SLStewart Aviation Services LLC · Birmingham, ALBuilt 1998 · S/N 1343 N554UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2011 · S/N 4966 N554WTAerownership North American Services Inc Trustee · Dover, DES/N 28554 N555NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33391 N556AAFrontera Flight Holding Inc · Dover, DEBuilt 1991 · S/N 53086 N556ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35175 N556JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1904 N556NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33392 N556UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5244 N557ANPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53087 N557ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35176 N557AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5057 N557GGArmo Aviation LLC · Los Angeles, CAS/N 1276 N557NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 33393 N557UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5269 N558AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53088 N558ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35177 N558JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1915 N558UWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5282 N559ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35178 N559JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 1917 N559LCOlympia Aviation LLC · Detroit, MIBuilt 1995 · S/N 1259 N559UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5292 N55TDLandlocked Company LLC · Dover, DEBuilt 1990 · S/N 1131 N560AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53090 N560ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35179 N560UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5300 N561AAPac Blue Aerospace · Fairbanks, AKBuilt 1991 · S/N 53091 N561JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1927 N561UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5317 N562ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35091 N562AVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5622 N562JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 1948 N562UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5332 N563ASAlaska Airlines Inc · Seatac, WABuilt 2006 · S/N 35180 N563JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 2006 N563UWAmerican Airlines Inc · Fort Worth, TXBuilt 2012 · S/N 5368 N563WNWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N 34296 N564ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35103 N564JBJetblue Airways Corp · Long Island City, NYBuilt 2003 · S/N 2020 N564LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 40593 N565ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 35181

Back to AD 2009-21-10 R1