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 JJBA20240508011Shear Tie · crackedCF2, UNDERFLOOR, R/H SHEAR CLIP AT FR25 BTW STR 15R-16R FOUND CRACKED NEW SHEAR CLIP AT FR 25 BTW STR 15R-16R INSTALLEDSDR JJBA20240508007Shear Tie · crackedL/H SHEAR CLIP CRACKED AT FR27 BTW STR 15L-16L L/H SHEAR CLOP MADE REPAIRED PART AT FR27 BTW STR 15L16L REPLACES.SDR JJBA20240506006Shear Tie · crackedUNDERFLOOR RH SHEAR CLIP AT FR24 BTW STR 15R-16R FOUND CRACKED R/H SHEAR CLIP AT FR24 BTW STR 15R-16R REMOVED AND REPLACED.SDR JJBA20240506005Shear Tie · crackedCF2, UNDERFLOOR, L/H SHEAR CLIP AT FR26 BTW STR 15L-16L FOUND CRACKED REMOVED AND REPLACED L/H SHEAR CLIP AT FR26 BTW STR 15L-16LSDR JJBA20240506004Shear Tie · crackedCF2, UNDERFLOOR, R/H SHEAR CLIP AT FR 26 BTW STR 15R-16R FOUND CRACKED. R/H CHEAR CLIP AT FR26 BTW STR 15R-16R REMOVED AND REPLACED.SDR JJBA20240430067Angle · corrodedCF1, UNDERFLOOR, PASSENGER DOOR, BOTH LOWER U SHAPE ANGLE FOUND CORRODED. CF1, UNDERFLOOR, PASSENGER DOOR, BOTH LOWER U SHAPE ANGLE BLENDED OUT OF LIMITS. ON CF1, UNDER FLOOR PASSENGER DOOR BOTH LOWER U SHAPE ANGLE REMOVED. CF1 UNDER FLOOR, PASSENGER DOOR, BOTSDR JJBA20240516026Floor Support · corrodedCENTER FUSE 3, UNDER FLOOR STRUCTURE, RH SILL 3 FOUND CORRODED R/H SILL #3 REMOVED FOR REPLACEMENT. ON CENTER FUDE 3, RH SILL 3 REPLACED.SDR JJBA20240513017Floor Support · corrodedCF1, UNDERFLOOR, L/H SILL NO.1 BTW FR 19-23 FOUND CORRODED ON CF1. UNDERFLOOR, L/H SILL NO1 BTW FR 19-23 CORROSION REMOVED. AT FR19, L/H CROSS BEAM AND T ABGLE REMOVED FOR ACCESS. L/H SILL BTWEEM 18-23 REMOVED FOR REPLACEMENT.CF1. UNDERFLOOR, L/H SILL NO1 BTWSDR JJBA20240513015Floor Support · corrodedCF3, UNDER FLOOR STRUCTURE, LH SILL 4 FOUND CORRODED. CF3, UNDER FLOOR L/H SILL, #4 BLENDED OUT OUT LIMIT. CF3 L/H SILL #4 REMOVED FOR REPLACEMENT. AT CF3, UNDER FLOOR STRUCTURE, LH SILL 4 REPLACED.SDR JJBA20240513014Door Sill · corrodedCF1, UNDERFLOOR, SERVICE DOOR AFT SILL FOUND CORRODED. CF1 UNDERFLOOR SERCIVE DOOR AFT SILL CORROSION AREA CUT OUT, CF1 UNDERFLOOR SRVICE DOOR AFT SILL REPAIRED.SDR JJBA20240415033Lamp · inoperativeCOCKPIT CEILING EMERGENCY LIGHT OUT. REMOVED AND REPLACED BULB. OPS CHECK SAT.SDR JJBA20240418049Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR 66 BTW STR 7L-8L. SHEAR CLIP REPLACED BY FABRICATION WITH ALTERNATE MATERIALSDR JJBA20240418047Skin · cracked8 CRACKS SUSPECTED ON RH SKIN FR77-81 AND STR 3R-9R. SKIN REPAIRED WITH A DOUBLER ON RH REAR FUSE 2 AT FR 78 BTW STR 5R-7R AND 6 BUSHINGS ON RH REAR FUSE SKIN AT FR 77 & 79 BTW STR 3R-9RSDR JJBA20240418046Skin · cracked8 CRACKS SUSPECTED ON LH SKIN FR77-81 AND STR 3L-9L. 9 CRACKS FOUND. SKIN REPAIRED WITH A DOUBLER ON LH REAR FUSE 2 AT FR78 BTW STR 5L-7L AND 7 BUSHINGS ON LH REAR FUSE 2 SKIN AT FR 77,79 & 80 BTW STR 3L-9LSDR JJBA20240418053Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR 58 BTW STR 15L-16L. SHEAR CLIP REPLACED BY FABRICATION WITH ALTERNATE MATERIALSDR JJBA20240418051Skin Splice · corrodedRH SKIN SPLICE BTW FR 23-24 AND STR 19-20 FOUND CORRODED. CIRCUMFERENTIAL STRAP SPLICED ON CENTER FUSE 1 & 2 BTW FR 23-24 AND BTW STR 20L-19RSDR JJBA20240418050Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR61 BTW STR 6R-7R. SHEAR CLIP REPLACED BY FABRICATION WITH ALTERNATE MATERIALSDR JJBA20240418044Floor Support · crackedAT CF1 FLOOR STRUCTURE AREA, CORROSION AND (3X) CRACKS FOUND ON LH OMEGA BEAM #1 BTW FR 19-23. OMEGA BEAM REPAIRED WITH 3 DOUBLERS ON INBD VERTICAL FLANGE AT FR 21, 22, AND 23 (CORROSION LEVEL 1)SDR JJBA20240418043Floor Support · crackedLH OMEGA BEAM 2 CRACK SUSPECTED (X3). 3 CRACKS CONFIRMED ON CENTER FUSE 2 LH OMEGA BEAM #2 AT FR 24-28 AND 27. 3 CUTOUTS DONE. LH OMEGA BEAM #2, 3 CRACKS REPAIREDSDR JJBA20240415040Skin · corrodedCORROSION FOUND ON INNER SKIN UNDER FR 67 BTW STR 21L-21R. SKIN REPAIRED WITH A DOUBLER AT FR 67 BTW STR 20L-20R. CORROSION LEVEL 1.SDR JJBA20240418041Shear Tie · corrodedCORROSION FOUND ON CARGO FR 66 LATERAL SHAPE BTW STR 15L-17L. CORROSION ON SHEAR CLIP OUT OF LIMITS AT FR 68 STR 15L-17L. AT FR 68 BTW STR 17L-15L, SHEAR CLIP REMOVED AND REPAIREDSDR JJBA20240415038Floor Support · crackedAT CF3 FLOOR STRUCTURE AREA, CRACK FOUND ON RH OMEGA BEAM INBD ANGLE BTW FR 46-50. RH OMEGA BEAM INBD ANGLE BTW FR 46-50 REMOVED FOR REPLACEMENT. NEW ANGLE ON RH OMEGA BEAM INBD DRILLED AND READY TO INSTALL. ON RH OMEGA BEAM, INBD ANGLE BTW FR 46-50 REPLACEDSDR JJBA20240412024Floor Support · corrodedAT CF3 FLOOR STRUCTURE AREA, CRACK FOUND ON RH OMEGA BEAM OUTBD ANGLE BTW R 46-50. RH OMEGA BEAM OUTBD ANGLE BTW FR 46-50 REMOVED FOR REPLACEMENT. POST AT FR 50 REMOVED FOR ACCESS. RH OMEGA BEAM OUTBD ANGLE DRILLED AND READY TO INSTALL. POST RH AT FR50 REINSTASDR JJBA20240412026Floor Support · corrodedAT CF3 FLOOR STRUCTURE AREA, CORROSION FOUND ON RH SILL #3 BTW FR 35-41. RH SILL #3 BTW FR 35-41 REMOVED. AFTER INVESTIGATION, RH SILL #3 BTW FR 35-41 FOUND OUT OF LIMITS. AT CF3 FLOOR STRUCTURE RH SILL #3 BTW FR 35-45 REPLACEDSDR JJBA20240412023Seat Track · corrodedAT CF3, CORROSION FOUND ON RH SIDE PASSENGER SEAT TRACK SUPPORT BTW FR 41-48. AT CF3 ON RH SIDE PASSENGER SEAT TRACK SUPPORT BTW FR 41-48, SUPPORT BLENDED OUT OF LIMIT. AT CF3 ON RH SIDE PASSENGER SEAT TRACK SUPPORT BTW FR 41-48, REPAIR DOUBLER FABRICATED. AT SDR JJBA20240412021Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR67 BTW STR 7L-8L. AT FR 67 BTW STR 7L-8L SHEAR CLIP REMOVED FOR REPLACEMENT AND REPLACED WITH A NEW ONE.SDR JJBA20240412020Bulkhead · crackedLH MLG WHEEL WELL BAY AREA REAR BULKHEAD CRACK. AT LH MLG WHEEL WELL BAY AREA, REAR CRACKED BULKHEAD REMOVED FOR REPLACEMENT. AT LH MLG WHEEL WELL BAY AREA, NEW REAR BULKHEAD DRILLED AND FITTED. AT LH MLG WHEEL WELL BAY AREA, NEW REAR BULKHEAD INSTALLED.SDR JJBA20240404019Battery Pack · dischargedEMERGENCY LIGHT BATTERY #4 REQUIRES REPLACEMENT DUE TO MULTIPLE EMERGENCY LIGHTS INOP /R EMERGENCY LIGHT BATTERY #4, OPS CHECK SATSDR JJBA20240415034Fitting · crackedLH T/R FIXED STRUCTURE, O/B SIDE INTERNAL AREA BTW STN: XN 3200.00 / XN 4109.70 FITTING FOUND CRACKED. LH TR FIXED STRUCTURE, O/B SIDE INTERNAL AREA, BTW STN: XN 3200.00 / XN 4109.76 STIFFENER REMOVED. LH TR FIXED STRUCTURE O/B SIDE INTERNAL AREA BTW STN XN 32SDR JJBA20240404018Fire Detector · warning messageE2 FIRE DET FAIL ON EICAS IN FLIGHT R&R OF THE ENGINE FIRE DETECTOR OPS CHECK SATSDR JJBA20240412030Floor Support · corrodedAT CF1 FLOOR STRUCTURE AREA, CORROSION FOUND ON LH SILL #1 BTW FR19-23. AT CF1 FLOOR STRUCTURE AREA ON LH SILL #1 BTW FR 19-23 BLENDED OUT OF LIMIT. ON LH SILL #1 BTW FR 19-23, SILL REMOVED FOR REPLACEMENT. LH SILL #1 BTW FR 19-23 AT CF1 FLOOR STRUCTURE AREA RSDR JJBA20240401001Pdu · failedFLAP FAIL ON APPROACH TO LANDING WHEN SELECTING FLAP 45. PERFORMED TROUBLESHOOTING WITH BREAKOUT BOX GSE 398, CODES SENT TO ENGINEERING, ADVISED TO PERFORMED 0 DEG FLAP RIGGING, WHEN ACTUATING FLAPS NOTICE FFS (FLAP FLEXIBLE SHAFT) NR 5 ON RT SIDE HAVING SOSDR JJBA20240418042Access Panel · corrodedRH WING ACCESS PANEL 632AB AREA, THE ANCHOR NUT RING ON THE WING STRUCTURE IS CORRODED. DOUBLER REPLACED AT RH WING ACCESS PANEL 632ABSDR JJBA20240412025Crossbeam · crackedIN NLG LH SUPPORT AFT OF FWD CROSSBEAM FOUND CRACKED. IN NLG LH SUPPORT AFT OF FWD CROSSBEAM REPLACED WITH NEW ONE.SDR JJBA20240415035Support · crackedCARGO DOOR MECH SUPPORT BTW FR 61-62 AND STR 4R-5R FOUND CRACKED. AT RH SIDE BTW FR 61-63 AND BTW STR 4R*5R CARGO DOOR MECH SUPPORT REPLACED.SDR JJBA20240412031Support · corrodedRADIO ALT 2, OUTSIDE SUPPORT BTW FRAME 68-69 FOUND CORRODED. RADIO ALT 2, OUTSIDE SUPPORT BTW FR 68-69 CORROSION BLENDED AND FOUND OUT OF LIMIT. RADIO ALT 2, OUTSIDE SUPPORT BTW FR 68-69 REMOVED. RADIO ALT 2 OUTSIDE SUPPORT BTW FR 68-69 REPLACEDSDR JJBA20240412029Support · crackedCARGO DOOR SUPPORT CASTING FOUND CRACKED BTW FR 61-62 AND STR 4R-5R. AT FR61-62 AND BTW STR 4R-5R, CARGO DOOR SUPPORT CASTING REMOVED. CARGO DOOR SUPPORT CASTING REPLACED, BUSHING INSTALLED ON CASTING. CARGO DOOR SUPPORT CASTING INSTALLED COVERSDR JJBA20240412027Floor Support · corrodedAT CF1 FLOOR STRUCTURE AREA, CORROSION FOUND ON SERVICE DOOR CUTOUT LOWER CHANNEL BTW FR 20-22. SERVICE DOOR CUTOUT LOWER CHANNEL BTW FR 20-22 REMOVED FOR REPLACEMENT. SERVICE DOOR CUTOUT LOWER CHANNEL BTW FR 20-22 BLENDED OUT OF LIMIT. SERVICE DOOR CUTOUT LOWSDR JJBA20240328092Light · inoperativeLOWER SERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LOWER SERVICE DOOR EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20250403012Skin · dentedDENT FOUND ON EXTERNAL SKIN BTW FR 19-20 AND BETWEEN STR 11L-12L. PAINT STRIPPED ON EXTERNAL SKIN BTW FR 19-20 BTW STR 11L-12L FOR INVESTIGATION. ON LH CENTER FUSE I SKIN, BTW FR19-20 AND BTW STR 11L-12L SKIN OUT TO REMOVE THE DAMAGE. SKIN REPAIRED BTW FR19-20SDR JJBA20240418052Beam · corrodedCARGO LOWER BEAM FOUND CORRODED BTW FR 65-68. CARGO LOWER BEAM BTW FR 65-68 REPLACEDSDR JJBA20240418048Support Bracket · cracked3 CARGO DOOR SUPPORT BRACKET FOUND CRACKED BTW FR 67-68 ON STR 4R, 5R AND VERTICAL BRACKET. 3 CARGO DOOR SUPPORT BRACKETS REPALCEDSDR JJBA20240415036Shear Tie · crackedAT RF2 SHEAR CLIP ON FR 80 BTW STR 7R-5R FOUND CRACKED. AT RF2 SHEAR CLIP ON FR80 BTW STR 7L-5L SKIN EXTERNAL AREA STRIPPED WITH CEE-BEE. SHEAR CLIP ON FR 80 BTW STR 7L-5L REMOVED FOR REPLACEMENT. AT RF2 SHEAR CLIP ON FR 80 BTW STR 7L-5L REPLACED WITH NEW PARTSDR JJBA20240328098Shear Tie · crackedSHEAR CLIP FOUND CRACKED ON FR 15 BTW STR 15R-16R. CRACKED SHEAR CLIP AT FR 15 BTW STR 15R-16R REMOVED. INSTALLATION OF NEW SHEAR CLIP AT FR15 BTW STR 15R-16R COMPLETESDR JJBA20240412032Floor Support · corrodedAT CF1 FLOOR STRUCTURE AREA, CORROSION FOUND ON RH SILL BTW FR 22-23. AT CF1 FLOOR STRUCTURE AREA, ON RH SILL BTW FR 22-23 BLENDED OUT OF LIMIT. AT CF1 FLOOR STRUCUTRE AREA ON RH SILL BTW FR 22-23, LAYOUT PERFORMED AND DOUBLER REPAIR PART FABRICATED. AT CF1 FLSDR JJBA20240322078Unknown · unknownICU PILOT FA COMMUNICATION INOPERATIVE. CABIN AND CABIN EMERGENCY LIGHT WILL NOT EXTINGUISH. RESET SYSTEM POWER. SYSTEM OPS CHECKED NORMAL. EMERGENCY LIGHTS OP CHECK NORMAL. NO FURTHER DEFECTS NOTED.SDR JJBA20240412028Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR 73 BTW STR 8L-10L. AT FR 73 BTW STR 8L-10L SHEAR CLIP REMOVED FOR REPLACEMENT. AT FR 73 BTW STR 8L-10L SHEAR CLIP REPLACED. AT FR73 LH PYLON AFT SIDE ACCESS PANEL REMOVE FOR ACCESS. FR73, LH PYLONG AFT SIDE ACCESS PANEL INSTALLEDSDR JJBA20240404004Skin · dentedALL DENTS IN AREAS A, B, C,AND D ARE REFERENCED IN ETD EXCEPT DENT IN AREA A1 ON THE LF FWD FUSELAGE I/II SKIN REQUIRE A PERMANENT REPAIR WITHIN 50000FC FROM SEPTEMBER 21, 2022. SKIN REPAIRED WITH A DOUBLER.SDR JJBA20240415037Gusset · corrodedRH GUSSET BTW FR 59-61 FOUND CORRODED. RH GUSSET BTW FR 59-61 CORROSION BLENDED AND FOUND OUT OF LIMITS. RH GUSSET BTW FR 59-61 REMOVED. RH GUSSET BTW FR 59-61 INSTALLEDSDR JJBA20240404012Shear Tie · crackedSHEAR CLIP CRACKED AT FR 16 BTW STR 15R-16R SHEAR CLIP AT FR 16 BTW STR 15R-16R REPLACED
Back to Embraer EMB-145XR