N114HQ
Service difficulty reports · 89
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 = 'N114HQ' 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 = 'N114HQ' 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 R61A201402160282Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 81 BETWEEN S27-28R CORRODED. MX R & R SHEAR TIE IAW 170 51-41-00.SDR R61A201402160281Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 85 BETWEEN S27-28R CORRODED. MX R & R SHEAR TIE IAW 51-40-02, 51-40-00.SDR R61A201402160279Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 83 BETWEEN S27-28R CORRODED. MX R & R SHEAR TIE IAW SRM 51-40-02, & 51-41-00.SDR R61A201402160271Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 82 BETWEEN STRINGERS 27-28R CORRODED. MX R & R SHEAR TIE IAW SRM 51-41-00,51-40-02, 51-41-01.SDR R61A201402160270Shear Tie · corrodedDURING HEAVY CHECK, SHEAR TIE AT FRAME 86 BETWEEN STRINGERS 27-28R IS CORRODED. MX R & R SHEAR TIE IAW SRM 51-41-00, 51-41-02,51-41-01.SDR R61A201402130273Tube · corrodedDURING HEAVY CHECK, LT WING TUBE ASSY CORRODED AT ATTACH CLAMP. MX R & TUBE ASSY IAW AMM 20-10-13.SDR R61A201402120275Rib · crackedDURING HEAVY CHECK, A CRACK AT UPPER EDGE OF RIB 4 ON RT HORIZONTAL STAB L/E WAS FOUND. MX CUT OUT DAMAGE AND INSTALLED FILLER AND DOUBLER REPAIR IAW ETD 2014-170-012855.SDR R61A201402120274Doubler · corrodedDURING HEAVY CHECK, WASTE SERVICE BOX UPPER BOX FWD DOUBLER FOUND CORRODED AND DELAMINATED. MX COMPLETED SB 170-53-00955.SDR R61A201402120272Bracket · corrodedDURING HEAVY, FWD WINDSCREEN INBD MOUNTING HOLE HAS CORROSION. MX REMOVED OLD MOUNTING BRACKET, FABRICATED NEW AND INSTALLED IAW SRM 53-16-16,51-40-02.SDR R61A201402100280Rib · crackedDURING HEAVY CHECK, LT HORIZONTAL L/E RIB 4 CRACKED. REPAIRED THE CRACKED RIB IAW ETD 2014-170-012077.SDR R61A201402100276Nut · corrodedDURING HEAVY CHECK, RT WING FLAP TRACK SUPPORT FWD MOUNTING NUT FOUND CORRODED. MX R & R MOUNTING NUT IAW AMM 57-24-21.SDR R61A201402090251Pan · crackedDURING HEAVY CHECK, SEAT PAN ON ROW 7C FOUND CRACKED. MX R & R SEAT PAN IAW SRM 51-42-00.SDR R61A201306220553Attach Bracket · looseCREW REPORTED THAT THE BRACKET SECURING THE MEGAPHONE IS LOOSE. MX SECURED BRACKET IAW AMM AND OPS CHECKED GOOD.SDR R61A201306140541Bracket · brokenCREW REPORTED THE AFT MEGAPHONE BRACKET BROKEN. MX SECURED MEGAPHONE TO MOUNT IAW AMM AND OPS CHECKED GOOD.SDR R61A201205100285Door · out of adjustCREW REPORTED L-2 DOOR WAS DIFFICULT TO ARM/DISARM HANDLE WAS DIFFICULT TO OPERATE. MAINTENANCE PERFORMED ADJUSTMENT AND TEST OF L-2 DOOR PER EMB AMM, OPS CHECK GOOD.SDR R61A20120227136Control Lever · faultyCREW REPORTED IN CLIMB THAT THEY TRIED TO RETRACT THE LG AND THE LEVER WOULDN'T MOVE. CREW DECLARED AN EMERGENCY AND RETURNED TO FIELD, AND LANDED WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED THE LG LEVER PER EMB AMM, OPS CHECK GOOD.SDR R61A201202060084Unknown · odorWHILE EN ROUTE, CREW NOTICED A ELECTRICAL SMELL IN THE COCKPIT. THE CREW DECIDED TO DIVERT TO IAD. MAINTENANCE WAS NOTIFIED AND THEY PERFORMED OPERATION CHECKS TRYING TO DUPLICATE THE ODOR NOTICED BY THE CREW. MAINTENANCE WAS NOT ABLE TO DUPLICATE THE ODOR SDR R61A20120067Rod · defectiveL1 DOOR WAS REPORTED HARD TO OPEN. MAINTENANCE REPLACED BOTH L1 DOOR COMPENSATOR RODS PER EMB AMM, OPS CHECK GOOD.SDR R61A20110412Shaft · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK MAINTENANCE FOUND SHAFT ON L1 DOOR HANDLE CORRODED. MAINTENANCE REMOVED AND REPLACED SHAFT ON L1 DOOR HANDLE IAW EMB 175 CMM 52-11-22. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110411Extension · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LT AFT SEAT TRACK EXTENSION CORRODED. MAINTENANCE REMOVED AND REPLACED THE LT AFT SEAT TRACK EXTENSION IAW EMB 175 SRM 51-40-02, 51-42-01, AND 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110410Extension · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RT AFT SEAT TRACK EXTENSION CORRODED. MAINTENANCE REMOVED AND REPLACED RT AFT SEAT TRACK EXTENSION IAW EMB 175 SRM 51-40-02, 51-42-01, 51-43-03. AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110409Shaft · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK MAINTENANCE FOUND SHAFT CORRODED ON R2 SERVICE DOOR HANDLE. MAINTENANCE REMOVED AND REPLACED SHAFT ON R2 AFT SERVICE DOOR HANDLE IAW EMB 175 CMM 52-42-22. AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110406Service Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LAVATORY SERVICE BOX HAS SIGNS OF CORROSION. MAINTENANCE REMOVED AND REPLACED LAVATORY SERVICE BOX IAW EMB 175 SRM 51-43-02. AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110405Damper · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE R1 DOOR DAMPER HAS CORROSION ON SURFACE. MAINTENACE REMOVED AND REPLACED DAMPER FOR R1 DOOR IAW EMB 175 AMM 52-41-27. AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110404Service Panel · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON THE WASTE BOX ACCESS PANEL AT HINGE. MAINTENANCE REMOVED AND REPLACED THE WASTE BOX ACCESS PANEL ASSEMBLY IAW EMB 175 AMM 20-10-01. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HESDR R61A20110403Support · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON THE FORWARD LAV THRESHOLD SUPPORT. MAINTENANCE REMOVED AND REPLACED THE FORWARD LAV THRESHOLD SUPPORT IAW EMB 175 AMM 25-41-02. AIRCRAFT IS CURRENTLY STILL OUT OF SERVICE FOR HEAVY SDR R61A20110413Pad · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE COPPER PADS ON FWD AND AFT GUIDE RAMPS CORRODED R1 DOOR. MAINTENANCE REMOVED AND REPLACED THE COPPER GUIDE PADS ON THE R1 DOOR FWD AND AFT GUIDE RAMPS IAW EMB 175 AMM 53-10-25. THE AIRCRAFT IS OUT OF SESDR R61A20110402Fitting · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON THE SHEAR CLIP AT FRAME 88 BETWEEN STR 27R & 28R. MAINTENANCE REMOVED AND REPLACED THE SHEAR CLIP AT FRAME 88 BETWEEN STR 27R & 28R IAW EMB 170/175 SRM 51-41-01 & 51-40-02. AIRCRAFSDR R61A20110401Doubler · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON THE FWD AND AFT DOUBLERS ON THE LAV DUMP BOX. MAINTENANCE REMOVED AND REPLACED THE FWD AND AFT DOUBLERS ON THE LAV DUMP BOX IAW EMB 175 SRM 51-43-02 & 51-40-02. REF: P/N'S 170-86657SDR R61A20110408Shear Plate · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE MIDDLE SHEAR PLATE CORRODED AT FRAME 86 AND 87 UNDER AFT GALLEY. MAINTENANCE REMOVED AND REPLACED THE MIDDLE SHEAR PLATE UNDER THE AFT GALLEY AT FRAME 86 AND 87 IAW EMB 175 SRM 51-42-01. THE AIRCRAFT ISSDR R61A20110407Shear Web · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RT SHEAR WEB BETWEEN FLOOR FRAME 87 AND 88 CORRODED. MAINTENANCE REMOVED AND REPLACED RIGHT SHEAR WEB PANEL BETWEEN FR 87 AND 88 IAW EMB SRM 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20110400Pad · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON ALL 4 COPPER PADS ON GUIDE RAMPS OF FORWARD PAX DOOR. MAINTENANCE REMOVED AND REPLACED ALL 4 COPPER RAMP PADS ON FORWARD PAX DOOR IAW EMB 175 AMM 53-10-21. AIRCRAFT IS CURRENTLY STISDR R61A20110399Pad · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON COPPER PADS ON BOTH FWD AND AFT GUIDE RAMPS ON AFT SERVICE DOOR. MAINTENANCE REMOVED AND REPLACED ALL 4 COPPER RAMP PADS ON THE AFT SERVICE DOOR IAW EMB 175 AMM 53-23-25. AIRCRAFT ISDR R61A20110397Screw · corroded*** WHILE AIRCRAFT WAS IN FOR HEAVY CHECK *** LEVEL 2 CORROSION WAS FOUND ON THE LT WING NR 1 SLAT SEAL HARDWARE. MAINTENANCE REMOVED AND REPLACED THE NR 1 SLAT SEAL HARDWARE IAW EMB 170/175 AMM 57-41-09. REF: SCREW P/N NAS1102-06-5 AND NUT P/N MS21042-06. SDR R61A20110307Door · out of sequenceL1 DOOR WOULD NOT CLOSE. MAINTENANCE CYCLED DOOR AND RE-SEQUENCED PER EMB AMM, OPS CHECK GOOD.SDR R61A20100396Slide · inoperativeMX REPORTED L-2 EMERGENCY EVACUATION SLIDE INOP, AND FOUND THE BUSTLE RETAINING PIN BEING AT FAULT. MX R & R L-2 EMERGENCY EVACUATION SLIDE IAW AMM.SDR R61A20100394Battery · dischargedCREW REPORTED OVERHEAD CABIN EMERGENCY LIGHT INOP. MAINTENANCE REMOVED AND REPLACED THE LT AFT BATTERY POWER SUPPLY PER EMB AMM.SDR R61A20100166Sensor · faultyCREW REPORTED A SLAT FAIL ON LANDING, DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT INTO YUL WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED LT SLAT 3/4 HARNESS AND LT OUTBOARD SKEW SENSOR PER EMB AMM, OPS CHECK GOOD.SDR R61A20090083Structure · dentedACCOMPLISHED MAJOR REPAIR. DAMAGE AREA DENTED 2.7MM DEEP, 65MM X 55MM WITH LIGHT CREASING AT LOWEST PORTION OF DENT IN TWO LOCATIONS - NO DAMAGE NOTED TO PAINT FINISH. AREA IS LOCATED AT FWD FUSELAGE STC. 17L/15L, FRAME 10. REPAIRED PER EMB ETD2009-170/0913
Back to N114HQ