N125HQ
Service difficulty reports · 90
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N125HQ' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N125HQ' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR R61A201612220062Shear Tie · corrodedDURING HEAVY CHECK, AFT CARGO BAY FRAME 82, STRINGERS 26-27R SHEAR CLIP IS CORRODED. MAINTENANCE R & R THE SHEAR TIE IAW SRM 51-40-02, 51-41-01.SDR R61A201612220056Beam · corrodedDURING HEAVY CHECK FWD CARGO DOOR CUTOUT LOWER BEAM IS CORRODED. MAINTENANCE R & R FWD CARGO DOOR CUTOUT LOWER BEAM IAW SRM 51-40-02, 51-23-04, 51-43-01, 53-43-02. PN 170-67118-003, BEAM.SDR R61A201612210063Seal Rest · corrodedDURING HEAVY CHECK, AFT CARGO DOOR MIDDLE SEAL REST IS CORRODED. MAINTENANCE R & R THE SEAL REST IAW SRM 51-41-01.SDR R61A201508140526Fmu · failedABOUT 3 MILES FROM LANDING, CREW REPORTED THE NR 1 ENGINE FAILED. CREW DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. AFTER BEING CHECKED OUT BY THE FIRE DEPARMENT, CREW TAXIED TO GATE UNDER OWN POWER. MAINTENANCE TROUBLESHOT, R & R FMU IAW AMM AND OPS SDR R61A201501050008Battery Pack · inoperativeCREW REPORTED THAT THE EMERGENCY SIGN WAS INOPERATIVE. MAINTENANCE R & R THE BATTERY PACK IAW AMM AND OPS CHECKED GOOD.SDR R61A201408251020Sensor · failedCREW REPORTED A FLAP FAIL MESSAGE, ON APPROACH SLATS OPERATED, HOWEVER, FLAPS DID NOT. CREW DECLARED AN EMERGENCY AND REQUESTED EMERGENCY EQUIPMENT BE STANDING BY. CREW DID NOT HAVE PASSENGERS BRACED, LANDED WITHOUT INCIDENT AND TAXIED TO GATE UNDER OWN POWERSDR R61A201404210566Attach Fitting · brokenCREW REPORTED THAT THE R2 DOOR WOULD NOT DISARM. MAINTENANCE INSPECTED AND FOUND THE GIRT BAR ATTACH POINT PLATE SCREWS ON THE FLOOR WERE BROKEN CAUSING THE GIRT BAR TO NOT MOVE PROPERLY. MAINTENANCE R & R THE FLOOR ATTACHMENT CUP AND COVER SCREWS IAW AMM ANSDR R61A201412300007Seal Depressor · corrodedDURING HEAVY CHECK, R2 DOOR LOWER CENTER SEAL REST CORRODED. MAINTENANCE R & R R1 DOOR LOWER CENTER SEAL REST IAW SRM 51-40-02, 51-10-03, 51-41-03. PN 170-87556-402, SEAL REST. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201412290008Sill · corrodedDURING HEAVY CHECK, R2 DOOR SILL HAS CORROSION AFT OF GIRT BAR FIXTURE. MAINTENANCE R & R R2 DOOR SILL IAW SRM 170/175, SRM 51-43-01, & 51-43-02.SDR R61A201407290004Skin · dentedDURING HEAVY CHECK, A SMALL DENT WAS FOUND IN THE SKIN FWD OF MAIN CABIN DOOR, BELOW JUST AFT OF 175 LOGO. MAINTENANCE CLASSIFIED AS A MAJOR REPAIR DO TO REPLACEMENT OF FRAME 11 SHEAR TIE FCBS 53-10-00-005 IAW SRM 51-41-01 AND 51-41-02. RECOUNTOURED DENTS IAWSDR R61A201412280009Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STAB L/E RIB 4 CRACKED. MX CUT OUT DAMAGED AREA, FABRICATED REPAIR ANGLE, FABRICATED FILLER IAW ETD 2013-170-071192, REV D. INSTALLED ANGLE AND FILLER IAW SRM 51-41-01, 51-41-02.SDR R61A201412270010Doubler · corrodedDURING HEAVY CHECK, LAVATORY SERVICE BOX DOUBLER CORRODED. MX R & R CORRODED DOUBLERS, AND COMPLETED SB 170-53-0095.SDR R61A201412260005Dampener · corrodedDURING HEAVY CHECK, R1 DOOR DAMPENER HAS CORROSION. MX R & R DOOR DAMPENER IAW AMM 52-41-27.SDR R61A201412250006Bulkhead · crackedDURING HEAVY CHECK, LEFT FWD MLG WHEEL WELL BULKHEAD COMPOSITE PANEL IS CRACKED. MAINTENANCE R & R COMPOSITE PANEL IAW SRM 51-42-01.SDR R61A201312241349Pan · crackedDURING HEAVY CHECK, FOUND SEAT PANS CRACKED. R & R SEAT PANS IAW AMM 25-21-17,SDR R61A201311211230Warning Message · false activationCREW RECEIVED A STEER FAIL MESSAGE UPON EXTENSION OF LANDING GEAR. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT, HOWEVER THE ACFT HAD TO BE TOWED TO THE GATE. MAINTENANCE PERFORMED INSPECTION AND CHECK OF THE GEAR AND DOORS IAW AMM. ALL FASDR R61A201305030444Cable · brokenCREW REPORTED THAT THE R2 DOOR IS HARD TO CLOSE. MAINTENANCE FOUND THE R2 DOOR GIRT BAR CABLE IS BROKEN. AIRCRAFT WAS FLOWN VIA MAINTENANCE FERRY TO CMH WHERE THE GIRT BAR CABLE WAS REPLACED PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201202230129Support Angle · crackedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK MAINTENANCE FOUND THE LEFT WHEEL WELL FORWARD BULKHEAD UPPER SUPPORT ANGLE CRACKED. MAINTENANCE REMOVED AND REPLACED SUPPORT ANGLE ON THE LEFT WHEEL WELL FORWARD BULKHEAD IAW EMB 175 SRM 51-43-01 AND 51-41-00.SDR R61A201202230128Seat Track · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LT SEAT TRACK BEAM FORWARD OF FRAME 86. MAINTENANCE REMOVED AND REPLACED THE LT SEAT TRACK BEAM FORWARD OF FRAME 86 IAW EMB 175 SRM 51-41-01 & 51-43-01. AIRCRAFT IS CURRENTLY STILL OUTSDR R61A201202230127Shear Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LEFT SHEAR PLATE AT FRAME 87. MAINTENANCE REMOVED AND REPLACED THE SHEAR PLATE AND SPLICE PLATE AT FRAME 87 IAW EMB 175 SRM 51-40-01, 51-40-02, 51-40-03, 51-40-04 & 51-42-01. REF P/N'S SDR R61A201202230126Shear Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LEFT SHEAR PLATE AT FRAME 87. MAINTENANCE REMOVED AND REPLACED THE SHEAR PLATE AND SPLICE PLATE AT FRAME 87 IAW EMB 175 SRM 51-40-01, 51-40-02, 51-40-03, 51-40-04 & 51-42-01. REF P/N'SSDR R61A021202230121Mount Bolt · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE L-2 DOOR EMERGENCY SLIDE FORWARD LOWER MOUNT BOLT. MAINTENANCE REMOVED AND REPLACED THE L-2 DOOR EMERGENCY SLIDE FORWARD LOWER MOUNT BOLT IAW EMB 175 AMM 20-10-01. AIRCRAFT IS CURRENTLSDR R61A201202220125Shear Web · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE CENTER SHEAR WEB AT FRAME 87-88. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR WEB AT FRAME 87-88 IAW EMB 175 SRM 51-42-01 & 51-40-02. AIRCRAFT IS STILL CURRENTLY OUT OF SERVICE FOSDR R61A201202220124Seat Track · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE SEAT TRACK BEAM AFT OF FRAME 86. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BEAM AFT OF FRAME 86 IAW EMB 175 SRM 51-41-01, 51-41-02, 51-41-03, 51-23-00, 51-23-05, 51-40-00, 51-40-0SDR R61A201202220120Doubler · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LAV WASTE BOX, FORWARD INTERNAL DOUBLER. MAINTENANCE REMOVED AND INSTALLED NEW SERVICEABLE DOUBLER ON THE LAV WASTE BOX IAW EMB 175 SRM 51-43-02 & 51-23-00. AIRCRAFT IS CURRENTLY STILLSDR R61A201202210123Shear Web · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT SHEAR WEB IN THE AFT WET AREA BETWEEN FRAMES 86 & 87. MAINTENANCE REMOVED AND REPLACED THE RT SHEAR WEB IN THE AFT WET AREA BETWEEN FRAMES 86-87. AIRCRAFT IS CURRENTLY STILL OUT OF SDR R61A201202200119Crossbeam · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE FLOOR CROSS BEAM 17, ON THE RT SIDE OF THE BEAM. MAINTENANCE REMOVED AND REPLACED CROSS BEAM 17 IAW EMB 175 SRM 51-41-01, 51-41-02, 51-43-03 AND 51-43-04. AIRCRAFT IS CURRENTLY STILL OSDR R61A201202200116Intercostal · corrodedACFT IN HEAVY CHECK, FOUND RIGHT INTERCOSTAL FROM FR 89 TO 90 CORRODED. MX REMOVED AND REPLACED RIGHT INTERCOSTAL IAW SRM 51-41-01, 51-41-02, 51-43-03, 53-23-10.SDR R61A201202190118Seat Track · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE FLOORBOARD STRUCTURE (SEAT TRACK) UNDER FLOORBOARD PANEL 226BRF. MAINTENANCE REMOVED & REPLACED SEAT TRACK P/N 170-03263-001 IAW EMB 175 SRM 51-41-01, 51-41-02, 51-43-01 & 51-43-02. AISDR R61A201202190115Floor Support · corrodedACFT IN HEAVY CHECK, CORROSION FOUND ON FLOOR STRUCTURE UNDER FLOORBOARD 252ERF. MX REMOVED AND REPLACED CORRODED GUSSET IAW SRM 51-41-02.SDR R61A201202190114Floor Support · corrodedACFT IN FOR HEAVY CHECK, CORROSION FOUND ON FLOOR STRUCTURE PLATES UNDER FLOORBOARD 252ERF. MX REMOVED AND REPLACED CORRODED GUSSET IAW SRM 51-41-02.SDR R61A201202180117Hinge · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE LAV SERVICE DOOR HINGE. MAINTENANCE REMOVED AND REPLACED THE LAV SERVICE DOOR HALF HINGE IAW EMB 175 SRM 51-41-02 & 51-43-04. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY CHECKSDR R61A201202180113Screw · corrodedDURING HEAVY CHECK, FOUND RIGHT WING NR 1 SLAT LOWER SEALS WORN AND HARDWARE IS RUSTED. MX REMOVED AND REPLACED THE RIGHT WING NR 1 SLAT LOWER SEALS AND HARDWARE IAW AMM 57-41-09-04 AND EMB AMM 20-10-01. ACFT REMAINS IN HEAVY CHECK.SDR R61A20100591Sensor · faultyCREW REPORTED SLAT FAIL MESSAGE ON APPROACH, CREW DID NOT DECLARE AN EMERGENCY BUT EMERGENCY VEHICLES WERE ROLLED. AC LANDED WITHOUT INCIDENT. MX CLEARED INHIBITS PER FIM, OPS CK GOOD. LATER THAT DAY MX REMOVED AND REPLACED BOTH LT & RT SLAT SKEW/ DISCONNECSDR R61A20100589Unknown · malfunctionedCREW REPORTED SLAT FAIL ON APPROACH AND DECLARED EMERGENCY, CABIN WAS NOT PREPARED. A/C LANDED WITHOUT INCIDENT, MX RESET PER FIM, MESSAGE CLEARED OPS CHECK GOOD.SDR R61A20100113Slide · crackedWHILE IN HEAVY CHECK, CREW REPORTED L-1 DOOR EVAC SLIDE HAD A CRACK IN THE COMPOSITE NUT PLATE. MAINTENANCE REMOVED AND REPLACED THE L-1 EVAC SLIDE PER EMB AMM.SDR R61A20090079Battery · dischargedMTX REPORTED DURING FUNCTIONAL CHECK OF EMERGENCY LIGHTS, SEVERAL EMERGENCY LIGHTS WEREN'T ILLUMINATING. ONE LIGHT WAS AN EXIT SIGN, AND ONE WAS A COURTESY LIGHT. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY BATTERY AND PERFORMED OPS CHECKS PER EMB AMM.SDR R61A20090002Sensor · failedON CLIMBOUT CREW REPORTED, THEY RECEIVED SLAT/FLAP FAIL MESSAGE ON EICAS. CREW DECLARED EMERGENCY FOLLOWED QRH PROCEDURES AND RETURNED TO FIELD WITHOUT INCIDENT. MAINTENANCE WAS DISPATCHED TO A/C TROUBLESHOT SYSTEM FOUND SLAT 2/3 SKEW SENSOR TO BE BAD. REPLASDR R61A20080054Rod · brokenCREW REPORTED AFTER GEAR WAS RETRACTED AND HAD 3 GREEN, STILL HAD A NOSE GEAR DOOR OPEN. CYCLED GEAR AND STILL HAD MESSAGE. FOLLOWED QRH PROCEDURES, LANDED WITHOUT INCIDENT. AIRCRAFT WAS FERRIED TO PITTSBURGH. MAINTENANCE REPLACED NOSE LANDING GEAR DOOR ACSDR R61A200800008Flap · malfunctionedCREW REPORTED FLAP FAIL MESSAGE ON EICAS DURING DESCENT. CREW DECLARED EMERGENCY FOLLOWED QRH PROCEDURE AND LANDED WITHOUT INCIDENT. MAINTENANCE WAS DISPATCHED TO AIRCRAFT. RESET THE SF. ACE AND CLEARED INHIBITS. SYSTEM OPERATIONAL CHECK GOOD AND AIRCRAFT
Back to N125HQ