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.

N602KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23306 N602NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4264 N603AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48267 N603FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48459 N603JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2352 N603KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23213 N603NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4321 N60491Umb Bank Na Trustee · Salt Lake City, UTS/N 60491 N604AABischoff Aerospace Inc · Doral, FLBuilt 1995 · S/N 27055 N604AWUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 1196 N604FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48460 N604JMRegistered aircraftS/N 1301 N604KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1988 · S/N 24145 N604NKBank Of Utah Trustee · Salt Lake City, UTS/N 4431 N605FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48514 N605JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2368 N605KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1984 · S/N 23180 N605NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4548 N605RASmb G-IV Vii LLC · Longwood, FLBuilt 1987 · S/N 1028 N606AAStrategic Odyssey I LLC · Miami, FLFirst renewal noticeBuilt 1996 · S/N 27057 N606FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48602 N606JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2384 N606KWAlta 767 Spv LLC · Salt Lake City, UTS/N 24324 N606MHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1107 N606NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4592 N606PSWorldwide Option LLC · Lewes, DEBuilt 2002 · S/N 1477 N607ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29751 N607AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30573 N607FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48547 N607JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2386 N607NKWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 4595 N607SBPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1997 · S/N 1308 N608DADelta Air Lines Inc · Atlanta, GABuilt 1985 · S/N 22815 N608FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48548 N608JBJetblue Airways Corp · Long Island City, NYBuilt 2005 · S/N 2415 N608LHAsturias Air Services Inc · Miami, FLS/N 1162 N608NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4902 N60958Umb Bank Na Trustee · Salt Lake City, UTS/N 60958 N609ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29752 N609FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48549 N609NKBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4951 N60GGSuperior Transportation Associates Inc · Costa Mesa, CABuilt 1998 · S/N 1351 N60LDRegistered aircraftBuilt 1994 · S/N 1242 N60VLBank Of Utah Trustee · Salt Lake City, UTS/N 39254 N610FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48603 N611ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 29753 N611NKWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 4996 N612ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30162 N612AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48290 N612FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48605

Back to AD 2009-21-10 R1