AD 2026-15-13
Registered aircraft · 682
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:2026-15-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:2026-15-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:2026-15-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:2026-15-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.
N2038JJetblue Airways Corp · Long Island City, NYN2039JJetblue Airways Corp · Long Island City, NYN2043JUmb Bank N.A. Trustee · Salt Lake City, UTN2044JUmb Bank Na Trustee · Salt Lake City, UTN2047JUmb Bank Na Trustee · Salt Lake City, UTN2048JUmb Bank Trustee · Salt Lake City, UTN204HAHawaiian Airlines Inc · Seattle, WAN2059JJetblue Airways Corp · Long Island City, NYN205HAAlaska Airlines Inc · Seatac, WAN2060JJetblue Airways Corp · Long Island City, NYN2084JUmb Bank Na Trustee · Salt Lake City, UTN2086JUmb Bank Na Trustee · Salt Lake City, UTN208HAAlaska Airlines Inc · Seattle, WAN209HAWilmington Trust Co Trustee · Wilmington, DEN2102JJetblue Airways Corp · Long Island City, NYN2105JJetblue Airways Corp · Long Island City, NYN212HAAlaska Airlines Inc · Seatac, WAN213HAUmb Bank Na Trustee · Salt Lake City, UTN2142JJetblue Airways Corp · Long Island City, NYN214HAHawaiian Airlines Inc · Seattle, WAN2151JJetblue Airways Corp · Long Island City, NYN2156JJetblue Airways Corp · Long Island City, NYN2157JJetblue Airways Corp · Long Island City, NYN215HAHawaiian Airlines Inc · Seattle, WAN2165JJetblue Airways Corp · Long Island City, NYN2169JJetblue Airways Corp · Long Island City, NYN216HAHawaiian Airlines Inc · Seattle, WAN217HAHawaiian Airlines Inc · Seattle, WAN2180JJetblue Airways Corp · Long Island City, NYN2188JJetblue Airways Corp · Long Island City, NYN218HAHawaiian Airlines Inc · Seattle, WAN2193JJetblue Airways Corp · Long Island City, NYN2199JJetblue Airways Corp · Long Island City, NYN2205JJetblue Airways Corp · Long Island City, NYN220HAHawaiian Airlines Inc · Seatac, WAN223HAHawaiian Airlines Inc · Seattle, WAN226HAHawaiian Airlines Inc · Seattle, WAN227HAWilmington Trust Co Trustee · Wilmington, DEN228HAHawaiian Airlines Inc · Seattle, WAN230HAWilmington Trust Co Trustee · Wilmington, DEN24505United Airlines Inc · Chicago, ILN24508United Airlines Inc · Chicago, ILN24510United Airlines Inc · Chicago, ILN24513United Airlines Inc · Chicago, ILN24514United Airlines Inc · Chicago, ILN24516United Airlines Inc · Chicago, ILN24519United Airlines Inc · Chicago, ILN24526United Airlines Inc · Chicago, ILN24537United Airlines Inc · Chicago, ILN24542Wilmington Trust Co Trustee · Wilmington, DE
Back to AD 2026-15-13