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.
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
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.
N286GBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN29124United Airlines Inc · Chicago, ILN29129United Airlines Inc · Chicago, ILN303TWLogistic Air Inc · Reno, NVN322SGAtlas Air Inc · Purchase, NYN329ZAKalitta Air LLC · Ypsilanti, MIN33103Umb Bank Na Trustee · Salt Lake City, UTN33132United Airlines Inc · Chicago, ILN337JXJetonex LLC · Sunny Isles Beach, FLN34131United Airlines Inc · Chicago, ILN34137United Airlines Inc · Chicago, ILN344KDAtares Funding LLC · Miami Beach, FLN356KDAtares Funding LLC · Miami Beach, FLN373JXJetonex LLC · Sunny Isles Beach, FLN404KZWilmington Trust Co Trustee · Wilmington, DEN405KZWilmington Trust Co Trustee · Wilmington, DEN406KZWilmington Trust Co Trustee · Wilmington, DEN41135United Airlines Inc · Chicago, ILN41140United Airlines Inc · Chicago, ILN429MCAtlas Air Inc · Purchase, NYN438GTAtlas Air Inc · White Plains, NYN439GTAtlas Air Inc · White Plains, NYN464MCAtlas Air Inc · Purchase, NYN465MCAtlas Air Inc · Purchase, NYN471EVGugu Ltd · Bellevue, WAN471MCAtlas Air Inc · White Plains, NYN472EVFletcher Aviation Services LLC · Bismarck, NDN480MCAtlas Air Inc · Purchase, NYN48127United Airlines Inc · Chicago, ILN481MCAtlas Air Inc · Purchase, NYN482MCAtlas Air Inc · Purchase, NYN489MCAtlas Air Inc · Purchase, NYN503UAUnited Airlines Inc · Chicago, ILN507YVBank Of Utah Trustee · Salt Lake City, UTN508UAUnited Airlines Inc · Chicago, ILN518UAUnited Airlines Inc · Chicago, ILN537CAAc Spe 10 LLC · Orlando, FLN539USDelta Air Lines Inc · Atlanta, GAN540USDelta Air Lines Inc · Atlanta, GAN541USDelta Air Lines Inc · Atlanta, GAN542USDelta Air Lines Inc · Atlanta, GAN543USDelta Air Lines Inc · Atlanta, GAN544USDelta Air Lines Inc · Atlanta, GAN545USDelta Air Lines Inc · Atlanta, GAN547USDelta Air Lines Inc · Atlanta, GAN548USDelta Air Lines Inc · Atlanta, GAN549USDelta Air Lines Inc · Atlanta, GAN550NWDelta Air Lines Inc · Atlanta, GAN551NWDelta Air Lines Inc · Atlanta, GAN552NWDelta Air Lines Inc · Atlanta, GA
Back to AD 87-07-06