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.
N694DLDelta Air Lines Inc · Atlanta, GAN695DLDelta Air Lines Inc · Atlanta, GAN696ANBank Of Utah Trustee · Salt Lake City, UTN696DLDelta Air Lines Inc · Atlanta, GAN697ANBank Of Utah Trustee · Salt Lake City, UTN697DLDelta Air Lines Inc · Atlanta, GAN698DLDelta Air Lines Inc · Atlanta, GAN699DLDelta Air Lines Inc · Atlanta, GAN702CAAc Spe 5 LLC · Orlando, FLN703CKKalitta Air LLC · Ypsilanti, MIN705TWDelta Air Lines Inc · Atlanta, GAN711ZXDelta Air Lines Inc · Atlanta, GAN717TWDelta Air Lines Inc · Atlanta, GAN718TWDelta Air Lines Inc · Atlanta, GAN721TWDelta Air Lines Inc · Atlanta, GAN722TWDelta Air Lines Inc · Atlanta, GAN723TWDelta Air Lines Inc · Atlanta, GAN724TWR&W Flying Inc · Greenbrier, ARN727TWDelta Air Lines Inc · Atlanta, GAN729CAAc Spe 6 LLC · Orlando, FLN742CKKalitta Air LLC · Ypsilanti, MIN743CKKalitta Air LLC · Ypsilanti, MIN744CKKalitta Air LLC · Ypsilanti, MIN745CKKalitta Air LLC · Ypsilanti, MIN7470Museum Of Flight Foundation · Seattle, WAN747GFGe Engine Leasing Holdings Inc · Cincinnati, OHN747SFAerospace Trust Management LLC Trustee · Wilmington, DEN74856United Airlines Inc · Chicago, ILN752CXCargo Aircraft Management Inc · Wilmington, OHN752LTL-3 Communications Advanced Aviation LLC · Kalispell, MTN755CSCsds Asset Management LLC · Rllng Hls Est, CAN756CAAc Spe 4 LLC · Orlando, FLN757ABoeing Logistics Spares Inc · Seattle, WAN757AFDjt Operations I LLC · West Palm Beach, FLN757HWHoneywell Aerospace US LLC · Phoenix, AZN757SSRed River Aircraft Leasing LLC · Anchorage, AKN75851United Airlines Inc · Chicago, ILN75853United Airlines Inc · Chicago, ILN75854United Airlines Inc · Chicago, ILN75858United Airlines Inc · Chicago, ILN758SSRed River Aircraft Leasing LLC · Anchorage, AKN766CKKalitta Air LLC · Ypsilanti, MIN767CKKalitta Air LLC · Ypsilanti, MIN768CKKalitta Air LLC · Ypsilanti, MIN770BBYucaipa Companies LLC · Burbank, CAN770FDFederal Express Corp · Memphis, TNN771FDFederal Express Corp · Memphis, TNN772FDFederal Express Corp · Memphis, TNN773FDFederal Express Corp · Memphis, TNN774FDFederal Express Corp · Memphis, TN
Back to AD 87-07-06