OpenAirDocs.org
AD 88-26-01 R2

Registered aircraft · 817

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.

N100WRBuehler Andrew · Eatonville, WABuilt 1981 · S/N 157N106EHKnueven Timothy P · Huntsville, ALS/N 1475N106RDMarinaphoto Helicopter LLC · Rehoboth Beach, DEBuilt 1989 · S/N 925MN107FHThree Sixteen LLC · Danbury, TXBuilt 1997 · S/N 2745N1115FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1997 · S/N 2765N1118NJets To Helis LLC DBA · Chandler, AZBuilt 1991 · S/N 1780N111AHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2004 · S/N 3531N111KTHolt Helicopters Inc · Uvalde, TXBuilt 2001 · S/N 3273N111PBRegistered aircraftBuilt 1997 · S/N 2705N111UHAlba Aviation Services Inc · Scottsdale, AZBuilt 2004 · S/N 3750N111YZBuell Travis W · Harper, TXBuilt 1990 · S/N 1622N11364Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 2508N113VGN113vg LLC · Princeton, NJBuilt 1993 · S/N 2391N114VGN22vg LLC · Milford, NJS/N 2351N115DDDed Aviation LLC · Saint Louis, MOS/N 3494N115LELeading Edge Aviation Inc · Bend, ORBuilt 2007 · S/N 4115N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547N121SESpitzer Helicopter LLC · Woodland Hills, CABuilt 1997 · S/N 2747N122AKBarker Paul II · Rainbow City, ALBuilt 1991 · S/N 2028N122PLSlip Stream Aviation Inc · Fort Mill, SCBuilt 2001 · S/N 3265N122RFDaniels Ronald C · Poughkeepsie, NYS/N 3397N122YBRobinson Helicopter Co · Torrance, CABuilt 2002 · S/N 3309N12396Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0646N12424Helicopter Academy Com LLC · Rehoboth Beach, DES/N 0130N12475Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0453N12536Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0786N12615Helicopter Academy.Com LLC · Rehoboth Beach, DES/N 1205N12699Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0063N126NSHelileasing Inc · Las Vegas, NVBuilt 1989 · S/N 1153N126VAHuber Airpark Civic Club LLC · Seguin, TXBuilt 1996 · S/N 2581N12715Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0103N127SHWaverly R22 LLC · Oklahoma City, OKBuilt 2007 · S/N 4116N12857Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0449N12896Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0237N129YEBuell Travis W · Harper, TXBuilt 2002 · S/N 3334N12BVRoberts William O · Lexington, VAS/N 0241N132MHUtah State University · Logan, UTBuilt 2004 · S/N 3648N139AGSchool Board Of Seminole Co Florida · Sanford, FLBuilt 1981 · S/N 0131N13GHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1984 · S/N 0388N13HRSouth Florida Helicopters Inc · Indiantown, FLS/N 0492N142VABuffalo Sales And Leasing LLC · Missoula, MTBuilt 2005 · S/N 3771N143SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4132N147AVRegistered aircraftN-number assigned, not yet registeredS/N 1262N149TGGrandview Aerial Operations LLC · Alexander, NCS/N 3280N14HTP3 Aviation Services LLC · Wilmington, DES/N 4040N150JHKroontje David M · Bellingham, WAS/N 2364N150LELeading Edge Flight Academy LLC · Bend, ORBuilt 2000 · S/N 3150N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753N153SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4147N154SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4151
Back to AD 88-26-01 R2