AD 2025-25-13
Registered aircraft · 199
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-25-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-25-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-25-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-25-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.
N706SHNaval Air Systems Command · Patuxent River, MDN709CGBristow LLC · Lake Charles, LAN712MCMercy Flight Central Holding LLC · Canandaigua, NYN715RTBristow LLC · Lake Charles, LAN726LFBank Of Utah Trustee · Salt Lake City, UTN72SLMhm Logistics LLC · Wilmington, DEN756LFBank Of Utah Trustee · Salt Lake City, UTN776LFKeybank Na · Superior, CON786LFKeybank Na · Superior, CON78LFMercy Health Life Flight Network LLC · Toledo, OHN794DMRed River Aircraft Leasing LLC · Anchorage, AKN802SMBristow LLC · Lake Charles, LAN808STNaval Air Systems Command · Patuxent River, MDN80PJBank Of Utah Trustee · Salt Lake City, UTN810MCMercy Flight Central Holding LLC · Canandaigua, NYN810STNaval Air Systems Command · Patuxent River, MDN811STNaval Air Systems Command · Patuxent River, MDN822MMBristow LLC · Lake Charles, LAN823STNaval Air Systems Command · Patuxent River, MDN824STLeonardo Helicopters US Corp · Philadelphia, PAN826STNaval Air Systems Command · Patuxent River, MDN828STNaval Air Systems Command · Patuxent River, MDN829STNaval Air Systems Command · Patuxent River, MDN830STNaval Air Systems Command · Patuxent River, MDN831STNaval Air Systems Command · Patuxent River, MDN832STNaval Air Systems Command · Patuxent River, MDN835STNaval Air Systems Command · Patuxent River, MDN836STNaval Air Systems Command · Patuxent River, MDN837STNaval Air Systems Command · Patuxent River, MDN839STNaval Air Systems Command · Patuxent River, MDN843STNaval Air Systems Command · Patuxent River, MDN845STNaval Air Systems Command · Patuxent River, MDN846STNaval Air Systems Command · Patuxent River, MDN847STNaval Air Systems Command · Patuxent River, MDN848STNaval Air Systems Command · Patuxent River, MDN849STNaval Air Systems Command · Patuxent River, MDN852STNaval Air Systems Command · Patuxent River, MDN853STNaval Air Systems Command · Patuxent River, MDN854STNaval Air Systems Command · Patuxent River, MDN859STNaval Air Systems Command · Patuxent River, MDN860STNaval Air Systems Command · Patuxent River, MDN861STNaval Air Systems Command · Patuxent River, MDN863STNaval Air Systems Command · Patuxent River, MDN869STNaval Air Systems Command · Patuxent River, MDN882STNaval Air Systems Command · Patuxent River, MDN883STNaval Air Systems Command · Patuxent River, MDN902JANaval Air Systems Command · Patuxent River, MDN903JANaval Air Systems Command · Patuxent River, MDN903STNaval Air Systems Command · Patuxent River, MDN906JANaval Air Systems Command · Patuxent River, MD
Back to AD 2025-25-13