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.

N653SHGivens Tyler · La Vernia, TXBuilt 2003 · S/N 3504N654SHHutcherson David R · Gretna, VABuilt 2003 · S/N 3505N65SAAkin & Son Inc · Texarkana, TXBuilt 1988 · S/N 0907N6685SRegistered aircraftN-number assigned (import), not yet registeredS/N 4773N66AWSg Aviation Inc · Clearwater, FLBuilt 2001 · S/N 3200N67010Robinson Helicopter Company Inc · Torrance, CABuilt 1975 · S/N 0001N6703SSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3621N674PBEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1997 · S/N 2687N674RGTech Heli LLC · Fort Lauderdale, FLBuilt 1998 · S/N 2885N680SHSouthern Utah University · Cedar City, UTBuilt 2000 · S/N 3153N683SHSouthern Utah University · Cedar City, UTBuilt 2005 · S/N 3905N689MBoatphoto Helicopter LLC · Rebhoboth, DES/N 689MN694DCSweet Dixie Aviation LLC · Reddick, FLBuilt 2004 · S/N 3573N695APBuell Travis · Harper, TXBuilt 2001 · S/N 3308N6KTHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2000 · S/N 3016N7007XConcho Aviation LLC · Sterling City, TXBuilt 1998 · S/N 2785N700CXEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3162N7019EShimek Mark S · Port Lavaca, TXBuilt 1980 · S/N 0068N70222Aqualion Holdings Inc · Pasadena, MDBuilt 2024 · S/N 4897N7024USpitzer Helicopter LLC · Woodland Hills, CABuilt 1998 · S/N 2854N7026UWilliams Mike C · Sonora, TXBuilt 1998 · S/N 2888N7031ASmith Helicopters Inc · Cotulla, TXBuilt 1998 · S/N 2892N7039NRegistered aircraftBuilt 2014 · S/N 4640N7041XJets To Helis LLC DBA · Chandler, AZBuilt 2014 · S/N 4663N7045XSale Reported · Colfax, WISale reportedS/N 3236N7049CFlight World Inc · San Juan, PRBuilt 1998 · S/N 2884N70562Jets To Helis LLC DBA · Chandler, AZBuilt 2001 · S/N 3281N7059HFly In Helicopters LLC · Florence, SCS/N 3695N7059SParker Helicopter LLC · Watsonville, CABuilt 1999 · S/N 2904N7062FGeorge'S Aviation Services Inc · Honolulu, HIBuilt 1998 · S/N 2894N7064DLippincott David H · San Diego, CABuilt 1999 · S/N 2907N7065RJets To Helis LLC DBA · Chandler, AZBuilt 2013 · S/N 4619N706JJJj Helicopters Inc · Torrance, CABuilt 2008 · S/N 4306N7073URent A Copter LLC · Homer Glen, ILBuilt 2013 · S/N 4625N7073YSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2014 · S/N 4650N7086USouthern Utah University · Cedar City, UTBuilt 2004 · S/N 3702N7087JHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 2873N7087KRobinson Helicopter Co Inc · Torrance, CABuilt 1999 · S/N 2945N7090MHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 2016 · S/N 4714N7096LVertical Corp · Kalispell, MTBuilt 2017 · S/N 4742N7098PJets To Helis LLC DBA · Chandler, AZBuilt 2014 · S/N 4660N7101JAltus Aviation Management · Las Vegas, NVNon-citizen corporation, flight hours not reportedBuilt 1999 · S/N 3005N7109SCitation Companeros LLC · Seguin, TXBuilt 1999 · S/N 2952N7119DBuell Travis · Harper, TXBuilt 1999 · S/N 2939N7122AContinental Helicopters Inc · Sheffield, TXBuilt 1999 · S/N 2956N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676N712WHWhiskey Hotel LLC · Marengo, ILBuilt 1991 · S/N 1712N7135JSierra Flite LLC · Camden, DEBuilt 1999 · S/N 2899N7139LAmoss Harold Lindsay III · Redmond, ORBuilt 1999 · S/N 2970N713USoco Aero Leasing LLC · Santa Rosa, CABuilt 2005 · S/N 3985
Back to AD 88-26-01 R2