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.
N769AMUmb Bank Na Trustee · Salt Lake City, UTN77066United Airlines Inc · Chicago, ILN770BBYucaipa Companies LLC · Burbank, CAN770FDFederal Express Corp · Memphis, TNN771FDFederal Express Corp · Memphis, TNN77258United Airlines Inc · Chicago, ILN77259Wilmington Trust Co Trustee · Wilmington, DEN77261United Airlines Inc · Chicago, ILN77295United Airlines Inc · Chicago, ILN77296United Airlines Inc · Chicago, ILN772FDFederal Express Corp · Memphis, TNN773AXCargo Aircraft Management Inc · Wilmington, OHN773FDFederal Express Corp · Memphis, TNN77426Umb Bank Na Trustee · Salt Lake City, UTN77430United Airlines Inc · Chicago, ILN77431United Airlines Inc · Chicago, ILN77471Wilmington Trust Co Trustee · Wilmington, DEN774AXCargo Aircraft Management Inc · Wilmington, OHN774FDFederal Express Corp · Memphis, TNN77510United Airlines Inc · Chicago, ILN77518United Airlines Inc · Chicago, ILN77520United Airlines Inc · Chicago, ILN77525United Airlines Inc · Chicago, ILN77530United Airlines Inc · Chicago, ILN77535United Airlines Inc · Chicago, ILN77536United Airlines Inc · Chicago, ILN77537United Airlines Inc · Chicago, ILN77538United Airlines Inc · Chicago, ILN77539United Airlines Inc · Chicago, ILN77542United Airlines Inc · Chicago, ILN77543United Airlines Inc · Chicago, ILN77544United Airlines Inc · Chicago, ILN77552United Airlines Inc · Chicago, ILN77558United Airlines Inc · Chicago, ILN77559United Airlines Inc · Chicago, ILN77571United Airlines Inc · Chicago, ILN77572United Airlines Inc · Chicago, ILN77573United Airlines Inc · Chicago, ILN77575United Airlines Inc · Chicago, ILN77576United Airlines Inc · Chicago, ILN77578United Airlines Inc · Chicago, ILN77579United Airlines Inc · Chicago, ILN77580United Airlines Inc · Chicago, ILN77581Bank Of Utah Trustee · Salt Lake City, UTN77582Umb Bank Na Trustee · Salt Lake City, UTN77584Umb Bank Na Trustee · Salt Lake City, UTN77585Bank Of Utah Trustee · Salt Lake City, UTN77587Bank Of Utah Trustee · Salt Lake City, UTN77588Umb Bank Na Trustee · Salt Lake City, UTN77590Bank Of Utah Trustee · Salt Lake City, UT
Back to AD 2018-20-13