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.

N275AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 61556 N275DJBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N 1167 N275FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66245 N275NVSunrise Asset Management LLC · Las Vegas, NVS/N 2807 N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66251 N276GXFalcon Msn 2695 Trust · Wilmington, DEBuilt 2006 · S/N 2695 N276JMAlta 777 LLC · Salt Lake City, UTS/N 27636 N276NVAllegiant Air LLC · Las Vegas, NVBuilt 2019 · S/N 8671 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N27722United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28789 N27724United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28791 N27733United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28800 N27734United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28949 N277AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 62472 N277FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66246 N277GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 2480 N277NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2007 · S/N 3205 N278AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 44113 N278FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66247 N278GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2003 · S/N 1954 N278NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4253 N278UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48577 N279FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66252 N279NVSunrise Asset Management LLC · Las Vegas, NVS/N 5250 N280AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 60582 N280FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 66253 N280NVDustland LLC · Las Vegas, NVS/N 5320 N2819WDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21057 N281AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 62679 N281AVAircol 14 Trust · Wilmington, DEBuilt 2010 · S/N 4281 N281FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66254 N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455 N281GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2830 N281NVDustland LLC · Las Vegas, NVS/N 5381 N281UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48538 N282AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 62473 N282BTBlue Tide Aviation LLC · Fort Lauderdale, FLBuilt 1997 · S/N SH3419 N282FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63143 N282GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 2851 N282NVSunrise Asset Management LLC · Las Vegas, NVS/N 2875 N283AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 36358 N283CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40566 N283FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63142 N283NVSunrise Asset Management LLC · Las Vegas, NVS/N 2920 N28457United Airlines Inc · Chicago, ILBuilt 2012 · S/N 41744 N2846UUnited Airlines Inc · Chicago, ILBuilt 2018 · S/N 64990 N28478United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31649 N284AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 64152 N284AVAircol 16 · Wilmington, DEBuilt 2010 · S/N 4284

Back to AD 2009-21-10 R1