AD 95-26-05 R1

Registered aircraft · 1,944

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:95-26-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-05-R1')
  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.

N7183NTop Gun Precision Ag LLC · Skidmore, TXBuilt 2000 · S/N 0703N7183PKerr Ken · Nome, AKS/N 0535N7183WConrad Charles J · Wasilla, AKBuilt 1999 · S/N 0564N7184GEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2000 · S/N 0937N7184NBas Part Sales LLC · Greeley, COS/N 0116N7187XSouth Florida Helicopters Inc · Indiantown, FLBuilt 1999 · S/N 0552N71888Anjum Mohammad A · Melrose Park, ILBuilt 1998 · S/N 0507N7188DUS Aviation Training Solutions Inc · Titusville, FLBuilt 2000 · S/N 0782N7189ZSmd Vineyards Inc · Salinas, CAS/N 0876N718EPPeregrine Air LLC · Mount Vernon, WABuilt 2002 · S/N 1177N718SCHelico Rotors Inc · Miami Beach, FLBuilt 2000 · S/N 0853N7192BAstroone LLC · Culpeper, VABuilt 2000 · S/N 0848N7192H7192h LLC · Redwood City, CABuilt 2000 · S/N 0858N7192URed Hawk Aviation LLC · Allegan, MIBuilt 2000 · S/N 0875N7193YExcel Helicopters LLC · Orange Grove, TXBuilt 2001 · S/N 1038N7195DCedar Ridge Aviation LLC · Knox City, TXBuilt 2000 · S/N 0905N7195HGregory Family Farms LLC · Lewes, DES/N 0799N7195PSpitzer Helicopter LLC · Woodland Hills, CABuilt 2001 · S/N 1127N7196HState Of Alaska · Anchorage, AKBuilt 2001 · S/N 0994N7196UThomas Aviation LLC · Orleans, CABuilt 2001 · S/N 1086N7197JBrown Ronnie J · Anahuac, TXBuilt 2001 · S/N 1059N7197VExecutive Helicopters Inc · Myrtle Beach, SCBuilt 1999 · S/N 0692N71AFDesert Air Ag Inc · Terreton, IDBuilt 2009 · S/N 12891N71SEJax Transport LLC · Amarillo, TXBuilt 2017 · S/N 14150N720CMCooper Mountain Ranch LLC · Snyder, TXBuilt 2023 · S/N 14644N720HRHeather Rae LLC · East Greenwich, RIBuilt 2024 · S/N 14809N720SMOlson Willow · Golovin, AKBuilt 2009 · S/N 12762N721BBRs Aviation Services · Moorpark, CABuilt 2008 · S/N 12593N721JRDakma LLC · Parma, OHBuilt 2005 · S/N 11015N722ATDevries Electric Inc · Pella, IABuilt 2017 · S/N 14070N722DLSky West Aviation Inc Trustee · Albuquerque, NMFirst renewal noticeS/N 13577N723MJ3 E LLC · Hudson, WIBuilt 2022 · S/N 14552N723RGHatchett Creek Leasing Inc · Delta, ALBuilt 2005 · S/N 10658N723VCVaught Air LLC · Crane, MOBuilt 2016 · S/N 13988N7244CMullinx Victor L · Holt, MOBuilt 2004 · S/N 10547N724HWheels In The Well LLC · Jonesboro, ARBuilt 2019 · S/N 14293N724RGHeli Guide Leasing Inc · Crystal Beach, FLBuilt 2001 · S/N 1150N725GTLambert Contracting LLC · Hollywood, ALBuilt 2018 · S/N 14213N725SMS&M Aviation LLC · South Boston, VABuilt 2000 · S/N 0754N726WMichelesaire Inc · Wilmington, DEBuilt 2006 · S/N 11382N727AKPsi Applications LLC · Cambridge, NEBuilt 2008 · S/N 12269N727DTClassic Drywall LLC · Richmond, KYBuilt 2017 · S/N 30019N727KPAero Leasing Inc · Brookings, ORBuilt 2004 · S/N 1416N7282ABell Helicopters LLC · Melbourne, FLBuilt 2006 · S/N 11182N728PGPolar Star Corp · Kalispell, MTBuilt 2001 · S/N 1107N728TSSky King LLC · Baltimore, MDBuilt 2009 · S/N 2025N729DBTtheil LLC · Saxonburg, PABuilt 2009 · S/N 12714N72HHPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 10502N72PKJ&J Investment Of Puerto Rico LLC · Moca, PRBuilt 2007 · S/N 11581N72WDZatzworks Inc · Homer, AKBuilt 2007 · S/N 11824
Back to AD 95-26-05 R1