AD 91-07-01
Registered aircraft · 1,096
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:91-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-07-01')
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:91-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-07-01') 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.
N550NWDelta Air Lines Inc · Atlanta, GAN551ASAlaska Airlines Inc · Seattle, WAN551NWDelta Air Lines Inc · Atlanta, GAN552ASAlaska Airlines Inc · Seattle, WAN552NWDelta Air Lines Inc · Atlanta, GAN553ASAlaska Airlines Inc · Seattle, WAN553NWDelta Air Lines Inc · Atlanta, GAN554NWDelta Air Lines Inc · Atlanta, GAN554WTAerownership North American Services Inc Trustee · Dover, DEN555NWDelta Air Lines Inc · Atlanta, GAN556ASAlaska Airlines Inc · Seattle, WAN556NWDelta Air Lines Inc · Atlanta, GAN557ASAlaska Airlines Inc · Seattle, WAN557NWDelta Air Lines Inc · Atlanta, GAN558ASAlaska Airlines Inc · Seattle, WAN559ASAlaska Airlines Inc · Seattle, WAN560ASAlaska Airlines Inc · Seatac, WAN562ASBank Of Utah Trustee · Salt Lake City, UTN563ASAlaska Airlines Inc · Seatac, WAN563WNWilmington Trust Co Trustee · Wilmington, DEN564ASBank Of Utah Trustee · Salt Lake City, UTN565ASAlaska Airlines Inc · Seattle, WAN566ASAlaska Airlines Inc · Seattle, WAN567CACascade Spares Inc · Knoxville, TNN56859United Airlines Inc · Chicago, ILN568ASAlaska Airlines Inc · Seattle, WAN569ASAlaska Airlines Inc · Seatac, WAN570ASAlaska Airlines Inc · Seattle, WAN57111United Airlines Inc · Chicago, ILN571ASUmb Bank Na Trustee · Salt Lake City, UTN577ASAlaska Airlines Inc · Seattle, WAN57852United Airlines Inc · Chicago, ILN57855United Airlines Inc · Chicago, ILN57857United Airlines Inc · Chicago, ILN579ASAlaska Airlines Inc · Seattle, WAN58101United Airlines Inc · Chicago, ILN581ASAlaska Airlines Inc · Seattle, WAN581NWDelta Air Lines Inc · Atlanta, GAN582NWDelta Air Lines Inc · Atlanta, GAN583ASBank Of Utah Trustee · Salt Lake City, UTN583NWDelta Air Lines Inc · Atlanta, GAN584ASBank Of Utah Trustee · Salt Lake City, UTN584NWDelta Air Lines Inc · Atlanta, GAN585ASAlaska Airlines Inc · Seatac, WAN585NWDelta Air Lines Inc · Atlanta, GAN586ASAlaska Airlines Inc · Seatac, WAN586NWDelta Air Lines Inc · Atlanta, GAN587ASAlaska Airlines Inc · Seatac, WAN587NWDelta Air Lines Inc · Atlanta, GAN588ASAlaska Airlines Inc · Seatac, WA
Back to AD 91-07-01