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.

N222GHConcho Aviation LLC · Sterling City, TXS/N 0714N222JAJeff Abrams LLC · Ocala, FLBuilt 2000 · S/N 3062N223HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1990 · S/N 1600N223KCNovember Alpha LLC · Dover, DEBuilt 2003 · S/N 3435N223MGBuffalo Sales & Leasing LLC · Missoula, MTBuilt 2000 · S/N 3125N223VAVeracity Aviation LLC · Seguin, TXBuilt 2025 · S/N 4925N2242PDeese Derick D E · Port Angeles, WABuilt 1985 · S/N 0493N224FLFingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 1511N224HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1991 · S/N 1719N224LJJets To Helis LLC DBA · Chandler, AZBuilt 2022 · S/N 4872N224MGBuell Travis · Harper, TXBuilt 2001 · S/N 3276N224VRConcho Aviation LLC · Sterling City, TXBuilt 2000 · S/N 3038N225FTSerrino Sam · Youngstown, OHBuilt 2001 · S/N 3231N225KYAtb Inc Trustee · Wilmington, DEBuilt 2004 · S/N 3691N225WM225wm Aircraft Leasing LLC · Spanish Fork, UTBuilt 2007 · S/N 4109N22640Advanced Helicopter Concepts Inc · Frederick, MDS/N 0502N226TASale Reported · Sellerburg, INSale reported, canceledBuilt 2005 · S/N 3904N227WM227wm Aircraft Leasing LLC · Spanish Fork, UTBuilt 2007 · S/N 4172N228SHHayden Daniel · North Pole, AKBuilt 2006 · S/N 4014N2296XGleichauf Andrew N · Beloit, WIBuilt 1985 · S/N 0516N229MBAarow Aircraft Leasing LLC · Mcminnville, ORS/N 4865N229MHBwm Holding Group Inc · Greenwich, CTS/N 1441N229WM229wm Aircraft Leasing LLC · Spanish Fork, UTBuilt 2007 · S/N 4142N22AQSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1993 · S/N 2316MN22HTTobler Hans P · Anchorage, AKS/N 1858N22JDGebo Christopher T · Hubbardston, MAS/N 0352N22JUPro-Drive Inc · Wynona, OKBuilt 1992 · S/N 2155N22RSulphur Creek Helicopters LLC · George West, TXBuilt 2005 · S/N 3925N2300HN112vg LLC · Princeton, NJBuilt 1991 · S/N 1842N2302ADutchess Community College · Poughkeepsie, NYBuilt 1991 · S/N 1903N2302JGo Fly Maui LLC · Paia, HIBuilt 1946 · S/N 1946N2304WHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1991 · S/N 1961N2311XGoodrich Joshua A · Webster, MNBuilt 1991 · S/N 1972N2312NSale Reported · Maize, KSSale reportedBuilt 1991 · S/N 2018N231TMCasablanca Helicopter LLC · Rehoboth Beach, DEBuilt 1993 · S/N 2317MN2320FEverett Thomas W · Cumming, GABuilt 1991 · S/N 1845N2326WSahli Theodore · Costa Mesa, CAS/N 2109N2327COlson Helicopters LLC · Corpus Christi, TXBuilt 1991 · S/N 2020N2331XHelistream Inc · Kalispell, MTBuilt 1992 · S/N 2145N2334KSixty Six Holdings LLC · King, NCS/N 2159N2334XEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1992 · S/N 2149N2338YCm3 LLC · North Las Vegas, NVS/N 2152N2340DWojtowicz Tomasz · Bronx, NYBuilt 1992 · S/N 2174N2342UAdvanced Helicopter Concepts Inc · Frederick, MDBuilt 1992 · S/N 2181N2345PSpitzer Helicopter LLC · Woodland Hills, CABuilt 1991 · S/N 1991N23490Lg Mcdonald Enterprises Inc · Rose Bud, ARBuilt 1992 · S/N 2223N234RWAnthelion Helicopters · Long Beach, CABuilt 1999 · S/N 2943N2354TDiaz Mark A DBA · Madera, CAS/N 2247N2356MN112vg LLC · Princeton, NJBuilt 1993 · S/N 2262N2356YCulver Lane M · Laceys Spring, ALBuilt 1993 · S/N 2321
Back to AD 88-26-01 R2