N118HQ
Service difficulty reports · 134
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 = 'N118HQ' 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 = 'N118HQ' 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 R61A201708120614Mount Bracket · corrodedAFT CARGO AFT DRAIN MAST MOUNTING BRACKET AND RIVETS ARE CORRODED. REMOVED AND REPLACED THE DRAIN MAST MOUNTING BRACKET IAW SRM 51-41-01, SRM 51-41-02, ALODINED, PRIMED, AND TOPCOATED IAW SRM 51-23-04, 51-23-05, AND 51-23-06.SDR R61A201708120613Doubler · corrodedCORROSION FOUND ON THE SKIN DOUBLER AT WASTE BOX CUT OUT. REMOVED AND REPLACED WASTE BOX CUTOUT DOUBLER IAW SRM 51-43-03, AND 51-41-04.SDR R61A201708080586Shear Tie · corrodedSHEAR TIE AT FRAME 88 FROM STRINGERS 27R - 28R IS CORRODED. REMOVED AND REPLACED SHEAR TIE IAW SRM 51-41-01, AND 51-41-02.SDR R61A201708080588Seal Rest · corrodedAFT CARGO DOOR CUTOUT UNDER THE SCUFF PLATE HAS MINOR CORROSION ON THE FORWARD SEAL REST. REMOVED AND REPLACED AFT CARGO LOWER FORWARD SEAL REST. PN 170-85492-403 REF E175 AMM 20-10-07, SRM 51-21-02, 51-40-02, 51-40-04,51-23-04 AND SB 170-53-0104 ALODINED, PRSDR R61A201708080587Seal Rest · corrodedAFT CARGO DOOR CUTOUT UNDER THE SCUFF PLATE HAS MINOR CORROSION ON THE CENTER SEAL REST. REMOVED AND REPLACED AFT CARGO LOWER CENTER SEAL REST. PN 170-85251-401 REF E175 SRM 51-41-01,51-23-06,51-23-04 AND SB 170-53-0104. ALODINED, PRIMED, AND TOPCOATED REF EMSDR R61A201708080589Shear Tie · corrodedAFT CARGO SHEAR TIE AND RIVETS ARE CORRODED AT FRAME 87 BETWEEN STRINGERS 26R AND 27R. REMOVED AND REPLACED THE SHEAR IAW SRM 51-41-01, AND SRM 51-41-02. ALODINED, PRIMED, AND TOP COATED IAW SRM 51-23-04, 51-23-05, AND 51-23-06.SDR R61A201706230464Battery · dischargedEMERGENCY LIGHT IN COCKPIT WILL NOT COME ON. R & R EMERGENCY LIGHT BATTERY 1 IAW AMM 33-50-01. OPS CHECK IAW AMM 33-50-00. ALL OPS CHECKED GOOD.SDR R61A201704080271Wire Harness · damagedL1 DOOR INDICATION SHOWING YELLOW WITH BLACK X ON MFD STATUS PAGE WHEN DOOR IS CLOSED, ARMED, AND LOCKED. R & R THE FWD PASSENGER DOOR WARNING SENSOR HARNESS IAW AMM 52-72-20. OPS CHECK GOOD.SDR R61A201611130652Warning Light · false activationDURING FLIGHT, CREW RECEIVED AN SPDA FAIL AND A FUEL FEED 1 FAULT ADVISORY MESSAGE. CREW RAN QRH AND NOTED THAT THE PACKS WERE OFF THE BLEED VALVE CLOSED. CABIN PRESSURE CONTINUED TO RISE, CREW DONNED OXYGEN MASKS AND PERFORMED EMERGENCY DESCENT. DIVERTED AND SDR R61A201608050457Slide · deployedF/A CLOSED THE L1 DOOR AND THE DOOR ARMING AND VENT FLAP LEVERS WOULD NOT CLOSE. F/A OPENED THE L1 DOOR AND THE SLIDE DEPLOYED. MAINTENANCE R & R L1 DOOR SLIDE IAW AMM AND OPS CHECKED GOOD.SDR R61A201511280882Torque Tube · failedAS CREW WAS RETRACTING THE FLAPS, RECEIVED A MASTER CAUTION FLAP FAIL MESSAGE. CREW RAN QRH, DECLARED AN EMERGENCY AND ELECTED TO RETURN TO DEPARTURE. LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND THE RT TORQUE TUBE HAD FALLEN OFF INBD SIDE OF THSDR R61A201511200869Module · inoperativeFLYING, CREW RECEIVED PARKING BRAKE NOT RELEASED MESSAGE. CREW RAN QRH, DECLARED AN EMERGENCY AND DIVERTED. WITH EMERGENCY VEHICLES STANDING BY AND PASSENGERS BRACING, CREW LANDED WITHOUT INCIDENT. CREW TAXIED TO GATE WHERE PASSENGERS DEPLANNED NORMALLY. MASDR R61A201511190861Pressure Switch · malfunctionedDURING CHECK FLIGHT, CREW RECEIVED BRAKE DEFAULT MESSAGE FOLLOWED BY EMERGENCY BRAKE NOT RELEASED MESSAGE. CREW RAN QRH AND DECLARED AN EMERGENCY. ACFT LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED, R & R BRAKE CONTROL PRESSURE SWITCHES, AND TARGET LOADED SDR R61A201511160844Connector · disconnectedWHILE IN HEAVY CHECK, MAINTENANCE REPORTED THAT THE PAX CABIN NR 3 CEILING EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE PLUGGED IN PAX CABIN NR 3 CEILING EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201511090854Spar · corrodedDURING HEAVY CHECK, AFTER REAMING SPAR 3 HOLE, CF2 BULKHEAD DISCOVERED CRACKS IN BORE. MAINTENANCE RT WHEEL WELL SIDE FITTING OF SPAR 3 WING STUBS WAS REPAIRED IAW ETD 205-170-101371.SDR R61A201511070853Seal Rest · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT LWR FWD CARGO DOOR LOWER FWD SEAL REST IS CORRODED. MAINTENANCE R & R LWR FWD CARGO DOOR LOWER FWD SEAL REST IAW SRM 51-40-00, PN 170-66803-401, SEAL REST.SDR R61A201511070852Seal Rest · corrodedDURING HEAVY CHECK WAS REPORTED THAT FWD CARGO DOOR AFT LOWER SEAL REST IS CORRODED. MAINTENANCE R & R FWD CARGO DOOR AFT LOWER SEAL REST IAW SRM 51-40-00 SEAL REST, PN 170-66803-402.SDR R61A201511010855Spar · crackedDURING HEAVY CHECK, WAS REPORTED THAT AFTER REAMING HOLE ON LT SPAR 3, CF 2 BULKHEAD DISCOVERED CRACKS IN BORE. MAINTENANCE REPAIRED IAW ETD 205-170-101371.SDR R61A201511010851Support Bracket · crackedDURING HEAVY CHECK LT RAM AIR DUCT SUPPORT BRACKET IS CRACKED. MAINTENANCE R & R LT RAM AIR DUCT SUPPORT BRACKET IAW SRM 51-46-02, 51-41-01.SDR R61A201511010850Rib · crackedDURING HEAVY CHECK, WAS REPORTED THAT LT HORIZONTAL STABILIZER, RIB 12 FWD UPPER FLANG IS CRACKED. MAINTENCE PERFORMED PERMANENT REPAIR TO LT HORIZONTAL STABILIZER, RIB 12 FWD UPPER FLANGE IAW ETD 2015-170-102356.SDR R61A201511010814Dampener · corrodedDURING HEAVY CHECK, L-2 DAMPENER IS CORRODED. MAINTENANCE R & R L-2 DAMPENER IAW AMM 51-12-27, PN SP-21619A, DAMPENER.SDR R61A201511010804Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER RIB 12 UPPER FLANGE IS CRACKED. MAINTENANCE PERFORMED A PERMANENT REPAIR IAW ETD 2015-170-101402.SDR R61A201511010803Rib · crackedDURING HEAVY CHECK, LEFT HORIZONTAL STABILIZER, RIB 12 FWD UPPER FLANGE IS CRACKED. MAINTENANCE PERFORMED A PERMANENT REPAIR IAW ETD 2015-170-102356.SDR R61A201510310849Nut · corrodedDURING HEAVY CHECK, L1 DOOR LOWER FWD DOOR STOP ON DOOR IS CORRODED. MAINTENANCE R & R L1 DOOR LOWER FWD DOOR STOP ON DOOR IAW AMM 52-11-23, PN NAS 509-7 L1 DOOR LOWER FWD DOOR STOP ON DOOR NUT.SDR R61A201510310848Nut · corrodedHEAVY CHECK WAS REPORTED THAT FWD PASSENGER DOOR LOWER AFT DOOR STOP ON DOOR HARDWARE IS CORRODED. MAINTENANCE R & R FWD PASSENGER DOOR LOWER AFT DOOR STOP ON DOOR HARDWARE IAW AMM 52-11-23, PN NAS509-7, NUT.SDR R61A201510310809Stop Fitting · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR, AFT LOWER DOOR STOP ON DOOR HARDWARE IS CORRODED. MAINTENANCE R & R AFT PASSENGER DOOR, AFT LOWER DOOR STOP ON DOOR HARDWARE IAW AMM 52-12-23, PN NAS509-7 NUT.SDR R61A201510310808Stop Fitting · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR FWD UPPER AND LOWER DOOR STOPS HARDWARE IS CORRODED. MAINTENANCE R & R AFT SERVICE DOOR FWD UPPER AND LOWER DOOR STOPS HARDWARE IAW AMM 52-42-00, PN NAS509-7, NUT.SDR R61A201510300813Shear Tie · corrodedDURING HEAVY CHECK, SHEAR CLIP AT WASTE BOX IS CORRODED. MAINTENANCE R & R SHEAR CLIP AT WASTE BOX IAW SRM 51-41-01.SDR R61A201510300812Structure · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX IS CORRODED. MAINTENANCE R & R WASTE SERVICE BOX IAW SRM 51-43-02, PN 170-65078-405 WASTE BOX ASSY.SDR R61A201510300805Screw · corrodedDURING HEAVY CHECK, AFT PYLON FAIRING, AFT INBD SIDE HARDWARE IS CORRODED ON BONDING JUMPER. MAINTENANCE R & R AFT PYLON FAIRING, AFT INBD SIDE HARDWARE IAW AMM 20-13-21. PN NAS1861-3-9, SCREW.SDR R61A201510290847Floorbeam · crackedDURING HEAVY CHECK, FLIGHT DECK FLOOR BRACKET AT FRAME 12 OTBD OF CAPTAIN`S LT SEAT TRACK IS CRACKED. MAINTENANCE R & R FLIGHT DECK FLOOR BRACKET AT FRAME 12 OTBD OF CAPTAIN`S LT SEAT TRACK IAW SRM 51-40-02, 51-41-01, PN 170-13238-001, BRACKET.SDR R61A201510290846Floorbeam · crackedDURING HEAVY CHECK, FLIGHT DECK FLOOR SUPPORT BRACKET AT FRAME 12, AFT OF CONNECTOR PLUG IS CRACKED. MAINTENANCE R & R FLIGHT DECK FLOOR SUPPORT BRACKET AT FRAME 12 AFT OF CONNECTOR PLUG IAW SRM 51-40-02, 51-41-01, PN 170-16131-001, ANGLE.SDR R61A201510290845Skin · corrodedDURING HEAVY CHECK, WASTE SERVICE DOOR ON INNER DOOR SKIN IS CORRODED. MAINTENANCE R & R WASTE SERVICE DOOR IAW AMM 28-10-01, PN 170-86668-403 DOOR.SDR R61A201510290815Connector · crackedDURING HEAVY CHECK, FLIGHT DECK FLOOR SUPPORT BRACKET AT FRAME 12 AFT CONNECTOR PLUG IS CRACKED. MAINTENANCE R & R IAW SRM 51-40-02 AND 51-40-01. PN 170-16131-001 ANGLE.SDR R61A201510290811O-Ring · damagedDURING HEAVY CHECK, EMERGENCY RAM AIR CHECK VALVE O-RING DAMAGED. MX R & R EMERGENCY RAM AIR CHECK VALVE O-RING IAW AMM 21-25-03, PN 24096-5001, O-RING.SDR R61A201510290810Firewall · crackedDURING HEAVY CHECK, 351BZ APU FIRE WALL HAS CRACK. MAINTENANCE REPAIRED BY TRIMMING OUT CRACK IAW SRM 53-31-21.SDR R61A201510290806Tray · crackedDURING HEAVY CHECK, FLY BY WIRE BACK UP BATTERY TRAY FOUND CRACKED. MAINTENANCE R & R BATTERY TRAY IAW AMM 27-03-05 AND SM-1589-NE-06-0001.SDR R61A201510270807Stop Fitting · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR STOP, BOTTOM FWD EDGE IS CORRODED. MAINTENANCE R & R AFT SERVICE DOOR STOP IAW AMM 52-42-00, PN NAS509-7, NUT.SDR R61A201506170374Lever · out of adjustCREW REPORTED THAT THE L2 DOOR WOULD NOT ARM. MAINTENANCE ADJUSTED THE L2 DOOR ARMING LEVER IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201501020006Flashlight · inoperativeCREW REPORTED THAT THE F/O FLASHLIGHT WAS INOPERATIVE. R & R THE F/O FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201412201253Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE. R & R FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201403110361Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT IN THE FIRST CLASS SECTION WAS LIFTED UP. MAINTENANCE SECURED EMERGENCY LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201403080356Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT WAS LOOSE. MAINTENANCE SECURED LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201401080035Indicator · out of adjustCREW REPORTED THAT THE L2 DOOR WOULD NOT ARM CORRECTLY. ADJUSTED INDICATOR FLAG ON DOOR IAW AMM AND OPS CHECKED GOOD. AIRCRAFT IS GOOD FOR SERVICE.SDR R61A201311251245Cable · brokenCREW REPORTED THAT THE L2 DOOR SLIDE WAS HANGING OUT OF DOOR. MAINTENANCE FOUND THE L2 SLIDE UNLACED WITH THE GIRT BAR STILL ENGAGED IN THE FLOOR AND THE FLEXBALL CABLE BROKEN. MAINTENANCE R & R THE FLEXBALL CABLE AND SLIDE ASSEMBLY IAW AMM. HOWEVER, WHEN THSDR R61A201311231233Cable · frozenR2 DOOR WILL NOT PROPERLY ARM. MX R & R R2 ARMING CABLE IAW AMM 52-12-40.SDR R61A201311171163Lever · dirtyCREW REPORTED THAT L1 DOOR INDICATION WAS NOT SHOWING CLOSED WITH HANDLES DOWN AND IN ADDITION, HAD A RED DOOR OPEN INDICATION IN THE COCKPIT. MAINTENANCE INSPECTED IAW AMM AND REMOVED DEBRIS FROM THE L1 DOOR FLAG LEVER AREA. L1 DOOR OPS CHECKS GOOD AND IS GOSDR R61A2013110501115Door · bindingCREW REPORTED THAT THE L1 DOOR WAS HARD TO CLOSE. MAINTENANCE SECURED DOOR CLOSED IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201310281069Bolt · corrodedDURING HEAVY CHECK, LT PYLON 419DT HAS SEVERAL SCREWS ALONG TOP OF PANEL THAT ARE CORRODED. MX R & R CORRODED SCREWS ON LT PYLON PANEL 419DT IAW AMM 54-50-21.SDR R61A201310201049Structure · corrodedDURING HEAVY CHECK, AFT GALLEY TRIM CORRODED ON BOTH MATTING SURFACES. MAINTENANCE R & R CORRODED AFT GALLEY TRIM ON BOTH MATTING SURFACES IAW AMM 25-0023 AND SRM 51-12-00.
Back to N118HQ