Registered aircraft · 1,086

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

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:2016-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:2016-25-13') ORDER BY n_number

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:2016-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:2016-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:2016-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:2016-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.

N631SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2004 · S/N 3891 N63MCMissouri Department Of Conservation · Jefferson City, MOBuilt 2020 · S/N 8786 N63RCKootenai Business Properties LLC · Post Falls, IDBuilt 2019 · S/N 8760 N63RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7974 N63WLCorpat Inc · Missoula, MTBuilt 2023 · S/N 21201 N640SFOsf Aviation LLC · Peoria, ILBuilt 2026 · S/N 21452 N64RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 8346 N650HPKansas Highway Patrol · Topeka, KSBuilt 2024 · S/N 9397 N651CDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8868 N65RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 8353 N661AEAir Evac Ems Inc · O Fallon, MOBuilt 2018 · S/N 8571 N661GKKip Construction Services Inc · Santa Clarita, CABuilt 2025 · S/N 9654 N662AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8192 N664BCFlow Line Transportation LLC · Dallas, TXBuilt 1998 · S/N 760492 N667ALSouth America Tactical & Airborne Consulting Corp · Wilmington, DES/N 8142 N670HPKansas Highway Patrol · Topeka, KSBuilt 2024 · S/N 9483 N670TTerrible Herbst Inc · Las Vegas, NVBuilt 2021 · S/N 8985 N671CFIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2024 · S/N 21279 N672CFIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2024 · S/N 21288 N674TXTexas Department Of Public Safety · Austin, TXBuilt 2023 · S/N 9306 N6798Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8934 N67RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 9286 N681ASRba LLC · Kimberly, IDBuilt 2001 · S/N 3328 N683MNArizona Law Enforcement Air Support · Sierra Vista, AZBuilt 2014 · S/N 8020 N684JBFl Jet LLC · Fort Myers, FLBuilt 2022 · S/N 9175 N68RXReach Air Medical Services LLC · Mcclellan, CABuilt 2018 · S/N 8483 N694BBO307 LLC · Surprise, AZS/N 4005 N695HSMocha LLC · Tucson, AZBuilt 2016 · S/N 20047 N6968ATafy Consulting · Bristow, VABuilt 2013 · S/N 7530 N6974ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7459 N6977ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7463 N6981ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7472 N6987ATafy Consulting · Bristow, VABuilt 2014 · S/N 7834 N699GCZuni LLC · Kirkland, WABuilt 2014 · S/N 7896 N69XVQuantum Leasing LLC · Scottsdale, AZBuilt 2022 · S/N 9307 N6CKYoungquist Aviation LLC · Fort Myers, FLBuilt 2025 · S/N 21436 N6MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2019 · S/N 7055 N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749 N700PECentaurus Flight LLC · Ojai, CABuilt 2017 · S/N 8406 N702LFLonian Raven LLC · Wilmington, DEBuilt 2018 · S/N 20210 N703ACAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7710 N703WPCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 8362 N704RHValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 8467 N704WPCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 8369 N707DSCas LLC · Longboat Key, FLBuilt 1997 · S/N 760471 N708PDEast Bay Regional Park District · Livermore, CABuilt 2008 · S/N 4390 N709PPhi Health LLC · Tempe, AZBuilt 2008 · S/N 760716 N710FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2019 · S/N 8702 N717CCHillsborough County Sheriffs Office · Tampa, FLBuilt 2026 · S/N 9900 N717CDHillsborough County Sheriffs Office · Tampa, FLBuilt 2018 · S/N 8505

Back to AD 2016-25-13