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.

N8372RNovember Alpha LLC · Dover, DEBuilt 1998 · S/N 2805N8373KTorba Jacob · Citrus Heights, CABuilt 1998 · S/N 2777N8379ZHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1985 · S/N 0491N8398AKeller William F · Burbank, CABuilt 1983 · S/N 0344N8403LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1983 · S/N 0347N8416JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1983 · S/N 0359N841MCSouth Bay Aviation Leasing LLC · Gardena, CABuilt 2014 · S/N 4653N842HSOho Cattle Company Inc · Gardnerville, NVS/N 0953N842SHSilver Star Helicopters LLC · El Campo, TXBuilt 2005 · S/N 3819N842SVPylon Aviation Services LLC · Chandler, AZBuilt 1983 · S/N 0366N8439MSteel Supply Co · Rolling Meadows, ILS/N 0371N845SHBuell Travis Wayne · Harper, TXBuilt 2005 · S/N 3825N84645In The Grey Aviation LLC · Seadrift, TXS/N 0380N8485LLethenstrom Mckenzie P · Anchorage, AKBuilt 1993 · S/N 2349N8490DLittle Big Horn Co · Prescott, AZBuilt 1984 · S/N 0403N8491AAarow Aircraft Leasing LLC · Dallas, TXBuilt 1984 · S/N 0404N8499BJackson Paul Douglas · Chesapeake, VABuilt 1980 · S/N 0058N8518WEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1984 · S/N 0425N8536YEastern Flight Services Inc · Ronkonkoma, NYBuilt 1984 · S/N 0438N853RSOlson Helicopters LLC · Corpus Christi, TXS/N 3807N8541EFlying Services Inc · Wilmington, DEBuilt 1984 · S/N 0442N8557HLloyd Davis Inc · Brackettville, TXBuilt 1985 · S/N 0460N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N8561VParatus Air Inc · Auburn, INBuilt 1985 · S/N 0484N85DHRobinson Helicopter Co · Torrance, CAS/N 4967N85MPPitman Marvin L · Harrah, OKS/N 2125N860VAVeracity Aviation LLC · Seguin, TXS/N 3089N861CHPope James D · Lewiston, IDBuilt 2000 · S/N 3156N868KFSmith Jason · Calliham, TXBuilt 2000 · S/N 3124N86EHAtlantic Coast Helicopters Ltd · Ronkonkoma, NYS/N 0585N86FHMckinney Eric S · Hamersville, OHS/N 1861N86GCSpitzer Helicopter LLC · Woodland Hills, CABuilt 2000 · S/N 3126N878MCHelicopter Leasing LLC · Henderson, NVBuilt 2005 · S/N 3782N880HCBadger Heli Corp · Wilmington, DEBuilt 1989 · S/N 1208N888DLCsc Enterprises Inc · Atlanta, GABuilt 1999 · S/N 2980N888GCBachmann Aviation LLC · Marshall, VABuilt 2005 · S/N 3857N889MHExtreme Helicopter Service LLC · Alice, TXBuilt 2001 · S/N 3160N88RDLafayette Flying Service LLC · Lafayette, LABuilt 1992 · S/N 2214N8970CMcdonald Todd P · Fairbanks, AKBuilt 2001 · S/N 3225MN8ZKCalifornia Aviation Services Inc · Riverside, CAS/N 0964N9015VAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 0011N9017ZHelicopteracademy.Com LLC · Rebhoboth Beach, DES/N 0017N901SLLange Helicopters Inc · San Angelo, TXBuilt 2001 · S/N 3174N90249Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0039N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089N903KCHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1640N90450Air & Sea Leasing Inc · Cahokia, ILBuilt 1981 · S/N 0120N9053USmart Tim · Spurger, TXBuilt 1987 · S/N 0658N9059QStevens Donald F · Canton, GABuilt 1981 · S/N 0143
Back to AD 88-26-01 R2