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.
N315UAAmerican Airlines Inc · Fort Worth, TXN315UUAmerican Airlines Inc · Fort Worth, TXN315VCAmerican Airlines Inc · Fort Worth, TXN3160GUmb Bank Na Trustee · Salt Lake City, UTN316PFAmerican Airlines Inc · Fort Worth, TXN316RKWilmington Trust Co Trustee · Wilmington, DEN316SEWilmington Trust Co Trustee · Wilmington, DEN316UVAmerican Airlines Inc · Fort Worth, TXN316VDAmerican Airlines Inc · Fort Worth, TXN317AZCargo Aircraft Management Inc · Wilmington, OHN317CMCargo Aircraft Management Inc · Wilmington, OHN317PGAmerican Airlines Inc · Fort Worth, TXN317UWAmerican Airlines Inc · Fort Worth, TXN317VEAmerican Airlines Inc · Fort Worth, TXN318FLUmb Bank Na Trustee · Salt Lake City, UTN318SFWilmington Trust Co Trustee · Wilmington, DEN318TDAmerican Airlines Inc · Fort Worth, TXN318UXAmerican Airlines Inc · Fort Worth, TXN319CMCargo Aircraft Management Inc · Wilmington, OHN319TEAmerican Airlines Inc · Fort Worth, TXN319UYAmerican Airlines Inc · Fort Worth, TXN319VFAmerican Airlines Inc · Fort Worth, TXN320TFAmerican Airlines Inc · Fort Worth, TXN320VGAmerican Airlines Inc · Fort Worth, TXN321CMCargo Aircraft Management Inc · Wilmington, OHN321RLWilmington Trust Co Trustee · Wilmington, DEN321TGAmerican Airlines Inc · Fort Worth, TXN321VHAmerican Airlines Inc · Fort Worth, TXN322THAmerican Airlines Inc · Fort Worth, TXN322VJAmerican Airlines Inc · Fort Worth, TXN323CMBank Of Utah Trustee · Salt Lake City, UTN323RMWilmington Trust Co Trustee · Wilmington, DEN323SGWilmington Trust Co Trustee · Wilmington, DEN323VKAmerican Airlines Inc · Fort Worth, TXN32404United Airlines Inc · Chicago, ILN324RAAmerican Airlines Inc · Fort Worth, TXN324RNWilmington Trust Co Trustee · Wilmington, DEN324SHWilmington Trust Co Trustee · Wilmington, DEN324VLAmerican Airlines Inc · Fort Worth, TXN325FLUmb Bank Na Trustee · Salt Lake City, UTN325VMAmerican Airlines Inc · Fort Worth, TXN326FLUmb Bank Na Trustee · Salt Lake City, UTN326RPWilmington Trust Co Trustee · Wilmington, DEN326SJWilmington Trust Co Trustee · Wilmington, DEN326VNAmerican Airlines Inc · Fort Worth, TXN327SKWilmington Trust Co Trustee · Wilmington, DEN327VPAmerican Airlines Inc · Fort Worth, TXN328RRWilmington Trust Co Trustee · Wilmington, DEN328TCAmerican Airlines Inc · Fort Worth, TXN329SLWilmington Trust Co Trustee · Wilmington, DE
Back to AD 2018-20-13