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.
N920DUBank Of Utah Trustee · Salt Lake City, UTN920NNUmb Bank Na Trustee · Salt Lake City, UTN920UPBoeing Co · Renton, WAN921AKBank Of Utah Trustee · Salt Lake City, UTN921ANAmerican Airlines Inc · Fort Worth, TXN921DUBank Of Utah Trustee · Salt Lake City, UTN921NNBank Of Utah Trustee · Salt Lake City, UTN921UPBoeing Co · Renton, WAN922ANAmerican Airlines Inc · Forth Worth, TXN922DZBank Of Utah Trustee · Salt Lake City, UTN922NNBank Of Utah Trustee · Salt Lake City, UTN922TSAero Micronesia Inc DBA · Barrigada, GUN922UPBoeing Co · Renton, WAN923ANAmerican Airlines Inc · Fort Worth, TXN923DZDelta Air Lines Inc · Atlanta, GAN923FDFederal Express Corp · Memphis, TNN923NNBank Of Utah Trustee · Salt Lake City, UTN923UPBoeing Co · Renton, WAN924AKBank Of Utah Trustee · Salt Lake City, UTN924ANWilmington Trust Co Trustee · Wilmington, DEN924DZBank Of Utah Trustee · Salt Lake City, UTN924FDFederal Express Corp · Memphis, TNN924NNBank Of Utah Trustee · Salt Lake City, UTN924UPBoeing Co · Renton, WAN925ANWilmington Trust Co Trustee · Wilmington, DEN925DZBank Of Utah Trustee · Salt Lake City, UTN925FDFederal Express Corp · Memphis, TNN925NNWilmington Trust Co Trustee · Wilmington, DEN925UPBoeing Co · Renton, WAN9264UTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN926AKBank Of Utah Trustee · Salt Lake City, UTN926ANAmerican Airlines Inc · Fort Worth, TXN926DZBank Of Utah Trustee · Salt Lake City, UTN926NNBank Of Utah Trustee · Salt Lake City, UTN926UPBoeing Co · Renton, WAN927ANAmerican Airlines Inc · Fort Worth, TXN927DZBank Of Utah Trustee · Salt Lake City, UTN927FDFederal Express Corp · Memphis, TNN927NNWilmington Trust Co Trustee · Wilmington, DEN927UPBoeing Co · Renton, WAN928AKAlaska Airlines Inc · Seattle, WAN928ANAmerican Airlines Inc · Fort Worth, TXN928DUBank Of Utah Trustee · Salt Lake City, UTN928NNBank Of Utah Trustee · Salt Lake City, UTN929AKBank Of Utah Trustee · Salt Lake City, UTN929ANAmerican Airlines Inc · Fort Worth, TXN929DZBank Of Utah Trustee · Salt Lake City, UTN929NNBank Of Utah Trustee · Salt Lake City, UTN929UPBoeing Co · Renton, WAN930ANAmerican Airlines Inc · Ft. Worth, TX
Back to AD 2018-20-13