OpenAirDocs.org
AD 95-26-05 R1

Registered aircraft · 1,944

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

N501GTPollux Aviation Ltd · Wasilla, AKBuilt 2005 · S/N 10768N503HVHelivision LLC · Concord, NCBuilt 2009 · S/N 12632N504HSBrennon Aviation LLC · North Fort Myers, FLBuilt 2013 · S/N 13573N505HSHolt Helicopters Inc · Uvalde, TXBuilt 2013 · S/N 13581N506CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2008 · S/N 1976N506CXEagle Helicopters LLC · Beulah, NDBuilt 2006 · S/N 11253N506HSChordwise Aviation LLC · Sedro Woolley, WABuilt 2014 · S/N 13646N506KGLone Star Land & Cattle Co · Houston, TXBuilt 2022 · S/N 14517N507HSSilvestro Santo · New Canaan, CTBuilt 2013 · S/N 13452N508CSJoey Os LLC · Darlington, PABuilt 2006 · S/N 11044N508CXAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2006 · S/N 11074N508HSBlue Chase LLC · Wilmington, DEBuilt 2013 · S/N 13462N509AZPfisters Farm Aviation LLC · Pasco, WABuilt 2020 · S/N 2606N509HSArmstrong Helicopters LLC · Laredo, TXBuilt 2013 · S/N 13464N509KMCedar Ridge Aviation LLC · Knox City, TXBuilt 1997 · S/N 0327N509MMCorrales Ag Flight LLC · Othello, WABuilt 2021 · S/N 14499N50BABranning Aviation LLC · Orofino, IDBuilt 2005 · S/N 1482N50ESSkinner Everett W IV · Stafford Springs, CTBuilt 2024 · S/N 14691N50KFBlade Capital Inc · Fort Lauderdale, FLBuilt 2009 · S/N 2035N50KRVortex Air LLC · Philpot, KYBuilt 2014 · S/N 2379N50NKAdcock Frank J · Atlanta, TXS/N 11835N510LCLimocopter LLC · Orlando, FLBuilt 2023 · S/N 2767N511LCLimocopter LLC · Orlando, FLBuilt 2023 · S/N 2771N512LEHelipl LLC · Winter Garden, FLBuilt 2024 · S/N 2774N512RTBas Part Sales LLC · Greeley, COBuilt 2006 · S/N 11465N513LAN318he LLC · Bulverde, TXBuilt 2015 · S/N 13789N513TLN468ha Inc · Middletown, DEBuilt 2008 · S/N 12391N514CHWehrli Mark A · Missouri Valley, IABuilt 1996 · S/N 0286N514SCSundance Aero LLC · Mertzon, TXBuilt 2012 · S/N 13381N516JPFranjojo Airways LLC · Farmingdale, NYBuilt 2001 · S/N 1044N516MJSeaton Flying Services Inc · Kileen, TXBuilt 2006 · S/N 1583N516RJRomeo Juliet LLC · Anaconda, MTBuilt 2016 · S/N 13989N517KTAir-One Helicopters LLC · Lincoln Park, MIBuilt 2016 · S/N 13985N518JGloc Aviation LLC · Afton, OKBuilt 2009 · S/N 12469N518SJWoodward Aviation LLC · Alpine, TXBuilt 2006 · S/N 11466N519MRSkyway I LLC · Naples, FLBuilt 2002 · S/N 1267N521GHAirborne Helicopters LLC · Hendrum, MNS/N 11304N521JVCardinal Enterprise LLC · Jackson, WYBuilt 2023 · S/N 14617N521LSGlobal Aerials Inc · Pembroke Pines, FLBuilt 2015 · S/N 13907N522CCGodspeed Leasing LLC · Fairbanks, AKS/N 10911N522TMHec Aviation LLC · Wilmington, DEBuilt 2009 · S/N 12842N523CTN523ct LLC · Douglasville, GABuilt 2010 · S/N 13078N524HGRhc1 LLC · Myrtle Beach, SCBuilt 2018 · S/N 14231N524HRLoureiro David · Granbury, TXS/N 12144N525MDHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2006 · S/N 11510N526TRYankee Helicopters LLC · Plainville, CTBuilt 2005 · S/N 10922N527VBPipping Construction LLC · Rosendale, WIBuilt 2015 · S/N 13803N52BGJax Transport LLC · Amarillo, TXBuilt 2015 · S/N 13772N530GGSmith Jason · Calliham, TXBuilt 2013 · S/N 13430N531ATR44 Leasing LLC · Anchorage, AKBuilt 2016 · S/N 14025
Back to AD 95-26-05 R1