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.

N40374Solo Exteriors Co LLC · Seminole, TXBuilt 1991 · S/N 1668N4037GN4037g LLC · Lecanto, FLBuilt 2021 · S/N 4861N4038MAlyeska Helicopters LLC · Girdwood, AKBuilt 1990 · S/N 1571MN40398Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1590N403BCSmith Kenneth W · Marble Falls, ARBuilt 1990 · S/N 1539N403CPGreenblatt Steven · Macon, GABuilt 2004 · S/N 3607N403LLTech Heli LLC · Fort Lauderdale, FLS/N 4054N4041SDuplantis Nolan W II · Saint Martinville, LABuilt 1990 · S/N 1584N4044DParker Helicopter LLC · Watsonville, CABuilt 1990 · S/N 1619N4046AN7047x-R22 LLC · Wilmington, DEBuilt 1991 · S/N 1676N4047NSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2019 · S/N 4808N40506Dingler Larry G · Langtry, TXS/N 1753N4050GSpellbound Inc · White Bear Lake, MNBuilt 1991 · S/N 1776N4056BTesar Thomas J · Williamsport, TNBuilt 2022 · S/N 4866N4056MBarfield Anthur F · Fairborn, OHBuilt 1991 · S/N 1793N4058CHolt Tommy · Big Lake, TXBuilt 2021 · S/N 4860N4059MTcwh Inc · Hachita, NMBuilt 2022 · S/N 4867N405CMHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3096N4069XRegistered aircraftBuilt 1991 · S/N 1859N4072ZEsparza Phillip G · Cresson, TXBuilt 1991 · S/N 1884N4074THillsboro Aero Academy LLC · Hillsboro, ORBuilt 1991 · S/N 1787N4076HSummerskyz Inc · Saint Joseph, ILBuilt 1991 · S/N 1799N4078PHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1806N4081EOrlando Aircraft Sales LLC · Orlando, FLBuilt 1991 · S/N 1916N4082JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1794N4084TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1863N40YRHelicopter Services LLC · Cheyenne, WYBuilt 2019 · S/N 4797N410TTWerhan Alan · Rockford, WAS/N 0007N412TLDelta Leasing Inc DBA · Chandler, AZBuilt 2015 · S/N 4689N41338Andrews Limited LLC · Flint, MIBuilt 2008 · S/N 4356N4138GUtah State University · Logan, UTBuilt 2008 · S/N 4275N41395Vera Aviation LLC · Mountain Home, IDBuilt 2008 · S/N 4379N4148UFlightline Helicopters Inc · Cave Creek, AZBuilt 2008 · S/N 4290N416SHLa Calosa Ranch LLC · Falfurrias, TXBuilt 2008 · S/N 4372N4170MMn Helicopters Inc · Minneapolis, MNBuilt 2008 · S/N 4328N4171JAlyeska Helicopters LLC · Girdwood, AKBuilt 2008 · S/N 4392N417LSUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1994 · S/N 2436N418AAAltitude & Anchor LLC · Kalispell, MTS/N 0582N41WBEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 2034N421HKHotel Kilo Holdings LLC · Laguna Beach, CAS/N 4273N422MHHood Helicopters LLC · Wilmington, DEBuilt 2003 · S/N 3418N424RHRegistration Pending · Ogdensburg, WIRegistration pendingBuilt 1996 · S/N 2648N424SFJets To Helis LLC DBA · Chandler, AZBuilt 2015 · S/N 4688N42WCN42wc LLC · Rehoboth Beach, DEBuilt 1990 · S/N 1531MN43266Sky High Helicopters LLC · Camarillo, CABuilt 1990 · S/N 1268N432LELeading Edge Flight Academy LLC · Bend, ORBuilt 2006 · S/N 4032N434DDUtah State University · Logan, UTBuilt 2001 · S/N 3182N436SKTds Property Holdings LLC · Gilmer, TXBuilt 1999 · S/N 2954N4379WSouth Florida Helicopters Inc · Indiantown, FLS/N 0612N437EMFour Brothers Property Management LLC · Redway, CABuilt 2004 · S/N 3754
Back to AD 88-26-01 R2