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.

N828JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5723 N828MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29699 N828UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 1031 N829AWU S Bank Na Trustee · Boston, MAS/N 1563 N829DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31941 N829MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29700 N829NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33210 N829UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1211 N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503 N8306Omega Air Inc · Selma, TXS/N 48306 N8308Omega Air Inc · Selma, TXS/N 48308 N830AWU S Bank Na Trustee · Boston, MAS/N 1565 N830DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31940 N830KWAlta 777 LLC · Salt Lake City, UTS/N 30870 N830MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29701 N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091 N830UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1243 N8310Omega Air Inc · Selma, TXS/N 48310 N831AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1576 N831DNDelta Air Lines Inc · Atlanta, GABuilt 2014 · S/N 31942 N831MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29702 N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211 N831UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1291 N832AWUS Bank Na Trustee · Boston, MABuilt 2001 · S/N 1643 N832DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31943 N832MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29704 N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521 N832UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1321 N832USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53259 N833AWU S Bank Na Trustee · Boston, MABuilt 2002 · S/N 1844 N833DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31944 N833KWAlta 777 LLC · Salt Lake City, UTS/N 30868 N833MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29706 N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093 N833UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 1401 N833USUSA Jet Airlines Inc · Belleville, MIBuilt 1991 · S/N 53215 N834ASAersale Inc · Coral Gables, FLS/N 28834 N834AWAmerican Airlines Inc · Fort Worth, TXS/N 2302 N834DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31946 N834JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5782 N834KWAlta 777 LLC · Salt Lake City, UTS/N 32317 N834MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29707 N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576 N834UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 1420 N834USUSA Jet Airlines Inc · Belleville, MIBuilt 1990 · S/N 53115 N835AWWilmington Trust Co Trustee · Wilmington, DES/N 2458 N835DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31945 N835FDBoeing Co · Renton, WAS/N 70865 N835MHDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29708 N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577

Back to AD 2009-21-10 R1