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.

N536AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2012 · S/N 5360 N536JBJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1784 N536LAChirihue Leasing Trust · Wilmington, DEBuilt 2001 · S/N 32573 N536UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4025 N537ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 35204 N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749 N537JTJetblue Airways Corp · Long Island City, NYBuilt 2002 · S/N 1785 N537UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4041 N538ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41188 N538AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 5398 N538LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2006 · S/N 34628 N538UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4050 N539USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26486 N539UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4082 N53WGAlliance Aviation Group LLC · Lawrence, KSBuilt 2003 · S/N 1505 N540LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 35229 N540USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26487 N540UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4107 N541USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26488 N54241United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28953 N542KDAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48542 N542LAQuetro Aircraft Leasing Trust · Wilmington, DEBuilt 2008 · S/N 34629 N542USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26489 N542UWAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 4134 N543JNAtares Funding LLC · Fisher Island, FLBuilt 1994 · S/N 48543 N543USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26490 N543UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4843 N544USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26491 N544UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4847 N545JNAtares Funding LLC · Miami Beach, FLBuilt 1995 · S/N 48545 N545USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26492 N545UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4850 N546ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30022 N546JNAtares Funding LLC · Fisher Island, FLBuilt 1995 · S/N 48546 N546UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4885 N54711United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28782 N547JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1849 N547USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26494 N548ASAlaska Airlines Inc · Seattle, WABuilt 2005 · S/N 30020 N548USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26495 N549USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26496 N549UWAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 4932 N550NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26497 N551ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34593 N551CBModern Industrial Services Inc · Beaumont, TXBuilt 2001 · S/N 1449 N551NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26498 N551UWUmb Bank N A Trustee · Salt Lake City, UTBuilt 2011 · S/N 4940 N552ASAlaska Airlines Inc · Seattle, WABuilt 2006 · S/N 34595 N552JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 1861 N552NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26499

Back to AD 2009-21-10 R1