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.

N284FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63141 N284NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5045 N284UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48541 N285AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 60577 N285FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63140 N285GXUmb Bank Na Trustee · Salt Lake City, UTBuilt 2006 · S/N 1936 N285NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5067 N286FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63139 N286GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 26245 N286NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4447 N286UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48453 N287AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 36359 N287FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63138 N287KBCsds Asset Management LLC · Marana, AZBuilt 1987 · S/N 49768 N287NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4508 N287UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48539 N288AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 60575 N288FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63137 N288NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2010 · S/N 4537 N288UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48540 N289FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63136 N289GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 3016 N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467 N289NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2011 · S/N 4574 N289UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48455 N290AKAlaska Airlines Inc · Seattle, WABuilt 2018 · S/N 64300 N290CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40564 N290FAUmb Bank N A Trustee · Salt Lake City, UTS/N 29080 N290FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63135 N290NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2191 N290PSNappyboy Skyhaus LLC · Roswell, GABuilt 1999 · S/N 1376 N290UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48456 N290XCMojave Jet LLC · Wilmington, DES/N 290 N29124United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27565 N29129United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28969 N291EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53039 N291FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 63134 N291GXGlobal Crossing Airlines Inc · Miami, FLBuilt 2007 · S/N 3349 N291NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2004 · S/N 2206 N291UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48477 N291VKV-Jet Aircraft Holding Co Trustee · Dover, DES/N 1466 N292AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 64301 N292EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53208 N292FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63133 N292NVBank Of Utah Trustee · Salt Lake City, UTS/N 4891 N292UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48566 N293AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 64302 N293EACorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53209 N293FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 63132 N293NVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4913

Back to AD 2009-21-10 R1