AD 2025-06-13
Registered aircraft · 139
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:2025-06-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:2025-06-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:2025-06-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:2025-06-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.
N815AMUmb Bank Na Trustee · Salt Lake City, UTN820ALAmerican Airlines Inc · Fort Worth, TXN821ANAmerican Airlines Inc · Fort Worth, TXN822ANAmerican Airlines Inc · Fort Worth, TXN823ANAmerican Airlines Inc · Fort Worth, TXN824ANAmerican Airlines Inc · Fort Worth, TXN825AAAmerican Airlines Inc · Fort Worth, TXN826ANAmerican Airlines Inc · Fort Worth, TXN827ANAmerican Airlines Inc · Fort Worth, TXN828AAAmerican Airlines Inc · Fort Worth, TXN829ANAmerican Airlines Inc · Fort Worth, TXN830ANAmerican Airlines Inc · Fort Worth, TXN831AAAmerican Airlines Inc · Fort Worth, TXN832AAAmerican Airlines Inc · Fort Worth, TXN833AAAmerican Airlines Inc · Fort Worth, TXN834AAAmerican Airlines Inc · Fort Worth, TXN835ANWilmington Trust Co Trustee · Wilmington, DEN836AAWilmington Trust Co Trustee · Wilmington, DEN837ANWilmington Trust Co Trustee · Wilmington, DEN838AAWilmington Trust Co Trustee · Wilmington, DEN839AAWilmington Trust Co Trustee · Wilmington, DEN840ANAmerican Airlines Inc · Fort Worth, TXN841ANAmerican Airlines Inc · Fort Worth, TXN842AAWilmington Trust Company Trustee · Wilmington, DEN843ANWilmington Trust Co Owner Trustee · Wilmington, DEN844MCWilmington Trust Company Trustee · Wilmington, DEN845MDWilmington Trust Co Trustee · Wilmington, DEN846ANWilmington Trust Co Trustee · Wilmington, DEN847MFAmerican Airlines Inc · Fort Worth, TXN848ANAmerican Airlines Inc · Fort Worth, TXN849ANAmerican Airlines Inc · Fort Worth, TXN850ANAmerican Airlines Inc · Fort Worth, TXN851MKAmerican Airlines Inc · Fort Worth, TXN852MLAmerican Airlines Inc · Fort Worth, TXN853MMBoeing Co · Renton, WAN879CJBoeing Co · Renton, WAN879CMBoeing Co · Renton, WAN879PKBoeing Co · Renton, WAN91007United Airlines Inc · Chicago, IL
Back to AD 2025-06-13