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 JJBA20230417008Unknown · unknownSMOKE ODOR FROM APU BLEED DURING TAKE OFF. PERFORMED OPERATIONAL CHECK OF APU. COULD NOT DUPLICATE. SUSPECT SMELL WAS ENGINE EXHAUST IN BLEED.SDR JJBA20230410006Inverter · inoperativeOVERHEAD AFT EXIT SIGN AT EMERGENCY EXIT ROW INOPERATIVE. REMOVED AND REPLACED EXIT SIGN AT EMERGENCY EXIT ROW. OPS CHECK FAIL FOUND INVERTER TO BE BAD. REMOVED AND REPLACED INVERTER. OPS CHECK SAT.SDR JJBA20230410005Battery Pack · inoperativeTHREE EMERGENCY LIGHTS OUT AT EMERGENCY ROW. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AND CHASSIS ASSEMBLY. BATTERY PACK TESTS GOOD, EMERGECY LIGHTS OPS CHECK GOOD.SDR JJBA20230410004Unknown · unknown#1 EMERGENCY LIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY. OPS CHECK SATSDR JJBA20230410003Lamp · inoperativeMCD EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SATSDR JJBA20230410007Unknown · unknownFUEL SMELL THROUGH PACKS ON TAKE OFF AND APPROACH. PERFORMED RR FIM. NO ABNORMAL ODOR PRESENT AT THIS TIMESDR JJBA20230404002Unknown · unknownCRACK ALONG INTERNAL FUEL TANK DOUBLER UNDER RH WING RIB 9 FOUND CRACK TO BE MIGRATING ACROSS DOUBLER THROUGH 3 HIGH LOCK (FWD) HOLES. REMOVED HILOCK COLLARS FROM SPLICE ON OUTBD SIDE OF RIB 9 AND REMOVED FILLET SEALANT. REMOVED SPLICE BELOW RIB 9. FOUND RH WISDR JJBA20230404001Unknown · unknownALL EMERGENCY LIGHTS TURN ON THEN IMMEDIATELY OFF. REMOVED AND REPLACED FOUR EMERGENCY LIGHT BATTERIES. OPS CHECK SAT.
SDR JJBA20230404042Battery · inoperativeTHREE EMERGENCY LIGHT OUT AT EMERGENCY ROW. REMOVED AND REPLACED EMERGENCY EXIT IDENTIFIER & MARKING SIGNS ROW 18A. DURING OPS CHECK, REPLACED LIGHTS FADED DURING TEST. REMOVED AND REPLACED EMERGENCY BATTERY PACK NO 3. LIGHTS OPS CHECK GOOD.SDR JJBA20230330041Unknown · unknownMCD DIFFICULT TO UNLOCK AND OPEN. ADJUSTED MCD INTERNAL HANDLE CABLE. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIME.SDR JJBA20230330040Unknown · unknownRF1, CORROSION FOUND ON SKIN U/FLOOR RAD ALT #2 AFT INNER DOUBLER BTW FR 68-69 AND BTW STR 21L-21R. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230328030Unknown · unknownMAIN CABIN DOOR HARD TO OPEN FROM THE INSIDE. FOUND INNER DOOR HANDLE NOT SITTING PROPERLY WHILE DOOR IS FULLY CLOSED AND LATCHED. MEASURED FORCE NEEDED TO OPEN DOOR FROM FOLDING FLAP POSITION TO UNLOCKED DOOR POSITION. FORCE NEEDED TO UNLOCK DOOR RECORDED AS SDR JJBA20230330039Unknown · unknownDENT ON RUDDER 1 LEADING EDGE SKIN BTW RIB ZV 2601.0 AND ZV 2890.0. DENT REDRESSED ON LH RUDDER 1, ON LE SKIN BTW ZIB ZV2601-ZV2890SDR JJBA20230328033Unknown · unknownCORROSION ON REAR FUSE 2 LOWER SKIN, BTW FR 80-81 AND BTW STR 19L-21L. REPAIR DOUBLER ON REAR FUSE 2 LOWER SKIN, BTW FR 80-81 AND BTW STR 18L-21LSDR JJBA20230328035Unknown · unknownREPAIR DOUBLER TO REWORK ON LH CENTER FUSE 1 SKIN, BTW FR 19-20 AND BTW STR 13L-14L. REPAIR DOUBLER ON LH CENTER FUSE 1 SKIN, BTW 19-20 AND BTW STL 13L-14L REWORKEDSDR JJBA20230328034Unknown · unknownCF3, CRACKS (2X) FOUND ON LH OMEGA BEAM #4 FLOOR STRUCTURE BTW FR 35-39. 2 REPAIR DOUBLERS ON LH CENTER FUSE 3 OMEGA BEAM, ON INBD FLANGE AT FR 36 & 37SDR JJBA20230328032Unknown · unknownCF2, CRACKS (4X) FOUND ON LH OMEGA BEAM #3 FLOOR STRUCTURE BTW FR 29-36. 3 REPAIR DOUBLERS ON LH CENTER FUSE 2 OMEGA BEAM, ON INBD FLANGE AT FR 31,32,33, & 34SDR JJBA20230328031Unknown · unknownCF 1 EXT, MULTIPLE DENTS FOUND ON LH SIDE SKIN BTW FR 18-21 AND BTW STR 11L-13L. SKIN REPAIRED WITH 2 DOUBLERS, DOUBLER 1 LOCATED BTW FR 19-21 AND BTW STR 11L-13L AND DOUBLER 2 LOCATED BTW FR 21-23 AND BTW STR 11L-13L.SDR JJBA20230328037Unknown · unknownAT REAR FUSE EXT, HINGE FOUND CRACKED ON RH PNEUMATIC ACCESS DOOR BTW FR 70-71 AND BTW STR 19R-21R. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230320026Lamp · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB ON MCD EMERGENCY LIGHT. OPS CHECK FAIL. LIGHT ASESEMBLY FOUND TO BE INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT ASSEMBLY. OPS CHECK GOODSDR JJBA20230320025Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. DETERMINED FAULT TO BE BAD BATT 1 AND 4. REMOVED AND REPLACED BOTH BATTERIES. OPS CHECK SAT
BATTERY PACK #4 PN: ABS-2013-1A SN 61249 TSN 3920.06 CSN: 3300 TIME SINCE: 3198.54SDR JJBA20230330038Unknown · unknownREPAIR DOUBLER TO REWORK ON LH REAR FUSE 1 SKIN, BTW FR 62-63 AND BTW STR 16L-18L. LH REAR FUSE 1, SKIN, BTW FR 62-63 AND BTW STR 16L-18L REPAIR DOUBLER REWORKEDSDR JJBA20230328036Unknown · unknownCRACK FOUND ON LOWER SECTION FWD SIDE FRAME CARGO DOOR ASSY. CARGO DOOR LOWER SECTION FWD SIDE FRAME REPAIRED WITH L-SHAPED ANGLE (CORROSION LEVEL 2)SDR JJBA20230323029Unknown · unknownRF1, UPPER BEAM OF CARGO DOOR SURROUND STRUCTURE BTW FR 65-68 FOUND CORRODED. RF1, UPPER BEAM OF CARGO DOOR SURROUND STRUCTURE BTW FR 65-68 REPAIREDSDR JJBA20230323028Unknown · unknownRH ELEVATOR, LOWER SKIN FOUND CRACKED AT RIB YH 1310.0. RH ELEVATOR, CRACKED LOWER SKIN AT RIB YH 1310.0 REPAIREDSDR JJBA20230323027Unknown · unknownCF4, CORROSION FOUND ON RH GUSSET IN TOILET AREA BTW FR 59-61. RH OMEGA BEAM REPAIRED WITH A DOUBLERSDR JJBA20230320023Pump · inoperativeHYD 1 SYSTEM LOW QUANTITY ON EICAS THEN 10-15 MINUTES LATER HYD 1 SYSTEM FAIL ON EICAS. REMOVED AND REPLACED HYDRAULIC SYSTEM #1 ELECTRIC MOTOR DRIVEN PUMP. BLED AIR FROM HYDRAULIC SYSTEM 1. OPS CHECK SAT. REMOVED AND REPLACED LH ENGINE DRIVEN HYDRAULIC PUMP. SDR JJBA20230317022Lamp · inoperative18A CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SEAT 18A CEILING EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20230317024Unknown · unknownRH WING BOTTOM LATERAL FAIRING ANGLE BRACKETS CRACKED AT FR46, FR48, FR48.5, FR50 (BOTH BRACKETS). COMPLETED THE REPAIR OF THE RH WING BOTTOM LATERAL FAIRING ANGLE BRACKETS.SDR JJBA20230315020Electronic Unit · inoperativeFLAP LOW SPEED AT ACCELERATION ALTITUDE FOLLOWED BY FLAP FAIL SHORTLY AFTER. REMOVED AND REPLACED FECU. OPS CHECK SAT.SDR JJBA20230315018Pressure Sensor · inoperativeRUDDER OVERBOOST ON EICAS AFTER TAKEOFF. REMOVED AND REPLACED RUDDER PRESSURE SW. LEAK AND OPS CHECK SAT. PERFORMED PITOT TEST. NO FURTHER DEFECTS NOTED.SDR JJBA20230315019Unknown · unknownUPPER HANDLES ON OVER WING EXIT DOORS ARE LOOSE (WHITE GRAB HANDLES). RESECURED SHROUD.SDR JJBA20230315016Unknown · unknownLIGHTNING STRIKE DURING DECENT THROUGH 8,000. PERFORMED LIGHTNING STRIKE INSPECTION. ALL 5 DISPLAY UNITS MAGNETIZED DUE TO LIGHTNING STRIKE. REMOVED AND REPLACED ALL 5 DISPLAY UNITS. NO FURTHER DEFECTS. FO WINDSHIELD SHOWS SIGNS OF STRIKE. REMOVED AND REPLACESDR JJBA20230313015Unknown · unknownEMERGENCY LIGHT BATTERIES DEPLETED. RE-CHARGED EMERGENCY BATTERIES AND PERFORMED EMERGENCY LIGHT TEST. OPS CHECK SATSDR JJBA20230313017Unknown · unknownCORROSION ON FLOOR BRACKET AT FS 21 AT SERVICE DOOR. REMOVED AND REPLACED FLOOR BRACKET AT FS 21 AT SERVICE DOOR.SDR JJBA20230309014None · noneMCD DIFFICULT TO OPEN. CLEANED AND LUBBED MAIN CABIN DOOR ROLLERS. OPS CHECK SAT.SDR JJBA20230306004None · noneRH EXTERNAL OVER WING EMERGENCY LIGHT INSTALLED UPSIDE DOWN. REMOVED AND REORIENTED RH EXTERNAL OVER WING EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20230303002Lamp · inoperativeCOCKPIT CEILING EMERGENCY LIGHT OUT. REMOVED AND REPLACED COCKPIT CEILING EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20230303001None · noneMAIN CABIN DOOR WON'T COMPLETELY CLOSE. CLEANED DOOR SEAL AND LUBED THE ROLLER. OPS CHECK GOOD.SDR JJBA20230306008None · noneCF3, LH OMEGA BEAM #5 CRACKS SUSPECTED FOUND BTW FRAME 41 AND 42 ON FLOOR STRUCTURE. CF3, LH OMEGA BEAM #5 HAS CRACKS SUSPECTED FOUND AT FRAME 41 AND 42 ON FLOOR STRUCTURE. 1 CRACK FOUND AT FR41. BEAM REPAIRED WITH A DOUBLERSDR JJBA20230306007None · noneCF3, LH OMEGA BEAM #6 CRACK SUSPECTED FOUND AT FRAME 51 ON FLOOR STRUCTURE. CF3, LH OMEGA BEAM #6 CRACK FOUND AT FRAME 51 ON FLOOR STRUCTURE. BEAM REPAIRED WITH A DOUBLER.SDR JJBA20230306005None · noneCF2, CORROSION AND (3X) SUSPECTED CRACKS FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BETWEEN FR 24-30. CF2, CORROSION (LEVEL 1) AND 3 CRACKS FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BTW FR 24-30. BEAM IS REPAIRED WITH 3 DOUBLERSSDR JJBA20230303019None · nonePHOTO LUMINESCENT LIGHT STRIP LOOSE AT 3A. RESECURED EMERGENCY LIGHT STRIP AT 3ASDR JJBA20230309013None · noneCORROSION ON REAR FUSE 2 LOWER SKIN, BTW FR 80-81 AND BTW STR 19L-21L. CORROSION ON REAR FUSE 2 LOWER SKIN BTW FR 80-81 AND BTW STR 19L-21L. SKIN IS REPAIRED WITH A DOUBLER.SDR JJBA20230309011None · noneAT REAR FUSE 1 EXT, RADIO ALT ANTENNA NO 2 AFT LOWER DOUBLER CORRODED ON BELLY SKIN BTW FR 68-69. AT REAR FUSE 1 EXT, RADIO ALT ANTENNA NO 2 AFT LOWER DOUBLER CORRODED ON BELLY SKIN BTW FR 68-69, SKIN REPAIRED WITH A DOUBLERSDR JJBA20230309009None · noneCORROSION FOUND ON L GUSSET IN TOILET AREA BTW FR 59-61. CF4, CORROSION FOUND ON LH GUSSET IN TOILET AREA BTW FR 59-61. AFTER INVESTIGATION, CORROSION FOUND ON OMEGA BEAM AT FR 59 & 61. BEAM REPAIRED WITH 2 DOUBLERSSDR JJBA20230306006None · noneCF2, CORROSION AND (3X) SUSPECTED CRACKS FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BETWEEN FR 29-36. CF2, CORROSION (LEVEL 1) AND 3 CRACKS FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BTW FR 29-36. BEAM IS REPAIRED WITH 3 DOUBLERSSDR JJBA20230227018None · noneMAIN CABIN DOOR HARD TO CLOSE. LUBED AND CLEANED ROLLERS, OPS CHECK MAIN CABIN DOOR. NO DEFECTS FOUND. OPS CHECK GOOD.SDR JJBA20230315021Unknown · unknownRF1, LH FR68 REINFORCEMENT BRACKET CARGO DOOR HOLDER FOUND CRACKED. AFTER INVESTIGATION, A CRACK IS FOUND ON Z FRAME. Z FRAME SPLICEDSDR JJBA20230309010None · noneCRACKS SUSPECTED (14X) ON LH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3L-9L. CRACKS SUSPECTED ON LH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3L-9L. AFTER NDT INSPECTION, 4 CRACKS FOUND. INSTALLED REPAIR DOUBLER AT FR 78 AND BTW STR 5L-7L.
Back to Embraer EMB-145XR