Registered aircraft · 64

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

N1511AAtlas Air Inc · Purchase, NYBuilt 1989 · S/N 24318 N1619AAtlas Air Inc · Purchase, NYBuilt 1994 · S/N 26208 N172DNDelta Air Lines Inc · Atlanta, GABuilt 1990 · S/N 24775 N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901 N220CYCargo Aircraft Management Inc · Wilmington, OHS/N 24729 N226CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 26544 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 N625HRFertitta Db Inc · Houston, TXBuilt 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

Back to AD 2000-22-01