Embraer EMB-145XR
Service difficulty reports · 9,191
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'EMB145XR' 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 aircraft_model_key = 'EMB145XR' 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 JJBA2020082512024Skin · crackedRT OUTBOARD LEADING EDGE CRACKED AT #7 & #8 VORTILON. R&R WING LEADING EDGE RT 3. OPERATIONS CHECK SATISFACTORY.SDR JJBA202008142007Bulb · inoperativeSIDE-HINGED SERVICE DOOR EMERGENCY LIGHT BULB INOP. R/R SIDE-HINGED SERVICE DOOR EMERGENCY LIGHT ASSY. OPS CHECK SAT.SDR JJBA20200812006Duct · blownBLEED 1 LEAK MESSAGE ON EICAS. PERFORMED OPS CHECK OF THE DISTRIBUTION SYSTEM. OPS CHECK FAILED. PERFORMED GVI OF #1 AND #2 PACKS, FOUND BLOWN DUCT ON THE #2 PACK. NEW DUCT AND CLAMP REQUIRED. R&R FWD UPPER COUPLING ON #2 DUEL TEMP CONTROL VALVE. OPS CHECK SATSDR ASOA2020081084021Battery Pack · dischargedFLIGHT 4087, DURING MAINTENANCE INSPECTION THE EMERGENCY LIGHTS AT THE FA SEAT AND EMERGENCY EXIT WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT BATTERY PACKS, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WSDR ASOA2020081084020Battery Pack · dischargedFLIGHT 4087, DURING MAINTENANCE INSPECTION THE EMERGENCY LIGHTS AT THE FA SEAT AND EMERGENCY EXIT WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFFECTED EMERGENCY LIGHT BATTERY PACKS, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WSDR JJBA202008107005Skin · crackedCRACK IN RH WING LEADING EDGE #3 SKIN AT OUTBD VORTILON MOUNT POINT. REMOVED VORTILON AND FOUND CRACK TO BE APPROX 3/4" LONG EMANATING FROM BLEED HOLE. UPON REMOVAL OF LEADING EDGE, FOUND THE RETAINING ANGLE OF SPLICE BETWEEN LEADING EDGE 2 AND 3 TO BE WORN. RSDR ASOA202008107047Bulb · burned outCREW REPORTED MID CABIN OVERHEAD EMERGENCY LIGHT BURNED OUT. MAINTENANCE REPLACED MID CABIN OVERHEAD EMERGENCY LIGHT BULB. OPERATIONAL CHECKS WERE GOODSDR JJBA20200807004Skin · crackedSUSPECTED CRACKS ON RH L/E III COMING FROM OUTBOARD TWO VORTILONS AND EXTENDING UPWARD. R&R #3 RH WING LEADING EDGE. OPS CHECK LEAK CHECK SAT AT THIS TIMESDR JJBA202008076003Battery Pack · inoperativeRH FWD EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R RH FWD EMERGENCY LAMP. OPS CHECK FAILED. R&R #2 BATTERY. OPS CHECK SAT.SDR JJBA202008041001Strut · misrepairedLH MLG MAIN SIDE STRUT LOWER BEARING INSTALLED BACKWARD. REMOVED AND REPLACED LH MLG LOWER MAIN SIDE STRUT.SDR JJBA202008041002Bushing · dislodgedFOUND RH ML SIDE STRUT LOWER JOINT BUSHING COMING OUT. R*R RH SIDE LOWER AND JACKED AIRCRAFT. GEAR SWUNG 3 TIMES, ALL WERE SUCCESSFUL. NO OTHER DEFECTS NOTED.SDR JJBA2020080372005Flapper Valve · damagedATC REPORTED FUEL OR SMOKE COMING FROM RH WING 1/4 - 1/3 FROM WING TIP ON TAKEOFF JUST AFTER ROTATION. FOUND FLAPPER VALVE AT RIB 19 TORN/DAMAGE. R&R FLAPPER VALVE. PERFORMED FLAP VALVE OPERATION CHECK. OPS CHECK SAT. REINSTALLED FUEL TANK ACCESS PANEL. LEAK CSDR JJBA202008042006Fire Detector · inoperativeEICAS MESSAGE E2 FIRE DETECTION FAIL. R&R FIRE DETECTOR LOOP (ENGINE #2). OPS CHECK CARRIED OUT. FOUND SATISFACTORY. NO OTHER DEFECTS NOTED.SDR JJBA202007297004Inverter · inoperativeEMERGENCY LIGHT INOPERATIVE ABOVE SERVICE DOOR. R&R INVERTER #2. OPS CHECK SAT.SDR JJBA202007275003Unknown · odorSTRONG RUBBER BURNING SMELL THROUGH CABIN AND COCKPIT AROUND 24,000 FEET FOR ABOUT 2 MINUTES. PERFORMED GVI OF #1 AND #2 PACK AREA, PRECOOLER AND INTERIOR OF CABIN AND COCKPIT WHILE APU OFF. NO DEFECTS NOTED. TROUBLESHOT ABNORMAL SMELL. NO RUBBER BURNING SMELLSDR JJBA2020072218002Lamp · inoperativeRH OVERWING EMERGENCY LIGHT INOPERATIVE. R & R THE OVERWING EMERGENCY LIGHT LAMP. OPS CHECKED SAT.SDR ASOA2020071304016Display · inoperativeIAH - FLIGHT 3980, THE CREW REPORTED PFD#1 FAIL "SMOKED SMELL". THE AIRCRAFT LANDED AT IAH WITHOUT INCIDENT. MAINTENANCE REMOVED AND REPLACED PFD#1, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR JJBA2020071309001Sensor · malfunctionedNR 2 HIGH OIL TEMP INDICATION MAX TEMP NOTED 171 / PERFORMED PRECAUTIONARY ENGINE SHUT DOWN. NO ABNORMAL OIL QUANTITY, PRESSURE, OR ITT. NO EMERGENCY DECLARED, NO INDICATION OF FIRE @ APPROX 16000 FT, THROTTLE AT THE ECLIMB AFTER ENGINE SHUT DOWN TEMP RETURNESDR JJBA202006297007Battery Pack · inoperativeRH FWD EXTERNAL LIGHT INOPERATIVE. R&R EMERGENCY LIGHT LAMP. OPS CHECK FAILED. ALSO, FOUND MULTIPLE INTERNAL EMERGENCY SIGNS IN GALLEY AREA TO BE INOPERATIVE AS WELL. TROUBLESHOT TO #2 EMERGENCY BATTERY PACK. R&R #2 BATTERY PACK. OPS CHECK SAT.SDR JJBA202006242006Electronic Unit · inoperativeLG AIR GROUND FAIL EICAS MESSAGE IMMEDIATELY AFTER TAKE OFF. ADJUST NLG TORQUE LINK TARGET. PERFORM GEAR SWINGS FAIL. TROUBLESHOT TO LGEU. R&R LGEU AND GEAR SWINGS 5 TIMES. OPS CHECK SAT. NO OTHER DEFECTS NOTED.SDR JJBA202006187005Placard · mislocatedEMERGENCY FLOOR SAF-T-GLO EXIT PLACARDS AT ROW 21A AND 21CD ARE WRONG, NEEDS TO BE EXCHANGED WITH ROW 24A AND 24CD. RE-POSITIONED EXIT PLACARDS ON FLOOR PATH STRIPS.SDR JJBA202006186004Lamp · inoperativeMULTIPLE LIGHTS INOPERATIVE ON FLIGHT GUIDANCE CONTROLLER BUTTONS. R&R INOPERATIVE LAMPS ON FLIGHT GUIDANCE CONTROLLER. OPS CHECK SATSDR ASOA202006147038Skin · corrodedTYS A/C IS HERE FOR A REPAIR OF A DOUBLER AT FRAME 4 AND STRINGERS 9L TO 11L DUE TO MORE DAMAGE FOUND. MAINTENANCE CUT OUT THE DAMAGE AREAS, FABRICATED FILLERS AND A NEW DOUBLER, INSTALLED REPAIR PARTS IAW ETD 2020-145-019642. ALLODINED,PRIMED AND PAINTED IAW SDR JJBA202006054003Charger · inoperativeFORWARD EXTERNAL EMERGENCY LIGHTS FWD OF WING INOPERATIVE. REMOVED AND REPLACED NR 2 BATTERY CHARGER ASSEMBLY. REMOVED AND REPLACED BURNT OUT BULBS. OPS CHECK SAT.SDR JJBA202006052002Fastener · looseRIGHT PASSENGER CABIN, ESCAPE HATCH DOOR TOOK SEVERAL MINUTES TO REMOVE DOOR TO FOM. FOUND FASTENERS THAT ATTACH SIDEWALL PANEL TO EMERGENCY EXIT DOOR FRAME LOOSE CAUSING DOOR TO JAM ON FASTENERS. RESECURED FASTENERS. OPS CHECK SAT.SDR JJBA202005297008Connector · disconnectedFOUR EMERGENCY LIGHTS INOPERATIVE AS FOLLOWS: ABOVE SERVICE DOOR, GALLEY CEILING, SERVICE DOOR EXTERIOR LIGHT, AND LIGHT ON WALL IN FRONT OF SEAT 3CD. FOUND CONNECTOR CONNECTING TO GALLEY CEILING PANEL 234ARC TO BE DISCONNECTED. RECONNECTED. OPS CHECK SATISFSDR JJBA202005263007Light · inoperativeMAIN CABIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R MAIN CABIN DOOR EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR ASOA2020052624015Battery Pack · dischargedIAH - FLIGHT 4249, DURING MAINTENANCE INSPECTION THE EXIT ROW EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE #3 EMERGENCY LIGHT BATTERY PACK, OPERATIONALLY TESTED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETSDR JJBA20200515003Inverter · inoperativeEMERGENCY EXIT IDENTIFIER LIGHT, LOCATED ON LH AFT IS INOPERATIVE. R&R LH FWD EMERGENCY HATCH IDENTIFIER EMERGENCY LIGHT. OPS CHECK FAILED. R&R #5 EMERGENCY LIGHT DC/AC INVERTER. OPS CHECK SAT.SDR JJBA2020052010006O-Ring · damagedSMELL OF HYD OR FUEL DURING TAKE OFF. SMELL WENT AWAY AFTER APU SHUTDOWN AND BLEEDS TRANSFERRED TO ENGINES. PERFORMED T/O POWER RUNS IN THESE SCENARIOS - APU OFF, BOTH ENGINES AT T/O POWER, BLEED 2 OPEN, BLEED 1 CLOSED AND PACK 1 ON. ONLY SMELL FROM THIS SET SDR JJBA2020051108002Pump · contaminatedINVESTIGATE SOURCE OF FIBROUS DEBRIS IN RH ENGINE FUEL FILTER. FOUND PIECE OF CLOTH STUCK IN EJECTOR PUMP, NO OTHER DEBRIS. REMOVED, CLEANED AND REINSTALLED PUMP.SDR JJBA202005205005Unknown · odorSTRONG FUEL SMELL ON TAKE-OFF WITH APU RUNNING. INSPECTED ALL FUEL NOZZLES, FUEL NOZZLE GASKETS, NOZZLE MANIFOLD, FUEL CONTROL, FUEL LINES, FUEL HOSES, AND COMBUSTOR DRAIN LINE WITH APU RUNNING. OBSERVED NO LEAKAGE OR EVIDENCE OF LEAKAGE BEFORE, DURING, OR AFTSDR JJBA20220503014None · noneAT CF I EXT, DENT FOUND ON LH SIDE SKIN BTW FR 19 - FR 20 AND BTW STR 11L-12L. AT CFI EXT, BTW FR 19-20 BTW STR 11L-12L, SKIN REPAIREDSDR JJBA202005203004Fuel Control · malfunctionedSMELL OF FUEL ON TAKE OFF WITH APU RUNNING. R&R APU FUEL CONTROL. HIGH POWER ENGINE RUNS OPS CHECK SAT. NO FUEL SMELL NOTED AT THIS TIME.SDR JJBA202005041001Battery · dischargedBOTH OVER WING EMERGENCY LIGHTS ARE INOPERATIVE. R&R EMERGENCY LIGHT BATTERY #4. OPS CHECK SAT.SDR JJBA202004286006Light · inoperativeLH EMERGENCY EXIT LIGHT INOPERATIVE (UPPER LEFT). R&R LH INTERIOR UPPER LEFT EMERGENCY EXIT LIGHT. OPS CHECK SAT.SDR JJBA202004283005Battery Pack · dischargedEMERGENCY LIGHTS AT MAIN DOOR, MAIN ENTRANCE CEILING PANEL, COCK PIT FLOOR, GALLEY ISLE CEILING PANEL AND FWD WING-TO-FUSE, AND EMERGENCY EXIT SIGNS AT COCKPIT BULKHEAD, COCKPIT STEP, AND GALLEY CENTER AISLE CEILING INOP (8 LIGHTS TOTAL). R&R #1 EMERGENCY LIGHSDR ASOA202004164013Acm · frozenIAH - DURING FLIGHT THE CREW REPORTED THAT THEY SMELLED BURNING / SMOKE. RAN QRH TURNED OFF THE RECIRC FAN AND THE SMELL DISSIPATED. THE AIRCRTAFT LANDED AT IAH WITHOUT INCIDENT WHERE MAINTENANCE REMOVED AND REPLACED THE NUMBER 1 ACM, OPERATIONALLY TESTED WITHSDR JJBA202004109004Light · inoperativeLH FWD OF WING EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R LH FWD OF WING EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR JJBA202004109003Light · inoperativeSIDE HINGED MAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R SIDE HINGED MAIN DOOR EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR ASOA2020040964013Unknown · malfunctionedDEN - FLIGHT 3938 THE EMERGENCY LIGHT STRIP AT SEAT 3A WOULD NOT GLOW. THE LIGHT STRIP WAS PLACED ON MEL 33-50-01, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE. ON 04/07 THE IAH MAINTENANCE INSPECTED THE AIRCRAFT, OPERATIONALLY TESTED THE EMERGENCY LIGHSDR JJBA20200406002Battery Pack · dischargedEMERGENCY LIGHT ABOVE FWD FA SEAT INOPERATIVE. R&R EMERGENCY LIGHT BATTERY PACK IN POSITION #1. OPS CHECK SAT.SDR ASOA2020040634012Acm · defectiveXNA - FLIGHT 3951 THE CREW REPORTED AN ELECTRICAL SMELL IN THE COCKPIT ONLY WITH PACK ONE (1) ON, AND THAT THE SMELL DISSIPATED WHEN PACK ONE (1 WAS TURNED OFF. THE AIRCRAFT WAS INSPECTED AND PACK ONE (1) WAS PLACED ON MEL 21-51-00-3. ON 04/04/20 THE AIRCRAFT SDR JJBA20200403001Placard · inoperativeSERVICE DOOR FWD EXIT IDENTIFIER EMERGENCY LIGHT INOPERATIVE. R&R SERVICE DOOR FWD EMERGENCY ILLUMINATING PLACARD. OPS CHECK SATSDR ASOA202003314008Connector · detachedIAH - FLIGHT 4328, DURING MX INSPECTION THE LEFT HAND EXTERIOR FWD EMERGENCY LIGHT WAS FOUYND TO BE INOPERATIVE. MAINTENANCE REATTACHED CANNON PLUG P8561, OPERATIONALLY TESTED WITH NO DEFECTS AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA202003297031Door Sill · corrodedCORROSION ON LH FLOOR SILL AT FRAME 24-35. REMOVED AND REPLACED FLOOR SILLS AT FRAME 24-29 AND 29-35 IAW EMB 145 SRM 51-40-02.SDR ASOA202003297030Door Sill · corrodedRH FLOOR SILL CORRODED FROM FRAME 29-35. REMOVED AND REPLACED RH FLOOR SILL FRAME 29-35 IAW EMB SRM 51-40-02.SDR JJBA202003265020Doubler · corrodedCORROSION - COCKPIT FLOOR DOUBLER Y=+293.0 FR10/11. REMOVED AND REPLACED COCKPIT FLOOR DOUBLER AT Y= +293.0 AND 3EA. REPAIR DOUBLERSDR JJBA202003265019Gusset · corrodedCORROSION - COCKPIT FLOOR DOUBLER Y=-607 FR8/11. REMOVED AND REPLACED LH OB COCKPIT GUSSET FR8-11.SDR JJBA202003265014Support · corrodedRH WING - O/B LWR SHROUD, O/B BOTH CENTERS AND I/B SPRING SUPPORTS HAVE CORROSION. REMOVED AND REPLACED RH WING - OB LWR SHROUD, OB BOTH CENTERS AND I/B SPRING SUPPORTS.
Back to Embraer EMB-145XR