OpenAirDocs.org
AD 88-26-01 R2

Registered aircraft · 816

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

N334VHFly Fly Fly LLC · Dover, DEBuilt 1992 · S/N 2177N3356DShapiro David M · Homer, AKBuilt 1994 · S/N 2461N335DPAdvanced Aviation Group LLC · Frederick, MDBuilt 1993 · S/N 2372N335VHPremier Helicopters LLC · Carson City, NVBuilt 1994 · S/N 2464N3371RRs Helicopters Inc · Winter Haven, FLS/N 3371N337HCustom Aircraft Inc · Palmer, AKBuilt 1999 · S/N 2999N338VHDevries Larry E · Pella, IABuilt 1993 · S/N 2300N341MKAlba Aviation Services Inc · Scottsdale, AZBuilt 2003 · S/N 3470N341SLMartin David V · California, KYBuilt 1993 · S/N 2299N341VHYachtphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2303MN343VHHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1993 · S/N 2313N3458Johnston Donald Trustee · Pickford, MIBuilt 2008 · S/N 4294N345LHSmoketown Helicopters LLC · Smoketown, PABuilt 1995 · S/N 2533N345UHUhi Inc · Provo, UTBuilt 2014 · S/N 4654N346VHAllen Joseph Andrew · Trumbauersville, PABuilt 1993 · S/N 2261N350VHCm3 LLC · North Las Vegas, NVS/N 2286N351JDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1997 · S/N 2707N357AHAtlantic Aviation International Inc · Lewes, DEBuilt 1987 · S/N 0711N357LHElite Aerial Photography Inc · Naples, FLBuilt 1992 · S/N 2254N3636WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1990 · S/N 1345N364MNakamura Hajime Trustee · Long Beach, CAS/N 0364N36861Registered aircraftBuilt 1986 · S/N 0584N369SRChopper Shots LLC · West Bath, MEBuilt 1989 · S/N 1017MN370FLFingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 3726N376BHHelicopteracademy.Com LLC · Rehoboth Beach, DES/N 0851N377BMQuebec Helicopter LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1691MN378UHHelicopter Academy.Com LLC · Rehoboth Beach, DES/N 0622N37NERotor Technologies Inc · Nashua, NHBuilt 1994 · S/N 2450N382ASAero Leasing · Brookings, ORBuilt 1998 · S/N 2902N388MJSundance Aero LLC · Mertzon, TXBuilt 2001 · S/N 3224N38GMNovember Alpha LLC · Dover, DEBuilt 2001 · S/N 3222N39BPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 2906N4001LRobinson Helicopter Co · Torrance, CABuilt 1990 · S/N 1331N4002KSummerskyz Inc · Urbana, ILBuilt 1990 · S/N 1390N4003GButler Donald D · Petersburg, PABuilt 1990 · S/N 1459N4010BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1418MN4011EFredericks Harry III Trustee · Woodland, CAS/N 1385N4013REquipment Plus LLC · Culpeper, VABuilt 1990 · S/N 1430N4016NRobinson Helicopter Co · Torrance, CAS/N 4960N4017LRobinson Helicopter Co · Torrance, CAS/N 4964N401DKBuford Copter Co LLC · Colorado City, TXBuilt 1988 · S/N 0929N40230Harris Dan C · Rockford, TNS/N 1470N40238Blue Ridge Community College · Weyers Cave, VAS/N 1474N4023TSky Helicopters Inc · Desoto, TXBuilt 2024 · S/N 4911N4030CAdcock Corey J · Victoria, TXBuilt 1990 · S/N 1544N4030UEagle Services Inc · Washington, MIBuilt 1990 · S/N 1545N4031WBering Pacific Ranches Ltd · Foothills AbBuilt 1990 · S/N 1540N40338Emerald City Aircraft Leasing Inc · Port Orchard, WAS/N 1556N4033TCrop Doctors LLC · Micanopy, FLS/N 1471N40353Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1574
Back to AD 88-26-01 R2