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.
N24555Wilmington Trust Co Trustee · Wilmington, DEN24568Wilmington Trust Co Trustee · Wilmington, DEN24573United Airlines Inc · Chicago, ILN300NYAmerican Airlines Inc · Fort Worth, TXN301FRBank Of Utah Trustee · Salt Lake City, UTN301NYAmerican Airlines Inc · Fort Worth, TXN302NYAmerican Airlines Inc · Fort Worth, TXN303FRBank Of Utah Trustee · Salt Lake City, UTN303NYAmerican Airlines Inc · Fort Worth, TXN304FRBank Of Utah Trustee · Salt Lake City, UTN304NYAmerican Airlines Inc · Fort Worth, TXN305NYAmerican Airlines Inc · Fort Worth, TXN306XRAmerican Airlines Inc · Fort Worth, TXN307FRBank Of Utah Na Trustee · Salt Lake City, UTN307NYAmerican Airlines Inc · Fort Worth, TXN308FRBank Of Utah Trustee · Salt Lake City, UTN308NYAmerican Airlines Inc · Fort Worth, TXN309FRBank Of Utah Trustee · Salt Lake City, UTN310FRBank Of Utah Trustee · Salt Lake City, UTN310NYRegistered aircraftN-number assigned (import), not yet registeredN311FRBank Of Utah Trustee · Salt Lake City, UTN311NYAmerican Airlines Inc · Fort Worth, TXN312FRBank Of Utah Trustee · Salt Lake City, UTN313FRBank Of Utah Trustee · Salt Lake City, UTN315XRAmerican Airlines Inc · Fort Worth, TXN316FRBank Of Utah Trustee · Salt Lake City, UTN317FRWells Fargo Trust Co Na Trustee · Columbia, MDN318FRWells Fargo Trust Co Na Trustee · Columbia, MDN323FRWilmington Trust Co Trustee · Wilmington, DEN324FRWilmington Trust Co Trustee · Wilmington, DEN326FRUmb Bank Na Trustee · Salt Lake City, UTN328FRBank Of Utah Trustee · Salt Lake City, UTN329FRBank Of Utah Trustee · Salt Lake City, UTN330FRBank Of Utah Trustee · Salt Lake City, UTN331FRUmb Bank Na Trustee · Salt Lake City, UTN332FRWells Fargo Trust Co Na Trustee · Columbia, MDN334FRBank Of Utah Trustee · Salt Lake City, UTN335FRWells Fargo Trust Co Na Trustee · Columbia, MDN336FRUmb Bank Na Trustee · Salt Lake City, UTN337FRWells Fargo Trust Co Na Trustee · Columbia, MDN338FRUmb Bank Na Trustee · Salt Lake City, UTN339FRBank Of Utah Trustee · Salt Lake City, UTN341FRWells Fargo Trust Co Na Trustee · Columbia, MDN342FRBank Of Utah Trustee · Salt Lake City, UTN343FRWells Fargo Trust Co Na Trustee · Columbia, MDN344FRBank Of Utah Trustee · Salt Lake City, UTN34535Wilmington Trust Company Trustee · Wilmington, DEN34547United Airlines Inc · Chicago, ILN34551United Airlines Inc · Chicago, ILN34562United Airlines Inc · Chicago, IL
Back to AD 2026-15-13