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.

N2357BSchneider Douglas P · Arlington, WABuilt 1993 · S/N 2273N2357CBoyd Gary · Pearsall, TXBuilt 1993 · S/N 2312N2359TChopco Ltd · Columbus, OHS/N 2359N236RATechnical Education Services Inc · Virginia Beach, VABuilt 1994 · S/N 2236N2376Moore Charles D · Willow, AKBuilt 1992 · S/N 2062N2378Suridutch Inc · Englewood, FLBuilt 1992 · S/N 2066N2380Atlantic Rotors LLC · Saint Inigoes, MDBuilt 1992 · S/N 2070N2385YSpeedboat Photo Helicopter LLC · Rehoboth Beach, DES/N 0538N23ELWesterfield Mark H · Johnson City, TNS/N 2363N2411FAarow Aircraft Leasing LLC · Mcminnville, ORS/N 0549N2428VEmerald City Aircraft Leasing Inc · Port Orchard, WAS/N 1677N243EHVeracity Aviation LLC · Seguin, TXS/N 3482N246TMTango Mike Aviation LLC · Seneca Falls, NYS/N 3238N251BDWheatly Andy · Hedley, TXBuilt 2006 · S/N 4045N254SRJets To Helis LLC DBA · Chandler, AZBuilt 2023 · S/N 4887N2550BSouthern Utah University · Cedar City, UTS/N 0611N255SCSouth Georgia Technical College · Americus, GABuilt 2005 · S/N 3772N256SCNovember Alpha LLC · Dover, DEBuilt 2006 · S/N 4007N2584FAdvanded Helicopter Concepts Inc · Frederick, MDBuilt 1987 · S/N 0674N2590XC B W Landscaping Construction Co Inc · Framingham, MAS/N 679MN259DWSmith Jason · Calliham, TXBuilt 2003 · S/N 3492N26003Bay Lux Ventures LLC · Tampa, FLS/N 0644N2604LE W Eaken & Co LLC · Columbiana, OHBuilt 1983 · S/N 0331N2614DRegistration Pending · Kerrville, TXRegistration pendingBuilt 1987 · S/N 0727N2620CWhalen Shenandoah · Amelia, OHBuilt 1987 · S/N 0725N26225Kilday Klayton D DBA · Dexter, ORBuilt 1989 · S/N 1138N2622MN2622m LLC · Rehoboth Beach, DEBuilt 1982 · S/N 0735MN2622TStenvers Aaron · Valley, NEBuilt 1991 · S/N 1823N2624NBoston Helicopters Inc · North Andover, MAS/N 0739N2627MN2627m LLC · Rehoboth Beach, DEBuilt 1988 · S/N 755MN2627NCartwright Josh D · Salem, MOBuilt 1988 · S/N 0756N2628ZSipes Gary C · Livingston, TXBuilt 1988 · S/N 0773N26385Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1988 · S/N 0804N2642DBurchard Farms LLC · Melber, KYBuilt 1988 · S/N 0820N26498Dodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N 0836N26602Eastern New Mexico University - Roswell · Roswell, NMBuilt 1988 · S/N 0858N26619Sides Michael E · Bartley, NEBuilt 1988 · S/N 0876N2663JN2663j LLC · Rehoboth Beach, DEBuilt 1988 · S/N 0877N266SHDirty Bird Helicopters LLC · Boerne, TXBuilt 2007 · S/N 4230N26GACrosswind Leasing LLC · Prescott, AZBuilt 2007 · S/N 4129N26VHWise Joe · Kilgore, TXBuilt 2004 · S/N 3677N26WHHall Wendell W · Cheraw, SCBuilt 1981 · S/N 0176N271SHVeracity Aviation LLC · Seguin, TXBuilt 2007 · S/N 4240N273SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4243N276SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4246N278FKKoelbl Aviation LLC · Whitesboro, TXBuilt 2003 · S/N 3417N278SHSmith Kenneth S Jr · Uvalde, TXBuilt 2007 · S/N 4224N288STRegistered aircraftBuilt 2005 · S/N 3763N28NETakeflight LLC · Spanish Fork, UTBuilt 2000 · S/N 3039N290KCTsunami Skydivers Inc · Las Vegas, NVBuilt 1990 · S/N 1301
Back to AD 88-26-01 R2