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.

N277LCN277lc LLC · Fairbanks, AKBuilt 2021 · S/N 2667N277MCSidhu Hs · Anaheim Hills, CABuilt 2004 · S/N 10277N277PDControlthings LLC · Hurricane, UTBuilt 2004 · S/N 10265N277RKD O Aviation LLC · Wilmington, DES/N 13630N278KERotor Technologies Inc · Nashua, NHBuilt 2006 · S/N 11178N279HLInternational Air Services Inc Trustee · Carson City, NVS/N 11148N27BSBlackhawk 787 LLC · Columbus, OHBuilt 2016 · S/N 14027N2812DCompass Aviation Inc · Shelby, NCBuilt 2004 · S/N 10397N283TYSoleil Helicopters LLC · Tucson, AZBuilt 2016 · S/N 13944N284SWMuzio Micah · Beaverton, ORBuilt 2007 · S/N 11758N285RGMf Helicopters LLC · East Troy, WIBuilt 2006 · S/N 11323N286JAMungo Air LLC · Saint Louis, MOBuilt 2007 · S/N 11705N286LHSolace Aviation LLC · Atglen, PABuilt 2024 · S/N 2786N287LHJft Re Development LLC · Bentonville, ARBuilt 2024 · S/N 2787N288LExecutive Helicopters Inc · Myrtle Beach, SCS/N 0930N289LASky Venture I Inc · Virginia Beach, VABuilt 2016 · S/N 13920N28HHSmith Helicopters Inc · Cotulla, TXBuilt 2008 · S/N 12414N28PLDragonfly Aviation LLC · Mirando City, TXS/N 10535N28TMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1402N28WFLift Air LLC · Shortsville, NYBuilt 2010 · S/N 13046N293GMGeco Inc · Wilmington, DEBuilt 2008 · S/N 12261N293JSGeco Inc · Wilmington, DES/N 12466N294PJJones Kelly W · Winchester, OHBuilt 2010 · S/N 12659N295CPRobinson Helicopter Co · Torrance, CAS/N 15030N296VAVictor Aviation Service Inc · Palo Alto, CAS/N 13332N298DCVadnais Kenneth · Santa Barbara, CABuilt 2016 · S/N 13936N299HEHeli 44 LLC · Freeland, MDBuilt 1999 · S/N 0618N29KYBlack Ops Aviation LLC · Moorhead, IABuilt 2007 · S/N 1778N29VMDragonfly Aviation LLC · Laredo, TXS/N 0368N29WNSpitzer Helicopter LLC · Woodland Hills, CABuilt 2000 · S/N 0934N300MKAgricultural Tours LLC · Kahuku, HIS/N 1151N300UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2016 · S/N 13964N300WZNicholas Christopher · Williamsville, NYBuilt 2007 · S/N 11622N3010XHelifun LLC · Austin, TXBuilt 2007 · S/N 11685N3014B-Line Air LLC · Malcom, IABuilt 2008 · S/N 1961N3015GParatus Air Inc · Auburn, INBuilt 2007 · S/N 11542N3017PDragonfly Aviation LLC · Mirando City, TXBuilt 2007 · S/N 1820N3020TRegional Helicopters LLC · Anchorage, AKBuilt 2007 · S/N 11778N3022WNorth Summit Aviation LLC · Middletown, DEBuilt 2007 · S/N 11645N3026LBcmc LLC · Kalispell, MTBuilt 2007 · S/N 11798N3027PRobinson Helicopter Co · Torrance, CABuilt 2006 · S/N 11294N3027WS2 Helicopter Services LLC · Albany, TXBuilt 2007 · S/N 11660N3039FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2007 · S/N 1733N3040PCedar Ridge Aviation LLC · Knox City, TXBuilt 2007 · S/N 1802N304HGGeorgia Aviation Authority · Eastman, GABuilt 2013 · S/N 2337N3055SWcm Ventures LLC · Hondo, TXBuilt 2007 · S/N 1745N3055YExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2007 · S/N 11861N3056FEagle Eye Helicopters LLC · Texarkana, TXBuilt 2007 · S/N 11872N305JSMiller Kale M · Mountain Home, TXS/N 0763N3061ERim Rock Ranch LLC · Dover, DES/N 12061
Back to AD 95-26-05 R1