Skip to content

Registered aircraft · 129

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:2001-20-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-13') 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:2001-20-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-13')
  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:2001-20-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-20-13')
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.

N275UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48774 N276UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48579 N284UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48541 N286UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48453 N287UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 48539 N288UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 48540 N289UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48455 N290UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48456 N291UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48477 N293UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48473 N294UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48472 N351SLBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 001 N461FTBoeing Company · Renton, WABuilt 2014 · S/N 41273 N462KCBoeing Co · Renton, WABuilt 2015 · S/N 41275 N463FTBoeing Company · Renton, WABuilt 2017 · S/N 34054 N464KCBoeing Co · Renton, WABuilt 2016 · S/N 41274 N471MCAtlas Air Inc · White Plains, NYBuilt 1997 · S/N 26557 N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553 N521FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48478 N522FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48476 N525FEFederal Express Corp · Memphis, TNBuilt 1993 · S/N 48565 N529FEFederal Express Corp · Memphis, TNBuilt 1998 · S/N 48624 N566NCNas Aircraft Leasing Co LLC · Anchorage, AKBuilt 2000 · S/N 30566 N625HRTryst 767 LLC · San Juan, PRBuilt 1992 · S/N 25287 N631FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 48454 N642FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48485 N643FEFederal Express Corp · Memphis, TNBuilt 1992 · S/N 48486 N648UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25285 N649UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25286 N655UAUnited Airlines Inc · Chicago, ILBuilt 1992 · S/N 25393 N662GTAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 27619 N670UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29240 N684UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 33466 N685UAUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 33467 N686UAUnited Airlines Inc · Chicago, ILBuilt 2003 · S/N 33468 N701CKKalitta Air LLC · Ypsilanti, MIBuilt 2000 · S/N 26416 N702CAAc Spe 5 LLC · Orlando, FLBuilt 1994 · S/N 27217 N702CKKalitta Air LLC · Ypsilanti, MIBuilt 2000 · S/N 26411 N703CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24226 N705CKKalitta Air LLC · Ypsilanti, MIBuilt 2001 · S/N 26413 N706CKKalitta Air LLC · Ypsilanti, MIBuilt 2001 · S/N 27073 N707CKKalitta Air LLC · Ypsilanti, MIBuilt 1992 · S/N 26395 N708CKKalitta Air LLC · Ypsilanti, MIBuilt 1991 · S/N 25275 N709CKKalitta Air LLC · Ypsilanti, MIBuilt 1993 · S/N 26396 N710CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N 26406 N712CKKalitta Air LLC · Ypsilanti, MIBuilt 2002 · S/N 26414 N713CKKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32808 N715CKKalitta Air LLC · Ypsilanti, MIBuilt 2002 · S/N 32809 N716CKKalitta Air LLC · Ypsilanti, MIBuilt 1998 · S/N 26408 N717FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 361

Back to AD 2001-20-13