AD 2000-11-28

Registered aircraft · 282

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
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-11-28')
    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-11-28')
  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.

N194UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26892N195DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28452N195UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26899N196DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28453N197DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28454N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901N198DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28455N199DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28456N207AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30438N219CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24358N225AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30434N225NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25194N227AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27448N227CYCargo Aircraft Management Inc · Wilmington, OHBuilt 1996 · S/N 26327N229AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27059N233AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29430N234AXCargo Aircraft Management Inc · Wilmington, OHBuilt 2001 · S/N 30436N237CMCargo Aircraft Management Inc · Wilmington, OHS/N 25584N239AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27450N241AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27451N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309N255CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22316N257AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29605N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263N267JRKnight Sky II LLC · Miami, FLBuilt 1986 · S/N 23402N269CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 25586N271CMCargo Aircraft Management Inc · Wilmington, OHS/N 22319N283CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40566N290CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40564N298CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2010 · S/N 40565N301CRCobra Aviation Services LLC · Oklahoma City, OKS/N 30331N307AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1997 · S/N 28725N311AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 25316N312AACargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22315N313AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1990 · S/N 24930N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445N317CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24317N319CMCargo Aircraft Management Inc · Wilmington, OHS/N 24407N321CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29431N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914N331AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1991 · S/N 24875N337AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27060N337JXJetonex LLC · Sunny Isles Beach, FLS/N 33734N344CMCargo Aircraft Management Inc · Wilmington, OHS/N 28745N344KDAtares Funding LLC · Miami Beach, FLBuilt 1992 · S/N 26344N347AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26264N347CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26995N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996N351CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25201
Back to AD 2000-11-28