AD 2004-22-01
Registered aircraft · 3,402
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:2004-22-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:2004-22-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:2004-22-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:2004-22-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.
N116DNDelta Air Lines Inc · Atlanta, GAN117ANAmerican Airlines Inc · Fort Worth, TXN117DXDelta Air Lines Inc · Atlanta, GAN117UWBank Of Utah Trustee · Salt Lake City, UTN118DYDelta Air Lines Inc · Atlanta, GAN118NNUmb Bank Na Trustee · Salt Lake City, UTN118USBank Of Utah Trustee · Salt Lake City, UTN119DNDelta Air Lines Inc · Atlanta, GAN119FEFederal Express Corp · Memphis, TNN119NAUnited States Government · Washington, DCN119NNUmb Bank Na Trustee · Salt Lake City, UTN119USBank Of Utah Trustee · Salt Lake City, UTN1200KDelta Air Lines Inc · Atlanta, GAN1201PDelta Air Lines Inc · Atlanta, GAN120DNDelta Air Lines Inc · Atlanta, GAN120EEUmb Bank Na Trustee · Salt Lake City, UTN120JMSouth Aircraft Leasing Inc · Wilmington, DEN120UAUnited Airlines Inc · Chicago, ILN120UPUnited Parcel Service Co · Louisville, KYN12109United Airlines Inc · Chicago, ILN12114United Airlines Inc · Chicago, ILN12116United Airlines Inc · Chicago, ILN12125United Airlines Inc · Chicago, ILN1217AAndromeda Leasing I LLC · Purchase, NYN121ANBank Of Utah Trustee · Salt Lake City, UTN121DZDelta Air Lines Inc · Atlanta, GAN121UPUnited Parcel Service Co · Louisville, KYN121UWBank Of Utah Trustee · Salt Lake City, UTN12216United Airlines Inc · Chicago, ILN12218United Airlines Inc · Chicago, ILN12221United Airlines Inc · Chicago, ILN12225United Airlines Inc · Chicago, ILN12238United Airlines Inc · Chicago, ILN1229AAndromeda Leasing I LLC · Purchase, NYN122DNDelta Air Lines Inc · Atlanta, GAN122NNUmb Bank Na Trustee · Salt Lake City, UTN122UAUnited Airlines Inc · Chicago, ILN122UPUnited Parcel Service Co · Louisville, KYN122USBank Of Utah Trustee · Salt Lake City, UTN123DWDelta Air Lines Inc · Atlanta, GAN123NNUmb Bank Na Trustee · Salt Lake City, UTN123UWBank Of Utah Trustee · Salt Lake City, UTN124AABank Of Utah Trustee · Salt Lake City, UTN124DXDelta Air Lines Inc · Atlanta, GAN124UPUnited Parcel Service Co · Louisville, KYN124USBank Of Utah Trustee · Salt Lake City, UTN125AABank Of Utah Trustee · Salt Lake City, UTN125DNDelta Air Lines Inc · Atlanta, GAN125UPUnited Parcel Service Co · Louisville, KYN125UWAmerican Airlines Inc · Forth Worth, TX
Back to AD 2004-22-01