AD 2018-20-13
Registered aircraft · 2,770
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:2018-20-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-20-13')
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:2018-20-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-20-13') 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.
N902NNBank Of Utah Trustee · Salt Lake City, UTN9030SSouthwest Airlines Co · Dallas, TXN9031WSouthwest Airlines Co · Dallas, TXN9032RSouthwest Airlines Co · Dallas, TXN9033WSouthwest Airlines Corp · Dallas, TXN9034RSouthwest Airlines Co · Dallas, TXN9035WSouthwest Airlines Co · Dallas, TXN9036WSouthwest Airlines Co · Dallas, TXN9037SSouthwest Airlines Co · Dallas, TXN9038WSouthwest Airlines Co · Dallas, TXN9039SBoeing Co · Renton, WAN903AKAlaska Airlines Inc · Seatac, WAN903ANAmerican Airlines Inc · Fort Worth, TXN903DNDelta Air Lines Inc · Atlanta, GAN903NNWilmington Trust Co Trustee · Wilmington, DEN9040WSouthwest Airlines Co · Dallas, TXN9041JSouthwest Airlines Co · Dallas, TXN9042RSouthwest Airlines Co · Dallas, TXN9043DSouthwest Airlines Co · Dallas, TXN9044HSouthwest Airlines Co · Dallas, TXN9045HBoeing Co · Renton, WAN9046HBoeing Co · Renton, WAN9047RBoeing Co · Renton, WAN9048RBoeing Co · Renton, WAN9049RBoeing Co · Renton, WAN904ANAmerican Airlines Inc · Fort Worth, TXN904DNDelta Air Lines Inc · Atlanta, GAN904NNWilmington Trust Co Trustee · Wilmington, DEN9050RBoeing Co · Renton, WAN9051RBoeing Co · Renton, WAN9052SBoeing Co · Renton, WAN9053WBoeing Co · Renton, WAN9054RBoeing Co · Renton, WAN9055RBoeing Co · Renton, WAN9056WBoeing Co · Renton, WAN9057EBoeing Co · Renton, WAN9058HBoeing Co · Renton, WAN905ANAmerican Airlines Inc · Fort Worth, TXN905DNDelta Air Lines Inc · Atlanta, GAN905NNBank Of Utah Trustee · Salt Lake City, UTN906ANAmerican Airlines Inc · Fort Worth, TXN906DNDelta Air Lines Inc · Atlanta, GAN906NNWilmington Trust Co Trustee · Wilmington, DEN907ANAmerican Airlines Inc · Fort Worth, TXN907DNDelta Air Lines Inc · Atlanta, GAN907NNWilmington Trust Co Trustee · Wilmington, DEN908ANAmerican Airlines Inc · Fort Worth, TXN908DNDelta Air Lines Inc · Atlanta, GAN908NNBank Of Utah Trustee · Salt Lake City, UTN909ANAmerican Airlines Inc · Fort Worth, TX
Back to AD 2018-20-13