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.

N588NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32988 N589ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35686 N589FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48491 N589JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2215 N589NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32989 N58JEKamali Aviation LLC · Great Neck, NYBuilt 1998 · S/N 1350 N59053United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29448 N590AAFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 53253 N590ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35687 N590FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48505 N590JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2231 N590NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32990 N591FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48527 N591JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2246 N591NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32991 N592ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35190 N592FEFederal Express Corp · Memphis, TNS/N 48550 N592JBJetblue Airways Corporation · Long Island City, NYBuilt 2004 · S/N 2259 N592NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32992 N592RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 1396 N593ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35107 N593FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48551 N593JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2280 N593NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32993 N594ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35191 N594FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48552 N594JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2284 N594NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32994 N595AAPac Blue Aerospace · Fairbanks, AKBuilt 1992 · S/N 53285 N595FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48553 N595JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2286 N595NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32995 N596ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35688 N596FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48554 N596NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32996 N597ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35689 N597FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48596 N597JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2307 N598FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48597 N598JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2314 N599AVWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2011 · S/N 4599 N599FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48598 N599JBJetblue Airways Corp · Long Island City, NYBuilt 2004 · S/N 2336 N5GFSdl Gulfstream LLC · Wilmington, DEBuilt 1995 · S/N 1277 N5MCGeorgetown Interstate Aviation Inc · Santa Barbara, CABuilt 1993 · S/N 1218 N600CKNb Airlines LLC · Miami, FLBuilt 1991 · S/N 1169 N601AWAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 1935 N601FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48401 N601NKBank Of Utah Trustee · Sale Lake City, UTBuilt 2010 · S/N 4206 N602FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48402

Back to AD 2009-21-10 R1