AD 87-07-06

Registered aircraft · 333

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

N286GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 26245N29124United Airlines Inc · Chicago, ILBuilt 1998 · S/N 27565N29129United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28969N303TWLogistic Air Inc · Reno, NVS/N 20116N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914N33103Umb Bank Na Trustee · Salt Lake City, UTBuilt 1994 · S/N 27293N33132United Airlines Inc · Chicago, ILBuilt 1998 · S/N 29281N337JXJetonex LLC · Sunny Isles Beach, FLS/N 33734N34131United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28971N34137United Airlines Inc · Chicago, ILBuilt 1999 · S/N 30229N344KDAtares Funding LLC · Miami Beach, FLBuilt 1992 · S/N 26344N356KDAtares Funding LLC · Miami Beach, FLBuilt 1994 · S/N 26356N373JXJetonex LLC · Sunny Isles Beach, FLS/N 33735N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353N429MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24833N438GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30766N439GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30767N464MCAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 26341N465MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24784N471EVGugu Ltd · Bellevue, WAS/N 20651N471MCAtlas Air Inc · White Plains, NYBuilt 1997 · S/N 26557N472EVFletcher Aviation Services LLC · Bismarck, NDBuilt 1971 · S/N 20320N480MCAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 28812N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968N481MCAtlas Air Inc · Purchase, NYS/N 32339N482MCAtlas Air Inc · Purchase, NYBuilt 2001 · S/N 32340N489MCAtlas Air Inc · Purchase, NYBuilt 1995 · S/N 26553N503UAUnited Airlines Inc · Chicago, ILBuilt 1989 · S/N 24624N507YVBank Of Utah Trustee · Salt Lake City, UTS/N 24607N508UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24744N518UAUnited Airlines Inc · Chicago, ILBuilt 1990 · S/N 24871N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749N539USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26486N540USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26487N541USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26488N542USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26489N543USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26490N544USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26491N545USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26492N547USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26494N548USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26495N549USDelta Air Lines Inc · Atlanta, GABuilt 1996 · S/N 26496N550NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26497N551NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26498N552NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 26499
Back to AD 87-07-06