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.
N945NNUmb Bank Na Trustee · Salt Lake City, UTN946AKAlaska Airlines Inc · Seattle, WAN946ANAmerican Airlines Inc · Fort Worth, TXN946FDFederal Express Corp · Memphis, TNN946NNBank Of Utah Trustee · Salt Lake City, UTN947AKAlaska Airlines Inc · Seattle, WAN947ANAmerican Airlines Inc · Fort Worth, TXN947FDFederal Express Corp · Memphis, TNN947NNUmb Bank Na Trustee · Salt Lake City, UTN948AKAlaska Airlines Inc · Seattle, WAN948ANAmerican Airlines Inc · Fort Worth, TXN948FDFederal Express Corp · Memphis, TNN948NNBank Of Utah Trustee · Salt Lake City, UTN949AKBank Of Utah Trustee · Salt Lake City, UTN949ANAmerican Airlines Inc · Fort Worth, TXN949FDFederal Express Corp · Memphis, TNN949NNBank Of Utah Trustee · Salt Lake City, UTN950AMUmb Bank Na Owner Trustee · Salt Lake City, UTN950ANAmerican Airlines Inc · Fort Worth, TXN950FDFederal Express Corp · Memphis, TNN950NNWilmington Trust Co Trustee · Wilmington, DEN951AAAmerican Airlines Inc · Fort Worth, TXN951FDFederal Express Corp · Memphis, TNN951NNBank Of Utah Trustee · Salt Lake City, UTN952AAAmerican Airlines Inc · Fort Worth, TXN952AKBank Of Utah Trustee · Salt Lake City, UTN952FDFederal Express Corp · Memphis, TNN952NNWilmington Trust Co Trustee · Wilmington, DEN953AKAlaska Airlines Inc · Seattle, WAN953ANAmerican Airlines Inc · Fort Worth, TXN953FDFederal Express Corp · Memphis, TNN953NNWilmington Trust Co Trustee · Wilmington, DEN954AKAlaska Airlines Inc · Seattle, WAN954ANAmerican Airlines Inc · Fort Worth, TXN954FDFederal Express Corp · Memphis, TNN954NNWilmington Trust Co Trustee · Wilmington, DEN955AKBank Of Utah Trustee · Salt Lake City, UTN955ANAmerican Airlines Inc · Fort Worth, TXN955FDFederal Express Corp · Memphis, TNN955NNWilmington Trust Co Trustee · Wilmington, DEN956AKBank Of Utah Trustee · Salt Lake City, UTN956ANAmerican Airlines Inc · Fort Worth, TXN956FDFederal Express Corp · Memphis, TNN956NNUmb Bank Na Trustee · Salt Lake City, UTN957AMUmb Bank Na Trustee · Salt Lake City, UTN957ANAmerican Airlines Inc · Fort Worth, TXN957NNWilmington Trust Co Trustee · Wilmington, DEN958AKAlaska Airlines Inc · Seatac, WAN958AMUmb Bank Na Trustee · Salt Lake City, UTN958ANAmerican Airlines Inc · Fort Worth, TX
Back to AD 2018-20-13