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 JJBA20210301007Skin · damagedLH WING L/E NO 3 REPAIR FOUND BTW RIB 22-23 ON NOSE SKIN. LH WING L/E #3 REPAIR REWORKED.SDR JJBA20210301006Frame · corrodedFRAME 65 BTW LH STR 11-15 FOUND CORRODED. FRAME Z REPLACEDSDR JJBA20210301005Skin · canningOIL CAN FOUND ON LH SKIN BTW FR 22-23 AND STR 11L-12L. DAMAGE REPAIRED.SDR JJBA20210301004Support · corrodedCF3, L/H OMEGA BEAM INBD FLANGE CORRODED FROM FR46 TO SKIN JUNCTION (FR52-53) - CORROSION LEVEL 2. OMEGA BEAM REPLACEDSDR JJBA20212260009Seat Frame · crackedSEAT 22A AISLE SIDE FRAME CRACKED. R&R SEAT 22A. OPS CHECK SAT. NO OTHER DEFECTS NOTED.SDR JJBA20212260007Armrest · cracked19A, 22A, 18A, 10A, 4A, & 2A PASSENGER SEATS ARMREST STRUCTURE IS CRACKED. R&R PASSENGER SEATS.SDR JJBA20212260006Seat Frame · crackedSEATS 22A, 10A & 9A AISLE SIDE FRAME CRACKED. REMOVED AND REPLACED SEATS 10A, 9A & 22A.SDR JJBA20210308011Wing · crackedLH WING LEADING EDGE III CRACK UNDER #2 VORTILLON REQUIRES PERMANENT REPAIR WITHIN 750 FC. LH WING LEADING EDGE III CRACK UNDER #2 VORTILLON REPAIREDSDR JJBA20210226008Vortilon · crackedL/H L/E NO 3 UNDER VORTILLONS NO 3 ET NO 4 CRACK FOUND. LH WING LEADING EDGE III CRACK UNDER #3 AND #4 VORTILLONS REPAIREDSDR JJBA20210226037Support · corrodedCF3, CTR OMEGA BEAM INBD FLANGE CORRODED FROM FR46 TO SKIN JUNCTION (FR52-53) - CORROSION LEVEL 2. OMEGA BEAM REPLACEDSDR JJBA20210301036Light · inoperativeBOTH LH SIDE EXTERNAL EMERGENCY LIGHTS INOPERATIVE. R&R LH SIDE EXTERNAL EMERGENCY LIGHTS. OPS CHECK SAT.SDR JJBA20212250001Seat Frame · crackedSEAT 23A AISLE SIDE FRAME CRACKED. REMOVED AND REPLACED PAX SEAT 23A.SDR JJBA20210225035O-Ring · damagedBLEED 1 LEAK MESSAGE ON EICAS. (CREW REPORTED AT FL220 MESSAGE APPEARED AND HE DECLARED AN EMERGENCY, THE THEN WENT THROUGH THE CHECKLIST AND WHEN BLEED WAS DESELECTED THE MESSAGE WENT OUT SO HE ADVISED TOWER HE RESOLVED THE ISSUE AND DIDN’T NEED PRIORITY LANDSDR JJBA20210223009Angle · crackedRH OVERWING EMERGENCY DOOR FWD L-SHAPE ANGLE FOUND CRACKED AT 2 LOCATIONS. RH OVERWING EMERGENCY DOOR, FWD L-SHAPE ANGLE REPLACED AND SKIN MISALIGNED HOLES REPAIREDSDR JJBA20210222033Diode · shortedWHEN DISCONNECTING THE GROUND POWER UNIT, THE GPU AVAILABLE LIGHT AND ALL CABIN LIGHTS STAY ON. SHORTLY BURNT SMELL APPEARS MAIN BATTERIES DISCONNECT FOR SAFETY. TROUBLESHOOTING CARRIED OUT, FOUND DIODE CR046 AND SOME WIRES BURNT, CR0465 SHORT CIRCUIT AND THE SDR JJBA20210308010Wing · crackedRH WING L/E NO 3. UNDER VORTILLON NO 3 CRACK FOUND. RH WING LEADING EDGE - 3 CRACK UNDER #3 VORTILLON REPAIREDSDR JJBA20210220029Door · rustedBAGGAGE DOOR LATERAL AFT L-SHAPE CORRODED. CORROSION AT BAGGAGE DOOR LATERAL AFT SHAPED SHEAR CLIP REPAIRED.SDR JJBA20210301032Yoke · crackedFOLLOWING NDT INSPECTION ON TASK. 2X CRACK FOUND ON PYLON YOKES UPPER FLANGE 2X HOLE LOCATION. 2 HOLES REWORKED.SDR JJBA20210219021Smoke Detector · false activationBAGGAGE COMP FIRE EXT WARNING ILLUMINATED WITH NO EICAS MESSAGE. R&R HIGH RATE AND METERING BAGGAGE FIRE BOTTLES. R&R CARGO SMOKE DETECTOR. OPS CHECK COMPLETED. VERIFIED BAGGAGE EXT LIGHT EXTINGUISHED AFTER OPS CHECK. NO FAULTS FOUND.SDR JJBA20210218033Pin · corrodedLH AND RH EMERGENCY OVER WING EXIT DOORS HAVE SIGNS OF CORROSION ON THE BOTTOM ALIGNMENT PINS. ALIGNMENT PINS CORROSION WAS OUT OF LIMITS. REMOVED AND INSTALLED PINS.SDR JJBA20210301034Skin · chafedCHAFFING FOUND ON EXTERNAL RH SKIN BETWEEN FR 67-68 AND BTW STR 7-8 INSIDE ENGINE PYLON. EXTERNAL SKIN BTW FR 67-68 AND BTW STR 7-8 RH SIDE INSIDE ENG. PYLON REPAIRED.SDR JJBA20210225030Skin · crackedCRACK SUSPECTED ON EXTERNAL SKIN AT FR 78 BTW LT STR 6-7. ON EXTERNAL SKIN AT FR 78 BTW LH STR 6-7 DOUBLER LOCALLY FABRICATED FOR REPAIR. ON EXTERNAL SKIN AT FR 78 BTW LH STR 6-7 CRACK REPAIRED.SDR JJBA20210216027Structure · corrodedBAGGAGE DOOR FWD LATERAL L-SHAPE CORRODED. BAGGAGE DOOR FWD LATERAL L-SHAPE BLENDED OUT OF LIMITS REMOVED. BAGGAGE DOOR FWD LATERAL L-SHAPE REWORKED.SDR JJBA20210216026Skin · damagedEXTERNAL BAGGAGE DOOR CUTOUT, NICK AND SCRATCHED ON FWD EDGE. EXTERNAL BAGGAGE DOOR CUTOUT, NICK AND SCRATCHES ON FWD EDGE REPAIRED.SDR JJBA20212140008Seat Frame · crackedPASSENGER SEATS 2A AND 18A HAVE CRACKED SUPPORTS BELOW AISLE ARMREST. SEATS 3A, 6A, AND 7A HAVE CRACKED SUPPORTS. R&R PASSENGER SEATS. NO OTHER DEFECTS NOTED AT THIS TIME.SDR JJBA20210215028Skin · dentedRIGHT WING L/E NR 1 DENT ON SKIN 4.0 FEET FROM INBOARD EDGE AND 7.5" FROM TOP EDGE. RT WING L/E NR 1 SKIN REPAIRED.SDR JJBA20210214024Skin · crackedTWO CRACK SUSPECTED ON EXTERNAL SKIN FR 78 BTW RT STR 4-7. RT REAR FUSELAGE SKIN AT FR 78 BTW STR 4R-7R REPAIRED.SDR JJBA20220212009Not Reported · not reportedPOSSIBLE CORROSION LAV FLOOR (LATERAL) SUPPORT FR 59-60+8 STR 15R. REMOVED AND REPLACED NEW SILL.SDR JJBA20210211011Anti-Ice Valve · crackedENG A/I FAIL, NO ICE ON, AND BLEED 1 LOW TEMP MESSAGES IN FLIGHT (E2 E/I FAIL WITH NO ICE A/I ON MESSAGES ON CLIMB FROM FL220 TO FL270. BLEED 1 LOW TEMP CAME ON AT 3000 FEET ON APPROACH WITH N1 AT 70% AND N2 80-85%. PERFORMED A/I ADJUSTMENT TEST. OPS CHECK SATSDR JJBA20210209023Rudder · chafedRUDDER 1, LT SKIN CHAFFED 8 INCH FROM LOWER EDGE, 12 INCH LONG. CHAFFED LT SKIN OF RUDDER 1 AT LOWER EDGE REPAIRED.SDR JJBA20210209022Skin · damagedREAR FUSELAGE II, LT SIDE, AT FR 77-78-79, BTW STR 3-8 MULTIPLES REPAIR BUSHING. REAR FUSE II AT FR 77 BTW STR 3-4L SKIN REPAIRED AT THE 2 CONSECUTIVE REPAIR BUSHING LOCATIONS.SDR JJBA20210209017Skin · dentedON RH FUSE SKIN BTW FR 12-11 AND STR 20-21 2 DENTS FOUND. DENT #1 ON RH FUSE SKIN FROM 0650 FWD FR 11 AND 2100 ABOVE STR 21R DENT DRILLED 0185 AND INSTALLED RIVET PLUG. RH FUSE SKIN BTW FR 12-11 AND STR 20-21R DENT #2 IS AN EXISTING BLEND REMAINING 025 AND 032SDR JJBA20210209015Skin · dentedRH FUSE BTW FR 2-3 AND BTW STR 11-13, SKIN DENTED. RH FUSE SKIN BTW FR 2-3 STR 11-13 REPAIREDSDR JJBA20210209013Skin · dentedON RH FUSE DENT FOUND BTW FR26 AND FR25 AND BTW STR 13R AND 14R. DENT IS OUT OF LIMITS. DENT DIMENTION L 0.800 W 0.600 H 0.020. RH FUSE SKIN BTW FR26 & FR25 BTW STR 13R & 14R REPAIRED.SDR JJBA20210206008Brake · low pressureBRAKE OVERHEAT ON EICAS AFTER TAKE-OFF RIGHT BEFORE GEAR RETRACTION (DID NOT OBSERVE ANY BRAKE TEMP INDICATIONS IN THE RED AND OVERHEAT MESSAGE EXTINGUISHED AFT GEAR RETRACTION). R&R BRAKE TEMPERATURE SENSOR. OPS CHECK SAT. NO FURTHER DEFECTS NOTED. COMPLIED WSDR JJBA20210205009Light · unsecurePHOTO LUMINESCENT STRIP DOES NOT ILLUMINATE PROPERLY (HAS BREAKS). RE SECURED PHOTO LUMINESCENT STRIP.SDR JJBA20210204012Skin · damagedSUSPICIOUS BLEND ON RH FUSELAGE SKIN AT FR 68 BTW STR 18-19. DOUBLER REPAIR ON RH LOWER REAR FUS-1, AT FRAME 68, BTW STR 18R-19R REPAIREDSDR JJBA20210203010Skin · not reportedREPAIR DOUBLER ON RH CENTER FUSE 2, BTW FR 26-27 AND BTW STR 16R-18R. REPAIR DOUBLER ON RH FUSELAGE 2, BTW FR 26-27, AND STR 16R-18R REWORKEDSDR JJBA20210201006Hinge · looseEXTERNAL POWER ACCESS DOOR HINGE LOOSE. REPAIR DOUBLER ON LH FWD FUSE 2, BTW FR 6-7, STR 13L-15L REPAIREDSDR JJBA20210201005Skin · not reportedLH EXTERNAL SKIN CF4 BTW STR 3L-4L DOUBLER FOUND. REPAIR DOUBLER ON LH CENTER FUSE 4 BTW FR 57-58 AND BTW STR 3L-4L REPAIREDSDR JJBA20210201001Skin · dentedMULTIPLE DENTS FOUND ON CARGO DOOR. REPAIR DOUBLER ON BAGGAGE DOOR AT STA X22716.2 AND BEAM #3 REPAIRED.SDR JJBA20211310005Seat Frame · crackedPASSENGER SEATS 5A AND 9A HAVE CRACKS IN SEAT FRAME BELOW AISLE ARMREST. R&R SEAT 5A AND 9A. NO FURTHER DEFECTS NOTED.SDR JJBA20210130007Skin · dentedRH SERVICE DOOR LOWER SKIN AFT CORNER DENT FOUND. DAMAGE CUT OUT ON RH SERVICE DOOR LOWER SKIN AFT CORNER. RH SERVICE DOOR LOWER AFT CORNER REPAIRED.SDR JJBA20210130003Doubler · not reportedLH EXT FUSE RF1 BTW FR 75-75A BTW STR 2L-3L DOUBLER FOUND. LH EXT FUSE RF1 BTW FR 75-75A STR 2L-3L DOUBLER REMOVED. LH EXT FUSE RF1 BTW FR 75-75A STR 2L-3L DOUBLER REPLACEDSDR JJBA20210130002Doubler · not reportedRH RF 2 BTW FR79-80 AND STR 8R-10R DOUBLER FOUND ON SKIN. RH RF 2 BTW FR 79-80 AND STR 8R-10R DOUBLER REMOVED FROM SKIN. RH RF 2 BETWEEN FR 79-80 AND STR 8R-10R DOUBLER REWORKED.SDR JJBA20210129056Unknown · odorFUEL SMELL IN FLIGHT AND ON GROUND WITH APU RUNNING. PERFORMED RUNS AND CONFIRMED APU CAUSING FUEL SMELL DEFERRED PER MEL (PULLED AND COLLARED C30 C/B`S PLACARD APPLIED) APU HAS BEEN INSPECTED FOR LEAKS WITH NO LEAKS NOTED AT THIS TIME. R/R APU FUEL CONTROL ASSDR JJBA20210128004Skin · dentedDENT FOUND ON LH CTR FUSE 1, ON FR 20 AND ON STR 14L. DENT ON LH CENTER FUSELAGE-1 ON FRAME 20 BETWEEN STR 13L-15L REPAIREDSDR JJBA20210128042Skin · dentedCF II RT FUSELAGE DENTED BETWEEN FR 26-27 STR 11-12. CENTER FUSELAGE II DENT BETWEEN FR 26-27, STR 10R-12R REPAIRED.SDR JJBA20210127026Lever · inoperativeLG LEVER DISAGREE DURING LG RETRACTION (3 GREEN REMAINED THE ENTIRE TIME). REMOVED AND REPLACED LANDING GEAR CONTROL HANDLE, EXT/RET OPERATIONS CHECK GOOD WITH NO DEFECTS NOTED.SDR JJBA20210126055Skin · dentedBAGGAGE DOOR SKIN, DENT FOUND IN THE LOWER AFT AREA, BELOW HB4 AND AFT OF VB5. BAGGAE DOOR SKIN, DENT IN THE LOWER AFT AREA, BETWEEN HB4 AND AFT OF VB5 REPAIRED.
Back to Embraer EMB-145XR