OpenAirDocs.org
AD 95-26-05 R1

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

N233CJCrown H Helicopter LLC · Casscoe, ARBuilt 2023 · S/N 14655N233JDSulphur Creek Helicopters LLC · Three Rivers, TXBuilt 2004 · S/N 10300N233LMWayne Four LLC · Sugar Land, TXBuilt 2023 · S/N 14684N233TRPark Industries Inc · Corona, CABuilt 2003 · S/N 10062N233WTRaven II LLC · Belgrade, MTBuilt 2023 · S/N 14647N233ZAgl Machine Co LLC · Marietta, GABuilt 2007 · S/N 11991N2345CGl Heli LLC · Hazelwood, MOBuilt 2018 · S/N 14289N234HHNebo Mtn Hellys LLC · Nephi, UTBuilt 2025 · S/N 14807N234LHHolt Helicopters Inc · Uvalde, TXBuilt 2003 · S/N 10097N234NLH B H Enterprises Inc · Wilmington, DEBuilt 2004 · S/N 10575N234SWSam Allen Aviation LLC · Fort Worth, TXBuilt 2024 · S/N 14752N234ZTDrax Enterprise LLC · Miami Beach, FLBuilt 2017 · S/N 30027N235LEOverlook Air LLC · Lexington, KYBuilt 2025 · S/N 14908N238WTSouthwest Tank And Steel Inc · Camp Verde, AZS/N 14660N239DJDj Wings Holding LLC · Greenlawn, NYBuilt 2022 · S/N 30089N23HHGo Fly Maui LLC · Paia, HIBuilt 2017 · S/N 14155N240KHBurns Shane H · Waxahachie, TXBuilt 2001 · S/N 0978N240RMPollux Aviation Ltd · Wasilla, AKBuilt 2001 · S/N 1090N240RSHappy Destiny LLC · Burnet, TXBuilt 2022 · S/N 14516N2413XAll Her Fault LLC · Fairbanks, AKBuilt 2005 · S/N 10861N241AUCompass Aviation Inc · Shelby, NCBuilt 2008 · S/N 12592N241MGNewberg Sky Spray LLC · Hector, MNBuilt 2005 · S/N 1483N241VSDjd Aero Corp · Wilmington, DEBuilt 2000 · S/N 0729N242MGHelo 1 LLC · Anchorage, AKBuilt 2006 · S/N 11134N243TJJones Helicopters LLC · Villa Rica, GABuilt 2004 · S/N 10239N2444Qualitair LLC Trustee · MichelstadtBuilt 2007 · S/N 11877N244BHHelicopter Holdings LLC · East Falmouth, MABuilt 2016 · S/N 2449N244CCThompson Helicopters LLC · Uvalde, TXS/N 0860N244CRChiponna Ranch LLC · Surprise, AZBuilt 2023 · S/N 14642N244CSAerial Expert Enterprise LLC · Plainview, MNBuilt 2012 · S/N 13374N244DKTiki Helicopters LLC · Riviera Beach, FLBuilt 2004 · S/N 10529N244GGR44 Aircraft Leasing LLC · Tampa, FLBuilt 2023 · S/N 14613N244GHJakes Air Services LLC · Holt, FLS/N 0833N244JBSpier Ronald B · Springfield, OHBuilt 1999 · S/N 0560N244KSSnodgrass Charles Kenneth · Boise, IDBuilt 2022 · S/N 30085N244MKRegistered aircraftBuilt 2001 · S/N 1017N244MMNovember Alpha LLC DBA · Dover, DES/N 10724N244PKTexas Specialty Hunts Inc · San Angelo, TXBuilt 2024 · S/N 14775N244RAMd Ag Services LLC · Sterling City, TXBuilt 2005 · S/N 10662N244RHRobinson Helicopter Co · Torrance, CABuilt 2021 · S/N 30080N244RLSouthern Maine Helicopter LLC · Sanford, MEBuilt 2013 · S/N 2333N244SLTpc Inc · Childress, TXBuilt 2004 · S/N 10493N244TBSubmissive Air Inc · Deadwood, SDBuilt 2014 · S/N 13629N244VBStephenson Timothy R · Amelia Court House, VABuilt 2011 · S/N 13209N244WAMistretta Farms LLC · Baton Rouge, LABuilt 2019 · S/N 14269N244WBUpdraft LLC · Fort Wayne, INBuilt 2006 · S/N 1651N244WDHinnant And Fulbright Ltd · Hebbronville, TXBuilt 2022 · S/N 14513N244ZC & M Gator Farm · Holden, LABuilt 2003 · S/N 10040N246GGRobinson Helicopter Co · Torrance, CAS/N 15050N246LCTop Gun Precision Ag LLC · Skidmore, TXS/N 2620
Back to AD 95-26-05 R1