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.

N239NVUmb Bank N A Trustee · Salt Lake City, UTS/N 2144 N24089Ploutz Lloyd · Modesto, CAS/N 20455 N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451 N24202United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30429 N24211United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28771 N24212United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28772 N24224United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28933 N244FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67549 N245ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35099 N245FEFederal Express Corp · Memphis, TNBuilt 2026 · S/N 67548 N245NVSunrise Asset Management LLC · Las Vegas, NVS/N 1550 N246FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67547 N246NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7664 N24702United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28763 N24706United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28767 N24715United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28786 N24729United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28945 N24736United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28803 N247AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36364 N247FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67546 N247LMLive Mas Enterprises LLC · Greenwood Village, COBuilt 1994 · S/N 1258 N247NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7704 N248AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 62469 N248FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67545 N248NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7781 N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309 N249FEFederal Express Corporation · Memphis, TNBuilt 2025 · S/N 67544 N249NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7766 N250FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67543 N250KCFlight 444 LLC · Atlanta, GABuilt 1987 · S/N 1025 N250NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7743 N250RGAviation Co Inc · Cheyenne, WYBuilt 1986 · S/N 1003 N250UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48745 N251AKAlaska Airlines Inc · Seatac, WAS/N 62470 N251FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67542 N251NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7838 N251UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48744 N25201United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28958 N252FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67541 N252NJAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 252 N252NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2017 · S/N 7868 N252UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48768 N2534UUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 62645 N253ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 3690 N253AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36348 N253FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67540 N253GCAerway Capital Management LLC · Waterford, WIS/N 25303 N253NVAllegiant Air LLC · Las Vegas, NVBuilt 2017 · S/N 7900 N253UPUnited Parcel Service Co · Louisville, KYS/N 48439 N254CAMmap LLC · Houston, TXBuilt 1987 · S/N 1054

Back to AD 2009-21-10 R1