N127HQ
Service difficulty reports · 116
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 = 'N127HQ' 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 = 'N127HQ' 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 R61A201602110142Seal Rest · corrodedDURING HEAVY CHECK, AFT CARGO DOOR AFT SEAL REST IS CORRODED. MAINTENANCE R & R AFT CARGO DOOR AFT SEAL REST IAW SRM 51-40-02.SDR R61A201602110141Seal Rest · corrodedDURING HEAVY CHECK, AFT CARGO DOOR, FWD CORNER SEAL REST IS CORRODED. MAINTENANCE R & R AFT CARGO DOOR, FWD CORNER SEAL REST IAW SRM 51-40-02, PN 170-85492-403.SDR R61A201602110093Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER INTERNAL RIB 11A BOTH UPPER FLANGES FWD, AFT OF STRINGER 02 ARE CRACKED. MX REPAIRED IAW ETD 2016-170-013970.SDR R61A201602100126Support Bracket · corrodedDURING HEAVY CHECK, WATER LINE SUPPORT BRACKET IN LT FWD BELLY BELOW L1 DOOR IS CRACKED. MAINTENANCE R & R SUPPORT BRACKET IN LT FWD BELLY BELOW L1 DOOR. PN 170-16809-403, SUPPORT.SDR R61A201602080143Beam · corrodedDURING HEAVY CHECK, BEAM JUST BELOW L1 DOOR SILL COVER IS CORRODED. MAINTENANCE R & R BEAM JUST BELOW L1 DOOR SILL COVER IAW AMM 51-40-02, 53-10-22.SDR R61A201602080123Beam · corrodedDURING HEAVY CHECK, L1 DOOR SEAL PLATE BY FWD AND AFT GIRT BAR FLOOR LOCKS AND IN MIDDLE OF PLATE IS CORRODED. MX R & R L1 LOWER BEAM IAW SRM 51-43-02, 51-43-03. PN 170-03719-005, LOWER BEAM.SDR R61A201602070128Floorbeam · corrodedDURING HEAVY CHECK, FLOORBEAM DOUBLER AT L1 DOOR IS CORRODED. MAINTENANCE R & R FLOORBEAM DOUBLER AT L1 DOOR IAW SRM 51-41-02, 51-43-02. PN 170-03275-005, LT SILL.SDR R61A201602070127Shear Web · corrodedDURING HEAVY CHECK, WAS REPORTED THAT SHEAR WEB AT FRAME 16 BETWEEN 28L-26L IS CORRODED. MX R & R SHEAR WEB IAW SRM 51-41-02, PN 170-12113-001 DOUBLER FLOOR.SDR R61A201602070094Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL STABILIZER RIB 12 IS CRACKED. MAINTENANCE REPAIRED. RT HORIZONTAL STABILIZER RIB 12 IAW ETD 2016-170-013970.SDR R61A201602060131Bolt · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR SLIDE MOUNTING HARDWARE IS CORRODED. MAINTENANCE R & R AFT PASSENGER DOOR SLIDE MOUNTING HARDWARE IAW AMM 20-10-01, PN NAS6604D11, BOLT.SDR R61A201602060130Nut · corrodedDURING HEAVY CHECK, AFT R2 DOOR LOWER EMERGENCY SLIDE MOUNTING HARDWARE IS CORRODED. MAINTENANCE R & R AFT R2 DOOR LOWER EMERGENCY SLIDE MOUNTING HARDWARE IAW AMM 20-10-01, PN MS14144-4, NUT.SDR R61A201602060129Bolt · corrodedDURING HEAVY CHECK, WAS REPORTED THAT FWD PASSENGER DOOR LOWER EMERGENCY SLIDE HARDWARE IS CORRODED. MX R & R FWD PASSENGER DOOR LOWER EMERGENCY SLIDE HARDWARE IAW AMM 52-10-00. PN NAS6604D11, BOLT.SDR R61A201602050132Screw · corrodedDURING HEAVY CHECK, AFT SERVICE DOOR STOP 2ND FROM BOTTOM FWD SIDE HARDWARE CORRODED. MAINTENANCE R & R AFT SERVICE DOOR STOP 2ND FROM BOTTOM FWD SIDE HARDWARE IAW AMM 52-43-23, PN 170-68172-001, SCREW.SDR R61A201602050115Bushing · corrodedDURING HEAVY CHECK, NR 3 SPOILER TO ACTUATOR ATTACH POINT BUSHING ON SPOILER FRAME IS CORRODED. MAINTENANCE R & R NR 3 SPOILER TO ACTUATOR ATTACH POINT BUSHING ON SPOILER FRAME IAW AMM 20-10-08. PN 170-34140-003, BUSHING.SDR R61A201602040137Doubler · crackedDURING HEAVY CHECK, PREVIOUS REPAIR BELOW LT AILERON TOWER REPAIR IS CRACKED. MAINTENANCE R & R PREVIOUS REPAIR BELOW LT AILERON TOWER REPAIR IAW SRM 51-41-01, PN RAH53061 DOUBLER.SDR R61A201602040135Bolt · corrodedDURING HEAVY CHECK, WAS REPORTED THAT LT WING SPOILER 1 WING TO ACTUATOR MOUNTING HARDWARE IS CORRODED. MAINTENANCE R & R LT WING, SPOILER 1 WING TO ACTUATOR MOUNTING HARDWARE IAW AMM 27-62-01, PN NAS6212-31D BOLT.SDR R61A201602040134Bolt · corrodedDURING HEAVY CHECK, WAS REPORTED THAT LT WING SPOILERS 3 AND 4 MOUNTING HARDWARE IS CORRODED. MX R & R LT WING SPOILERS 3 AND 4 MOUNTING HARDWARE IAW AMM 27-65-01. PN NAS6212-31D, BOLT.SDR R61A201602040133Access Panel · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUT OUT LOWER SILL ACCESS PLATE STRIP IS CORRODED. MAINTENANCE R & R FWD CARGO DOOR CUT OUT LOWER SILL ACCESS PLATE STRIP IAW SRM 51-10-02, PN 170-67451-001, PLATE STRIP.SDR R61A201602040116Nut · corrodedDURING HEAVY CHECK LT INBD FLAP TRACK CARRIAGE ASSY FWD MOUNTING HARDWARE IS CORRODED. MAINTENANCE R & R LT INBD FLAP TRACK CARRIAGE ASSY FWD MOUNTING HARDWARE IAW AMM 57-54-21. PN 170-14217-001, HARDWARE.SDR R61A201602030117Support · crackedDURING HEAVY CHECK, LT WHEEL WELL FWD BULKHEAD UPPER ATTACH FLANGE AT HI-LOC CRACKED. MAINTENANCE R & R SUPPORT ANGLE IN LT WHEEL WELL IAW SRM 51-41-02. PN, 170-30709-001, SUPPORT.SDR R61A201601270086Stringer · corrodedDURING HEAVY CHECK STRINGER 20L BETWEEN FRAMES 83-84 IS CORRODED. MAINTENANCE REPAIRED BY INSTALLING DOUBLER IAW ETD 2016-170-010463.SDR R61A201601270085Stringer · corrodedDURING HEAVY CHECK STRINGER 20L BETWEEN FRAMES 83-84 FOUND CORRODED. MAINTENANCE REPAIRED IAW ETD 2016-170-010463.SDR R61A201508270562Slide · looseDURING MID C-CHECK, MAINTENANCE FOUND R2 DOOR EVAC SLIDE HAD LACING COMING LOOSE. MAINTENANCE R & R R2 DOOR EVAC SLIDE IAW AMM AND OPS CHECKED GOOD.SDR R61A201506250385Flashlight · inoperativeCREW REPORTED THAT THE CABIN FLASHLIGHT WAS NOT WORKING. MAINTENANCE R & R CABIN FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201506180375Bracket · brokenCREW REPORTED THAT THE AFT MEGAPHONE BRACKET WAS BROKEN. MAINTENANCE R & R AFT MEGAPHONE BRACKET IAW AMM.SDR R61A201501230050Light · looseCREW REPORTED THAT THE EMERGENCY LIGHT AT ROW 1 WAS LOOSE. MAINTENANCE SECURED THE LIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201412171241Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE FLASHLIGHT AMM AND OPS CHECKED GOOD.SDR R61A201412131234Battery Pack · dischargedCREW REPORTED THAT THE F/O FLASHLIGHT WAS VERY DIM. MAINTENANCE R & R THE FLASHLIGHT BATTERIES IAW AMM AND OPS CHECKED GOOD.SDR R61A201411221199Skin · damagedDAMAGE ON LT SIDE OF CENTER FUSELAGE BELOW L3 PAX WINDOW BETWEEN FRAMES 24-25 STRINGER S18-19L. REPAIRED THE DAMAGE IAW SRM 53-21-01.SDR R61A201411111171Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS NOT CHARGING.SDR R61A201406050722Flashlight · weakCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS DIM.SDR R61A201405170666Nut Plate · damagedDURING HEAVY CHECK, R1 DOOR EMERGENCY EVACUATION SLIDE HAS A DAMAGED ISOLATOR NUT PLATE. MX R & R R1 DOOR EMERGENCY EVACUATION SLIDE DAMAGED ISOLATOR NUT PLATE IAW SRM 51-40-02,51-41-01, PN J-23676-1, ISOLATOR.SDR R61A201405140667Rod End · corrodedDURING HEAVY CHECK, ADJUSTABLE ROD END FOUND CORRODED. MAINTENANCE R & R ADJUSTABLE ROD END IAW AMM 27-41-03,.SDR R61A201405130642Seal Rest · corrodedDURING HEAVY CHECK, FWD CARGO DOOR CUTOUT LOWER AFT SEAL REST CORNER IS CORRODED. MX R & R FWD CARGO DOOR CUTOUT LOWER AFT SEAL REST CORNER IAW SRM 51-40-02, AMM 20-10-01 FILLET SEALED IAW SRM 51-21-02, 51-23-06, FCBS 53-21-00-006 NO CHANGE TO INSPECTION REQSDR R61A201405100655Frame · corrodedWHILE IN HEAVY CHECK WAS REPORTED THAT FRAME 88 BETWEEN STRINGERS 26R-27R AT FRAME SPLICE IS CORRODED. MX R & R FRAME 88, BETWEEN STRINGERS 16R-27R AT FRAME SPLICE IAW SRM 51-41-01,51-41-02. MAJOR REPAIR.SDR R61A201405090657Rib · crackedDURING HEAVY CHECK, TWO RT STABILIZER L/E RIBS CRACKED. MX CUT OUT CRACKS IN RIBS IAW ETD 2014-170-039169 AND FABRICATED DOUBLERS, FILLERS AND INSTALLED IAW ETD-2014-170-039169.SDR R61A201405090656Rib · crackedDURING HEAVY CHECK LT L/E ON STABILIZER HAS INBD RIB CRACKED. MX CUT OUT CRACKED SECTION FABRICATED DOUBLER AND INSTALLED IAW ETD 2014-170-039169, VP-012424-2014/652 C1-C2 FOR WORK DETAILS.SDR R61A201405080669Rod End · corrodedDURING HEAVY CHECK, HORIZONTAL STAB UPPER & LOWER ADJUSTABLE ROD ENDS FOUND CORRODED. MX R & R HORIZONTAL STAB UPPER & LOWER ADJUSTABLE ROD ENDS IAW AMM 53-30-21.SDR R61A201405070664Hinge · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX DOOR FRONT HINGE OTBD SIDE OF DOOR FOUND CORRODED. MX R & R WASTE SERVICE BOX DOOR FRONT HINGE OTBD SIDE OF DOOR IAW AMM 53-03-60. PN 170-86668-403, PANEL ACFT.SDR R61A201405070654Doubler · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX DOUBLER HAS CORROSION AROUND SEVERAL RIVETS INBD BETWEEN THE BOX AND STRINGER 28R. MX R & R DOUBLER AROUND WASTE BOX, PN 170-66931-001 DOUBLER IAW SRM 51-41-02. MAJOR REPAIR.SDR R61A201405070651Floorbeam · corrodedDURING HEAVY CHECK, FOUND NUT PLATE FITTING ON FLOORBEAM CORRODED. MX R & R NUT PLATE FITTING IAW SRM 51-43-03.SDR R61A201405070650Seat Track · corrodedDURING HEAVY CHECK, FOUND LT SEAT TRACK CORRODED. MX R & R SEAT TRACK IAW SRM 51-40-02.SDR R61A201405070646Tray · crackedDURING HEAVY CHECK, BACK UP BATTERY MOUNTING TRAY IS CRACKED. MX R & R BACK UP BATTERY MOUNTING TRAY IAW AMM 27-03-05. TRAY.SDR R61A201405070645Seat Track · corrodedDURING HEAVY CHECK, SEAT TRACK CORRODED. MX R & R SEAT TRACK IAW SRM 51-40-02, 51-43-02, 51-43-02, 51-41-01, 51-41-02.SDR R61A201405070637Support Bracket · crackedDURING HEAVY CHECK, NOSE GEAR STEERING MANIFOLD SUPPORT BRACKET INBD FORWARD RADIUS IS CRACKED. MAINTENANCE R & R NOSE GEAR STEERING MANIFOLD SUPPORT BRACKET IAW SRM 51-43-03 AND AMM 32-52-01. RESTORED TOP COAT AND FASTENERS IAW SRM 53-23-06, PN 170-10788-4SDR R61A201405060668Door Sill · corrodedDURING HEAVY CHECK, AFT PAX DOOR SILL FOUND CORRODED. MX R & R BEAM AND SUPPORT SILL IAW SRM 51-40-02, 51-43-03, 51-43-04.SDR R61A201405060665Shear Web · corrodedDURING HEAVY CHECK, RT SHEAR WEB AT FRAME 87-88 FOUND CORRODED. MX R & R RT SHEAR WEB IAW SRM 51-42-01,SDR R61A201405060652Shear Tie · corrodedDURING HEAVY CHECK WAS REPORTED THAT FRAME FORWARD OF WASTE BOX AND FRONT SIDE OF WASTE BOX IS CORRODED. MX R & R SHEAR TIE BETWEEN 27R, 26R IAW SRM 51-41-01,51-41-02. MAJOR REPAIRSDR R61A201405060649Door Sill · corrodedDURING HEAVY CHECK AFT SERVICE DOOR SILL IS CORRODED. C2 BLENDED CORRODED AREA IAW SRM 51-10-03, ETD 2014-170-038382, TASK 53-23-016-002 INTERNAL DET THRESHOLD OF 20000 FC INTERVAL OF 5157FCIS SUFFIENT AND USING INSPECTION REQUIREMENTS MPG/MRBR NR 8 THRESHOLDSDR R61A201405060644Door Sill · corrodedWHILE IN HEAVY CHECK, FWD CARGO DOOR CUTOUT FWD CORNER SILL IS CORRODED. MX R & R FWD CARGO DOOR CUTOUT FWD CORNER SILL IAW SRM 51-40-02, 51-41-01 FCBS 53-21-00-001 FOR WORK DETAILS. PN 170-66803-401, SEAL REST.
Back to N127HQ