Registered aircraft · 1,939

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:95-26-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-05-R1') 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:95-26-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-05-R1')
  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:95-26-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-05-R1')
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.

N247DBPope Jim · Lewiston, IDBuilt 2003 · S/N 10086 N247LPLonestar Air IV LLC · Dallas, TXBuilt 2011 · S/N 13205 N248DBAce Helicopters LLC · Colfax, WIBuilt 1996 · S/N 0248 N248DLApple Hill Associates LLC · Dover, DEBuilt 2018 · S/N 14226 N249DLGibsons Gas Inc · Holland, NYS/N 0382 N24DFCape Copters LLC · Scott City, MOS/N 14246 N24FTRocinante Air LLC · Weslaco, TXBuilt 2006 · S/N 11153 N24RTHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2018 · S/N 30044 N250THUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 30038 N251JSSafe Space Aviation LLC · Kenosha, WIBuilt 2006 · S/N 11301 N251LFTja Aviation LLC · Miami, FLBuilt 2007 · S/N 11847 N251TLTlh-1 LLC · Anchorage, AKBuilt 2015 · S/N 13818 N2522PPfisters Helicopters Inc · Pasco, WABuilt 2014 · S/N 2352 N255LCTrayer Jared T · Rollinsford, NHBuilt 2019 · S/N 2587 N255PKTexas Specialty Hunts Inc · San Angelo, TXBuilt 2025 · S/N 14925 N255VSVertical Solutions LLC · Valdez, AKBuilt 2014 · S/N 13685 N257MTWhirly Girl LLC · Starkville, MSBuilt 2013 · S/N 13535 N258DLExtapa LLC · Wilmington, DEBuilt 2012 · S/N 2250 N258DWWasileski David · Auburn, NYBuilt 2023 · S/N 14610 N258GGGreat Northern Investment Group LLC · Anchorage, AKBuilt 2026 · S/N 14955 N25BAArkansas Valley Feathers Inc · California, MOBuilt 2010 · S/N 12976 N25PVRotors Up LLC · Houston, TXBuilt 2011 · S/N 13114 N25XW6r Aviation LLC · Aspermont, TXBuilt 2022 · S/N 14555 N25ZFHeligray LLC · Kalispell, MTBuilt 2017 · S/N 14160 N261APRotor Leasing LLC · Indianapolis, INBuilt 2024 · S/N 14804 N264APRotor Leasing LLC · Indianapolis, INBuilt 2024 · S/N 14818 N264RBAerostar International Inc · Lewes, DEBuilt 2006 · S/N 11477 N264RHNomad Aircraft Leasing And Sales LLC · Panama City Beach, FLBuilt 2017 · S/N 2479 N266PKRobinson Helicopter Co · Torrance, CAS/N 15040 N267AWExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2007 · S/N 12014 N26AYR44 White LLC · Kalispell, MTBuilt 2022 · S/N 14547 N26BXPeak Performance Helicopters LLC · Dover, DEBuilt 2023 · S/N 14659 N26EHEvans Robert · Phillips, NEBuilt 2001 · S/N 1128 N26KLLepping Kurt · Hot Springs, MTBuilt 2007 · S/N 12024 N26LALead Aviation Fl2 LLC · Osprey, FLBuilt 2008 · S/N 12591 N26UPBgt Operations LLC · Equality, ILBuilt 2018 · S/N 14219 N2717YAdvanced Heli Services Corp Trustee · Wilmington, DES/N 12121 N271FKPlane Fun Inc Tr Trustee · Snellville, GABuilt 2008 · S/N 12394 N272DWBb Wetlands LLC · Winter Haven, FLBuilt 2008 · S/N 12107 N272JWGlobal Aerials Inc · Pembroke Pines, FLBuilt 2015 · S/N 13769 N272MGAircraft Evolution LLC · Miami, FLBuilt 2016 · S/N 2434 N272SEFoley Aviation LLC · Evans City, PABuilt 2016 · S/N 13947 N273BBBrenthel Industries LLC · Helena, MTBuilt 2025 · S/N 14920 N273CAN273ca LLC · Tulsa, OKBuilt 2012 · S/N 13403 N273SState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 2018 · S/N 14283 N274CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2005 · S/N 10649 N275LESky Photoshop LLC · Winter Garden, FLBuilt 2026 · S/N 2858 N277CHHatz Aviation LLC · Pompano Beach, FLBuilt 2006 · S/N 11319 N277JCRobinson Helicopter Co · Torrance, CAS/N 15048 N277KTMaxair Helicopters LLC · Kissimmee, FLS/N 2277

Back to AD 95-26-05 R1