N131HQ
Service difficulty reports · 150
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 = 'N131HQ' 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 = 'N131HQ' 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 R61A201709170703Closeout Panel · corrodedAFT CARGO CUTOUT CLOSE-OUT PANEL HAS CORROSION. FOUND CLOSEOUT BEAM CORRODED OUT OF LIMITS. REMOVED AND REPLACED CLOSEOUT BEAM IAW AMM 20-10-01.SDR R61A201709180710Hinge · corrodedWASTE SERVICE DOOR AND HINGE CORRODED. NO DAMAGE ALLOWED TO DOOR OR HINGE. REMOVED AND REPLACED THE DOOR IAW AMM 53-03-63.SDR R61A201612140734Actuator · failedCREW RECEIVED A FLAP FAIL MESSAGE. CREW RAN QRH, DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT, REMOVED AND REPLACED RIGHT NR 4 FLAP ACTUATOR IAW AMM AND OPS CHECKED GOOD.SDR R61A201603110305Seal Rest · corrodedDURING HEAVY CHECK, NUT PLATES ALONG INTERNAL EDGE OF FWD CARGO DOOR AFT LOWER SEAL REST ARE CORRODED. MAINTENANCE R & R FWD CARGO DOOR AFT LOWER SEAL REST IAW SRM 175 51-40-02, 51-23-04, PN 170-66803-402 SEAL REST.SDR R61A201603110304Seal Rest · corrodedDURING HEAVY CHECK NUT PLATES ON AFT CARGO DOOR FWD AND AFT LOWER SEAL REST ARE CORRODED. MAINTENANCE R & R AFT CARGO DOOR FWD AND AFT LOWER SEAL REST IAW SRM 51-40-02, 51-23-04, 51-40-02. PN 170-85493-403, SEAL REST.SDR R61A201603110218Seal Rest · corrodedDURING HEAVY CHECK, NUT PLATES ALONG THE INTERNAL EDGE OF FWD CARGO DOOR FWD AND AFT LWR SEAL REST ARE CORRODED. MAINTENANCE R & R FWD CARGO DOOR FWD AND AFT LWR SEAL REST IAW SRM 51-40-02.SDR R61A201603110217Seal Rest · corrodedDURING HEAVY CHECK, NUT PLATES ON AFT CARGO DOOR FWD AND AFT LOWER SEAL REST ARE CORRODED. MAINTENANCE R & R AFT CARGO DOOR LOWER CORNER SEAL REST IAW AMM 20-10-01, PN 170-85493-403, SEAL REST.SDR R61A201603100215Skin · chafedDURING HEAVY CHECK, INTERIOR SKIN STRUCTURE OF FWD SERVICE DOOR IS CHAFED. MX BLENDED TO ALLOWABLE LIMITS COMPLIED WITH ETD 2016-170-025146.SDR R61A201603100300Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 88, STR 26-27R IS CORRODED. MAINTENANCE R & R SHEAR TIE AT FRAME 88, STR 26-27 RT IAW SRM 51-41-01, 51-41-02, PN 170-66533-001, SHEAR CLIP.SDR R61A201603100226Shear Tie · corrodedMAJOR REPAIR, DURING HEAVY CHECK, SHEAR TIE AT FRAME 88, STR 26-27 RT IS CORRODED. MAINTENANCE R & R SHEAR CLIP AT FRAME 88, STR 26-27 RT IAW SRM 51-40-02, 51-23-04, PN 170-66533-001, SHEAR .SDR R61A201603090225Spar · crackedDURING HEAVY CHECK, LT STUB WING SPAR 3 AT FASTENER REPLACEMENT HOLE IS CRACKED. MAINTENANCE REAMED HOLE AND INSTALLED BUSHING IAW ETD 2016-170-025349.SDR R61A201603080308Frame · corrodedDURING HEAVY CHECK WAS REPORTED THAT FRAME 84 DOUBLER AT RT SILL IS CORRODED. MAINTENANCE R & R FRAME 84 DOUBLER AT RT SILL IAW SRM 51-40-02, 51-41-01, 51-23-06, PN 170-92908-001, SUPPORT.SDR R61A201603080307Support · corrodedDURING HEAVY CHECK WAS REPORTED THAT RT PANEL SUPPORT AT FRAME 86-90 IS CORRODED. MAINTENANCE R & R RT PANEL SUPPORT AT FRAME 86-90 IAW SRM 51-42-01, 51-40-02, 51-43-03, PN 170-86181-005, SUPPORT.SDR R61A201603080306Gusset · corrodedDURING HEAVY CHECK, RT GUSSET PLATE AT FRAME 90 IS CORRODED. MAINTENANCE R & R RT GUSSET PLATE AT FRAME 90 IAW SRM 51-41-02, PN 170-60259-001, GUSSET PLATE.SDR R61A201603080303Attach Angle · corrodedDURING HEAVY CHECK, ATTACH ANGLE AT STR 19 RT FRAME 87 IS CORRODED. MAINTENANCE R & R ATTACH ANGLE AT STR 19 RT, FRAME 87 IAW SRM 51-43-03, 51-23-06, PN 170-85486-002, ANGLE.SDR R61A201603080302Seat Track · corrodedDURING HEAVY CHECK WAS REPORTED THAT RT AT FRAME 84 SEAT TRACK UPPER FLANGE IS CORRODED. MX REPAIRED CORROSION ON RT AT FRAME 84 SEAT TRACK UPPER FLANGE IAW ETD2016-170-024144.SDR R61A201603080299Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE FRAME 88 BETWEEN STR 27-28R IS CORRODED. MAINTENANCE R & R SHEAR TIE FRAME 88, BETWEEN STR 27-28 RT IAW SRM 51-40-02, 51-41-01, 51-41-02.SDR R61A201603080298Crossbeam · corrodedDURING HEAVY CHECK WAS REPORTED THAT FASTENERS IN FRAME 84 RT, CROSSBEAM ARE CORRODED. MAINTENANCE BLENDED CORROSION L-ANGLE INSTALLED CROSSBEAM 84 RT IAW ETD2016-170-024120.SDR R61A201603080295Frame · corrodedDURING HEAVY CHECK, FASTENERS IN FRAME 84 RT ARE CORRODED. MAINTENANCE REPAIRED CORROSION BY BLEND OUT AND LT ANGLE INSTALLED ON CROSS FRAME IAW ETD 2016-170-024120.SDR R61A201603080294Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 89 BETWEEN STR 29L-29R IS CORRODED. R & R SHEAR TIE IAW SRM 51-41-01, ETD2016-170-027911.SDR R61A201603080293Gusset · corrodedDURING HEAVY CHECK, RT GUSSET PLATE AT FRAME 90 IS CORRODED. MAINTENANCE R & R RT GUSSET PLATE AT FRAME 90 IAW SRM 51-42-01, PN 170-60259-001, GUSSET PLATE.SDR R61A201603080292Upper Sheet · corrodedDURING HEAVY CHECK RT Y=10.748 UPPER SHEET FRAME 85-86 IS CORRODED. MAINTENANCE R & R RT 10.748 UPPER SHEET FRAME 85-86 IAW SRM 51-40-02, 51-41-01, 51-43-01, 51-23-06.SDR R61A201603080291Retainer · corrodedDURING HEAVY CHECK AFT LAV PAN RETAINER IS CORRODED. MAINTENANCE PERFORMED SB 170-53-0095 CORROSION ON WATER WASTE BOX.SDR R61A201603080285Floor Support · corrodedDURING HEAVY CHECK, LT FWD FLOOR SILL FRAME 12-16 IS CORRODED. MAINTENANCE R & R LT FWD FLOOR SILL FRAME 12-16 IAW SRM 51-43-04, 51-41-02. PN 170-03275-005, SILL FLOOR.SDR R61A201603080284Floorbeam · corrodedDURING HEAVY CHECK, LT FLOOR SUPPORT AT FRAME 19 CROSSBEAM IS CORRODED. MAINTENANCE R & R BRACKET AT LT FLOOR SUPPORT AT FRAME 19 IAW SRM 51-40-02, 51-41-02, 51-43-03, 51-21-02.SDR R61A201603080227Shear Tie · corrodedMAJOR REPAIR, DURING HEAVY CHECK, SHEAR CLIP AT FRAME 88 BETWEEN 27-28, RT IS CORRODED. MAINTENANCE R & R SHEAR CLIP AT FRAME 88 BETWEEN 27-28 RT IAW SRM 51-41-01, 51-41-02, 51-23-06, PN 170-66531-001, SHEAR CLIP.SDR R61A201603080220Floor Support · corrodedDURING HEAVY CHECK LT FORWARD FLOOR SUPPORT AT FRAMES 12-16 IS CORRODED. MAINTENANCE R & R LT FORWARD FLOOR SUPPORT AT FRAMES 12-16 IAW SRM 51-40-02, PN 170-03275-005, SILL.SDR R61A201603080219Floorbeam · corrodedDURING HEAVY CHECK, LT FLOOR SUPPORT AT FRAME 19 CROSSBEAM IS CORRODED. MAINTENANCE R & R BRACKET AT FRAME 19 IAW SRM 51-40-02, 51-41-02, 51-43-03, 51-21-01.SDR R61A201603080216Attach Angle · corrodedDURING HEAVY CHECK WAS REPORTED THAT ATTACH ANGLE AT STRINGER 19 RT FRAME 87 IS CORRODED. MAINTENANCE R & R ATTACH ANGLE AT STRINGER 19 RT FRAME 87 IAW SRM 51-40-02, 51-23-04, PN 170-85486-002 ANGLE.SDR R61A201603080214Frame · corrodedMAJOR REPAIR, DURING HEAVY CHECK, FASTENERS AT FRAME 84 RT ARE CORRODED. MAINTENANCE R & R FASTENERS AT FRAME 84 RT IAW ETD 2016-170-024120.SDR R61A201603080213Floor Support · corrodedDURING HEAVY CHECK, RT PANEL SUPPORT FRAMES 86-90 IS CORRODED. MAINTENANCE R & R RT PANEL SUPPORT FRAMES 86-90 IAW SRM 51-40-02, 51-42-01, 51-43-03, PN 170-86181-005, SUPPORT.SDR R61A201603080212Gusset · corrodedDURING HEAVY CHECK WAS REPORTED THAT RT GUSSET PLATE AT FRAME 90 IS CORRODED. MAINTENANCE R & R RT GUSSET PLATE AT FRAME 90 IAW SRM 51-41-02,51-41-02, PN 170-60259-001 GUSSET.SDR R61A201603080211Upper Sheet · corrodedDURING HEAVY CHECK WAS REPORTED THAT RT +10.748 UPPER SHEET FRAME 85-86 IS CORRODED. MAINTENANCE R & R RT Y=+ 10.748, UPPER SHEET FRAME 85-86 IAW SRM 51-40-02, 51-41-01, 51-43-01. PN 170-86101-001 UPPER SHEET.SDR R61A201603080210Doubler · corrodedDURING HEAVY CHECK, DOUBLER FRAME 84 AT RT SILL IS CORRODED. MX R & R DOUBLER FRAME 84 AT RT SILL IAW EMB 170/175, SRM 51-40-02, 51-41-01. PN 170-92908-001, DOUBLER.SDR R61A201603070301Doubler · damagedDURING HEAVY CHECK, EXTERNAL SIDE OF WASTE SERVICE BOX ON ON LT SIDE OF ACCESS DOOR IS DAMAGED. MAINTENANCE R & R DOUBLE SRM 51-10-03, 51-41-02, 51-41-01, 51-43-04.SDR R61A201603070224Doubler · damagedDURING HEAVY CHECK, WAS REPORTED THAT EXTERNAL SIDE OF WASTE BOX HAS DAMAGE. LT SIDE ACCESS DOOR. MAINTENANCE R & R WASTE BOX DOUBLER IAW SRM 51-41-02, 51-41-01, 51-43-04.SDR R61A201603070209Gusset · chafedMAJOR REPAIR DURING HEAVY CHECK WAS REPORTED THAT FWD E-BAY PLUG FWD RT GUSSET CHAFED. MAINTENANCE R & R FWD E-BAY PLUG FWD RT GUSSET IAW SRM 51-40-02, 51-41-01. PN 170-11682-001 GUSSET. AIRCRAFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201507260460Control Module · failedCREW RECEIVED A RT AND LT BRAKE FAULT MESSAGE. CREW ELECTED TO GO AROUND, RAN QRH AND DECLARED AN EMERGENCY. LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT, R & R BRAKE CONTROL MODULE IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR R61A201507060414Battery Pack · inoperativeCREW REPORTED THAT THE FORWARD EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201507060413Battery Pack · inoperativeMAINTENANCE REPORTED THAT THE EXIT MARKER WAS INOPERATIVE. MAINTENANCE R & R EMERGENCY BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201403280466Support Angle · corrodedDURING HEAVY CHECK, MAINTENANCE FOUND UPPER SUPPORT ANGLE CRACKED IN THE LT WHEEL WELL FORWARD BULKHEAD. MAINTENANCE R & R THE UPPER SUPPORT ANGLE IAW SRM 51-41-01, 51-42-01, 51-43-03, 51-21-05 AND 51-21-02.SDR R61A201403280455Scavenge Tube · corrodedDURING HEAVY CHECK, RT WING TUBE SCAVENGE AND COUPLING HAVE FLANGE DEGRADATION. MX R & R TUBE SCAVENGE AND COUPLING IAW AMM 20-10-13.SDR R61A201403280454Scavenge Tube · corrodedDURING HEAVY CHECK, RT WING TUBE SCAVENGE, AND COUPLING HAVE FLANGE DEGRADATION. MX R & TUBE SCAVENGE AND COUPLINGIAW AMM 20-10-13.SDR R61A201403280453Line · corrodedDURING HEAVY CHECK, RT WING TUBE VENT LINE, AND COUPLING FLANGE HAS DEGRADATION. MX R & R RT WING TUBE VENT LINE AND COUPLING IAW AMM 20-10-13.SDR R61A201403280450Line · corrodedDURING HEAVY CHECK, RT WING TUBE VENT LINE, AND COUPLING, HAVE FLANGE DEGRADATION. MX R & R RT WING TUBE VENT LINE AND COUPLING IAW AMM 20-10-13.SDR R61A201403270488Clamp · corrodedDURING HEAVY CHECK, LT WING FUEL TUBE ASSY CLAMPS, UNDER PANEL 521AB IS CORRODED. MX R & R LT WING FUEL TUBE CLAMPS IAW AMM 20-10-13.SDR R61A201403270487Fuel Line · corrodedDURING HEAVY CHECK, LT WING FUEL TUBE UNDER PANEL 521BB IS CORRODED. MX R & R LT WING FUEL TUBE IAW AMM 20-10-13.SDR R61A201403270486Fuel Line · corrodedWHILE IN HEAVY CHECK, LT WING FUEL TUBE UNDER PANEL 521BB IS CORRODED. MX R & R LT WING FUEL TUBE IAW AMM 20-10-13.SDR R61A201403270485Fuel Line · corrodedDURING HEAVY CHECK, LT WING FUEL TUBE AND COUPLING UNDER PANEL 521AB IS CORRODED. MX R & R LT WING FUEL TUBE AND COUPLING IAW AMM 20-10-13, TUBE.SDR R61A201403270484Fuel Line · corrodedDURING HEAVY CHECK, LT WING FUEL TUBE AND COUPLING UNDER PANEL 521BB IS CORRODED. MAINTENANCE R & R LT WING FUEL TUBE AND COUPLING IAW AMM 20-10-13.
Back to N131HQ