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.
N330AEBank Of Utah Trustee · Salt Lake City, UTN330TJAmerican Airlines Inc · Fort Worth, TXN33103Umb Bank Na Trustee · Salt Lake City, UTN33132United Airlines Inc · Chicago, ILN331AZCargo Aircraft Management Inc · Wilmington, OHN331TKAmerican Airlines Inc · Fort Worth, TXN33203United Airlines Inc · Chicago, ILN33209United Airlines Inc · Chicago, ILN33262United Airlines Inc · Chicago, ILN33264United Airlines Inc · Chicago, ILN33266United Airlines Inc · Chicago, ILN33284Umb Bank Na Trustee · Salt Lake City, UTN33286United Airlines Inc · Chicago, ILN33289United Airlines Inc · Chicago, ILN33292United Airlines Inc · Chicago, ILN33294Wells Fargo Trust Co Na Trustee · Columbia, MDN334SMWilmington Trust Co Trustee · Wilmington, DEN334TLAmerican Airlines Inc · Fort Worth, TXN335PHAmerican Airlines Inc · Fort Worth, TXN335RTWilmington Trust Co Trustee · Wilmington, DEN335SNWilmington Trust Co Trustee · Wilmington, DEN336RUWilmington Trust Co Trustee · Wilmington, DEN336SRWilmington Trust Co Trustee · Wilmington, DEN336TMAmerican Airlines Inc · Fort Worth, TXN33714United Airlines Inc · Chicago, ILN337AZCargo Aircraft Management Inc · Wilmington, OHN337PJWilmington Trust Co Trustee · Wilmington, DEN337TNAmerican Airlines Inc · Fort Worth, TXN338PKWilmington Trust Co Trustee · Wilmington, DEN338RSWilmington Trust Co Trustee · Wilmington, DEN338STWilmington Trust Co Trustee · Wilmington, DEN339PLWilmington Trust Co Trustee · Wilmington, DEN339SUWilmington Trust Co Trustee · Wilmington, DEN339TPAmerican Airlines Inc · Fort Worth, TXN34131United Airlines Inc · Chicago, ILN34137United Airlines Inc · Chicago, ILN341RWWilmington Trust Co Trustee · Wilmington, DEN341SVWilmington Trust Co Trustee · Wilmington, DEN341TRAmerican Airlines Inc · Fort Worth, TXN34222United Airlines Inc · Chicago, ILN34282Umb Bank Na Trustee · Salt Lake City, UTN342PMWilmington Trust Co Trustee · Wilmington, DEN342RXBank Of Utah Trustee · Salt Lake City, UTN342SXAmerican Airlines Inc · Fort Worth, TXN343PNWilmington Trust Co Trustee · Wilmington, DEN343RYBank Of Utah Trustee · Salt Lake City, UTN343SYAmerican Airlines Inc · Fort Worth, TXN34455United Airlines Inc · Chicago, ILN34460United Airlines Inc · Chicago, ILN344CMCargo Aircraft Management Inc · Wilmington, OH
Back to AD 2018-20-13