AD 2007-19-13
Registered aircraft · 2,446
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:2007-19-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:2007-19-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:2007-19-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:2007-19-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.
N560ASAlaska Airlines Inc · Seatac, WAN560UWAmerican Airlines Inc · Fort Worth, TXN561JBBank Of Utah Trustee · Salt Lake City, UTN561UWAmerican Airlines Inc · Fort Worth, TXN562ASBank Of Utah Trustee · Salt Lake City, UTN562AVUmb Bank Na Trustee · Salt Lake City, UTN562JBBank Of Utah Trustee · Salt Lake City, UTN562UWAmerican Airlines Inc · Fort Worth, TXN563ASAlaska Airlines Inc · Seatac, WAN563JBBank Of Utah Trustee · Salt Lake City, UTN563UWAmerican Airlines Inc · Fort Worth, TXN564ASBank Of Utah Trustee · Salt Lake City, UTN564JBJetblue Airways Corp · Long Island City, NYN564LATagua Owner Trust · Wilmington, DEN565ASAlaska Airlines Inc · Seattle, WAN565JBBank Of Utah Trustee · Salt Lake City, UTN566ASAlaska Airlines Inc · Seattle, WAN566JBJetblue Airways Corp · Long Island City, NYN566LAJilguero Owner Trust · Wilmington, DEN567AVBank Of Utah Trustee · Salt Lake City, UTN567UWAmerican Airlines Inc · Fort Worth, TXN568ASAlaska Airlines Inc · Seattle, WAN568JBJetblue Airways Corp · Long Island City, NYN568LATagua Owner Trust · Wilmington, DEN568UWAmerican Airlines Inc · Fort Worth, TXN569ASAlaska Airlines Inc · Seatac, WAN569AZAmazon.Com Services LLC · Seattle, WAN569CAAc Spe 11 LLC · Orlando, FLN569JBJetblue Airways Corp · Long Island City, NYN57016United Airlines Inc · Chicago, ILN570ASAlaska Airlines Inc · Seattle, WAN570JBJetblue Airways Corp · Long Island City, NYN570LATagua Owner Trust · Wilmington, DEN570TABank Of Utah Trustee · Salt Lake City, UTN571ASUmb Bank Na Trustee · Salt Lake City, UTN571AZAmazon.Com Services LLC · Seattle, WAN571JBJetblue Airways Corp · Long Island City, NYN572LATagua Owner Trust · Wilmington, DEN572UWAmerican Airlines Inc · Fort Worth, TXN573UWAmerican Airlines Inc · Fort Worth, TXN575UWAmerican Airlines Inc · Fort Worth, TXN576UWAmerican Airlines Inc · Fort Worth, TXN577ASAlaska Airlines Inc · Seattle, WAN577NANasa Langley Research Center · Hampton, VAN577TABank Of Utah Trustee · Salt Lake City, UTN578UWAmerican Airlines Inc · Fort Worth, TXN579ASAlaska Airlines Inc · Seattle, WAN579JBBank Of Utah Trustee · Salt Lake City, UTN579UWAmerican Airlines Inc · Fort Worth, TXN580JBBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2007-19-13