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.
N553NWDelta Air Lines Inc · Atlanta, GAN554NWDelta Air Lines Inc · Atlanta, GAN555NWDelta Air Lines Inc · Atlanta, GAN556NWDelta Air Lines Inc · Atlanta, GAN557NWDelta Air Lines Inc · Atlanta, GAN567CACascade Spares Inc · Knoxville, TNN56859United Airlines Inc · Chicago, ILN569CAAc Spe 11 LLC · Orlando, FLN57111United Airlines Inc · Chicago, ILN57852United Airlines Inc · Chicago, ILN57855United Airlines Inc · Chicago, ILN57857United Airlines Inc · Chicago, ILN580UPC C & E I LLC · Louisville, KYN58101United Airlines Inc · Chicago, ILN581NWDelta Air Lines Inc · Atlanta, GAN582NWDelta Air Lines Inc · Atlanta, GAN583NWDelta Air Lines Inc · Atlanta, GAN584NWDelta Air Lines Inc · Atlanta, GAN585NWDelta Air Lines Inc · Atlanta, GAN586NWDelta Air Lines Inc · Atlanta, GAN587NWDelta Air Lines Inc · Atlanta, GAN588NWDelta Air Lines Inc · Atlanta, GAN589NWDelta Air Lines Inc · Atlanta, GAN590NWDelta Air Lines Inc · Atlanta, GAN591NWDelta Air Lines Inc · Atlanta, GAN592NWDelta Air Lines Inc · Atlanta, GAN593NWDelta Air Lines Inc · Atlanta, GAN594NWDelta Air Lines Inc · Atlanta, GAN595NWDelta Air Lines Inc · Atlanta, GAN596NWDelta Air Lines Inc · Atlanta, GAN604AABischoff Aerospace Inc · Doral, FLN606AAStrategic Odyssey I LLC · Miami, FLFirst renewal noticeN608DADelta Air Lines Inc · Atlanta, GAN617USLogistic Air Inc · Reno, NVN618USLogistic Air Inc · Reno, NVN620DLAerotrust Services Corp Trustee · Wilmington, DEN649DLDelta Air Lines Inc · Atlanta, GAN650DLDelta Air Lines Inc · Atlanta, GAN651DLDelta Air Lines Inc · Atlanta, GAN652DLDelta Air Lines Inc · Atlanta, GAN654DLDelta Air Lines Inc · Atlanta, GAN655DLDelta Air Lines Inc · Atlanta, GAN658DLDelta Air Lines Inc · Atlanta, GAN659DLDelta Air Lines Inc · Atlanta, GAN660DLDelta Air Lines Inc · Atlanta, GAFirst renewal noticeN661DNDelta Air Lines Inc · Atlanta, GAN661USDelta Air Lines Inc · Atlanta, GAN662DNDelta Air Lines Inc · Atlanta, GAN663DNDelta Air Lines Inc · Atlanta, GAN664DNDelta Air Lines Inc · Atlanta, GA
Back to AD 87-07-06