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 JJBA20240306036Skin · crackedCRACKS SUSPECTED (22X) ON RH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3R-9R. AFTER NDT INSPECTION (47X) CRACKS CONFIRMED ON RH SKIN BTW FR77-80 STR 3R-9R. (8X) CRACKS ON RH SKIN BTW FR 77-80 STR 3R-9R REPAIRED WITH BUSHING. (39X) CRACKS ON RH SKIN BTW FR 77-SDR JJBA20240325091Shear Tie · crackedRF1: SHEAR CLIP FOUND CRACKED AT FR66 BTW LH STR 6-7L. AT RF1, AT FR66 BTW STR 6L-7L, SHEAR CLIP REMOVED FOR REPLACEMENT. AT FR66, BTW LH STR 6-7L SHEAR CLIP REPLACED.SDR JJBA20240318064Shear Tie · crackedCF2 RH SIDE BTW STR 15R-16R SHEAR CLIP CRACKED FR25. CF2 RH SIDE FR25 BTW STR 15-16 SHEAR CLIP REMOVED AND REPLACED.SDR JJBA20240314056Gusset · corrodedCF3 RH GUSSET #4 BTW FR 38-46 CORRODED. IN CF3 RH GUSSET #4 BTW FR 38-46 FOUND CORRODED OUT OF LIMIT. RH GUSSET #4 REPLACED.SDR JJBA20240314055Shear Tie · crackedRF1: SHEAR CLIP FOUND CRACKED ON FR 62 BTW RH STR 6R-8R. IN RF1 SHEAR CLIP ON FR62 BTW STR 6R-8R REPLACED WITH NEW ONE.SDR JJBA20240314054Shear Tie · crackedRF1: SHEAR CLIP FOUND CRACKED AT FR67 BTW LH STR 6L-7L. AT RF1, AT LH FR67 BTW STR 6L-7L, SHEAR CLIP REMOVED FOR REPLACEMENT. AT FR67 BTW LH STR 6-7L SHEAR CLIP REPLACED.SDR JJBA20240314049Gusset · corrodedCF3 LH GUSSET #5 BTW FR 38-46 CORRODED. CF3 LH GUSSET #5 BTW FR 38-46 FOUND CORRODED OUT OF LIMIT. LH GUSSET #5 REPLACEDSDR JJBA20240312044Shear Tie · crackedRF1: SHEAR CLIP FOUND CRACKED AT FR 73 BTW RH STR 8L-10L. AT RF1, ON LH FR 73 BTW STR 8L-10L SHEAR CLIP REMOVED FOR REPLACEMENT. AT RF1, ON LH FR73 BTW STR 8L-10L, SHEAR CLIP REPLACEDSDR JJBA20240311043Shear Tie · crackedRF1: SHEAR CLIP FOUND CRACKED AT FR 73 BTW RH STR 8R-10R. AT RF1, AT RH FR73 BTW STR 8R-10R, SHEAR CLIP REMOVED FOR REPLACEMENT. AT RF1, AT RH FR 73 BTW STR 8R-10R, SHEAR CLIP REPLACED.SDR JJBA20240306038Control Cable · frayedSTICK PUSHER ACTUATOR CABLE STAND BROKEN WIRE OUT OF LIMIT. STICK PUSHER ACTUATOR REPLACEDSDR JJBA20240306029Floor Support · crackedCF2, CRACK FOUND ON CENTER OMEGA BEAM #1 FLOOR STRUCTURE FLANGE AT FR25. REPAIR DOUBLER ON CENTER FUSE 2 CENTER OMEGA BEAM, ON LH VERTICAL FLANGE AT FR25SDR JJBA20240304027Strap · corrodedRF1, CORROSION FOUND ON U/FLOOR SKIN STRAP BTW FR 60-61 AND BTW STR 20R-21R. RF1, UNDER FLOOR, SKIN SPLICE STRAP BTW FR 60-61 AND BTW STR 20R-21R CORROSION BLENDED AND FOUND OUT OF LIMIT. RF1, UNDER FLOOR SKIN SPLICE STRAP BTW FR 60-61 CUTOUT. RF1, UNDER FLOORSDR JJBA20240328099Shear Tie · crackedCF1 RH SIDE SHEAR CLIP FR15 BTW STR 15-16 CRACKED. AT CF1, AT FR15 ON RH SIDE BTW STR 15-16, ON EXTERNAL SKIN PAINT STRIPPED AND SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240325088Floor Support · corrodedAFTER REMOVAL OF RH GUSSET BTW FR 59-61, OMEGA BEAM FOUND CORRODED. CORROSION ON RH OMEGA BEAM BTW FR 59-61 BLENDED OUT OF LIMITS AND REMOVED BY CUT-OUT. RH OMEGA BEAM BTW FR 59-61 REPAIREDSDR JJBA20240322084Beam · corrodedCARGO CUTOUT LOWER BEAM FOUND CORRODED BTW FR 65-68. CARGO CUT-OUT LOWER BEA, BTW FR65-68 BLENDED AND FOUND OUT OF LIMIT. CARGO CUT-OUT LOWER BEAM BTW FR 65-68 REMOVED FOR REPLACEMENT. BTW FR 65-68 ITEM 40-45-50-55-60-65 REMOVED FOR ACCESS. CARGO CUTOUT BTW FRSDR JJBA20240322082Seat Track · chafedLH OUTBD SEAT TRACK FOUND CHAFFED AT FR38, 44, AND 49. LH OUTBD SEAT TRACK AT FR38 OUT OF LIMITS, REMOVED AND REPLACED. LH OUTBD SEAT TRACK AT FR44 OUT OF LIMITS REMOVED AND REPLACED. LH OUTBD SEAT TRACK AT FR49 BLENDED WITHIN LIMITS.SDR JJBA20240318067Shear Tie · crackedCF2 RH SIDE FR26 BTW STR 15-16 SHEAR CLIP CRACKED. CF2 RH SIDE FR26 BTW STR 15-16 SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240318066Shear Tie · crackedCF2 RH SIDE FR27 BTW STR 15R-16R SHEAR CLIP CRACKED. CF2 RH SIDE FR27 BTW STR 15-16 SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240318065Shear Tie · crackedCF1 RH SIDE SHEAR CLIP FR16 CRACKED BTW STR 15-16. AT CF1, AT FR16 BTW STR 15-16 EXTERNAL SKIN, PAINT STRIPPED FOR ACCESS. SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240315061Bulkhead · crackedRH MLG BAY AFT BULKHEAD CRACKED. AT RH MLG BAY AFT, BULKHEAD REMOVED, NEW BULKHEAD FULLY DRILLED. AT RH MLG BAY AFT, NEW BULKHEAD INSTALLEDSDR JJBA20240315060Bracket · crackedCF1 RH SIDE FUEL RELAY BRACKET AT FR15 CRACKED. RH FUEL RELAY BRACKET FOUND CRACKED, NEW BRACKET INSTALLEDSDR JJBA20240315059Floorbeam · corrodedAT FR61 LH OUTBD FLOOR T SUPPORT FOUND CORRODED. AT FR61, LH OUTBD FLOOR T SUPPORT BLENDED AND FOUND OUT OF LIMIT. LH OUTBD FLOOR T SUPPORT REMOVED AND REPLACED.SDR JJBA20240315058Shear Tie · crackedCF2 RH SIDE FR24 BTW STR 15-16 SHEAR CLIP CRACKED. ON CF2 RH SIDE FR24 BTW STR 15-16 SEAR CLIP REMOVED AND REPLACED.SDR JJBA20240315057Shear Tie · crackedCF2 RH SIDE FR 24 BTW STR 16R-17R SHEAR CLIP CRACKED. ON CF2 RH SIDE FR24 BTW STR 16R-17R SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240314052Floorbeam · corrodedAT FR61 RH INBD FLOOR T SUPPORT FOUND CORRODED. AT FR61 , RH INBD FLOOR T SUPPORT BLENDED AND FOUND OUT OF LIMIT. AT FR61 RH FLOOR T SUPPORT INBD REMOVED FOR REPLACEMENT. AT FR61 RH FLOOR T SUPPORT INBD REPLACED WITH NEW ONESDR JJBA20240314051Floorbeam · corrodedAT FR61 RH OUTBD FLOOR T SUPPORT FOUND CORRODED. AT FR61 RH OUTBD FLOOR T SUPPORT BLENDED AND FOUND OUT OF LIMIT. AT FR61 RH OUTBD FLOOR SUPPORT REMOVED FOR REPLACEMENT. AT FR61 RH OUTBD FLOOR T SUPPORT REPLACED WITH NEW ONESDR JJBA20240304087Shear Tie · crackedCF2 LH SIDE FR24 BTW STR 16-17 SHEAR CLIP CRACKED. AT CF2, LH SIDE FR24 BTW STR 16-17 SHEAR CLIP REMOVED FOR REPLACEMENT. AT CF2, LH SIDE FR24 BTW STR 16-17, SHEAR CLP REPLACEDSDR JJBA20240304086Shear Tie · crackedCF2, LH SIDE FR25 BTW STR 15-16 SHEAR CLIP CRACKED. AT CF2, LH SIDE FR25 BTW STR 15-16 SHEAR CLIP REMOVED FOR REPLACEMENT. AT CF2 LH SIDE FR25 BTW STR 15-16, SHEAR CLIP REPLACEDSDR JJBA20240304085Shear Tie · crackedCF2 LH SIDE FR 24 BTW STR 15-16 SHEAR CLIP CRACKED. AT CF2 LH SIDE FR 24 BTW STR 15-16, SHEAR CLIP REMOVED FOR REPLACEMENT. AT CF2 LH SIDE FR24 BTW STR 15-16, SHEAR CLIP REPLACEDSDR JJBA20240322080Gusset · corrodedRH GUSSET TOILET BTW FR 59-61 CORRODED. RH GUSSET BTW FR 49-61 BLENDED OUT OF LIMIT. RH GUSSET BTW FR 59-61 REPLACEDSDR JJBA20240304023Structure · corrodedRF1, CARGO DOOR SURROUND STRUCTURE FWD L-SHAPE AT FR65 FOUND CORRODED. RF1, CARGO DOOR SURROUND STRUCTURE FWD L-SHAPE AT FR65 FOUND CORROSION OUT OF LIMITS. REMOVED SPLICE AND LOWER SEGMENT OF FR65 FOR REPAIR. REPAIR COMPLETEDSDR JJBA20240304011Crossbeam · corrodedCF2, MIDDLE ALLEY CROSSBEAM ON FLOOR STRUCTURE AT FR29 FOUND CORRODED. AT CF2, MIDDLE ALLEY CROSSBEAM AT FR29, REMOVED FOR INVESTIGATION. AT CF2 MIDDLE ALLEY CROSSBEAM AT FR29 BLENDED OUT OF LIMITS. CF2, MIDDLE ALLEY CROSSBEAM ON FLOOR STRUCTURE AT FR29 INSTALSDR JJBA20240304005Floor Support · crackedCF1, CRACKS (3X) FOUND ON LH OMEGA BEAM #1 FLOOR STRUCTURE BTW FR18-24. LH OMEGA BEAM #1 BTW FR16-24 REMOVED FOR REPLACEMENT. NEW OMEGA BEAM #1 BTW FR16-24 INSTALLEDSDR JJBA20240304004Gusset · corrodedCF1, LH GUSSET #1 BTW FR 18-24 FOUND CORRODED. REMOVED AND REPLACED LH GUSSET #1 BTW FR 18-24 AND INSTALLEDSDR JJBA20240227062Extinguisher · emptyLAV AUTO DISCHARGE FIRE EXTINGUISHER FOUND EMPTY. REMOVED AND REPLACED LAV FIRE EXTINGUISHER.SDR JJBA20240404008Actuator · wornSTICK PUSHER ACTUATOR CABLE WORN (BROKEN WIRE) FLAT SPOT. STICK PUSHER ACTUATOR REPLACEDSDR JJBA20240226061Lamp · inoperativePANEL 263ALC EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED AISLE EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR JJBA20240404005Channel · crackedCF1 ON ON OMEGA BEAM QTY X2 DIAGONAL ANGLES CRACKED BTW FR18-19 CF1 L/H OMEGA BEAM 2 DIAGONAL ANGLES HAVE BEEN REPLACED, ONE WITH A NEW ANGLE AND THE OTHER ONE WITH A REPAIR PART FABRICATED. BOTH INSTALLED.SDR JJBA20240306033Angle · bentRF1, LH ANGLE POST CARGO DOOR ENTRANCE FLOOR STRUCTURE AT FR66 FOUND BENT. RF1, LH ANGLE POST CARGO DOOR ENTRANCE FLOOR STRUCTURE AT FR66 REMOVED FOR REPLACEMENT. LH ANGLE POST CARGO DOOR ENTRANCE NEW PART HOLES TRANSFERRED. LH ANGLE POST CARGO DOOR ENTRANCE NSDR JJBA20240306032Angle · crackedRF1, LH ANGLE CARGO DOOR ENTRANCE FLOOR STRUCTURE AT FR 66 FOUND CRACKED. RF1, LH ANGLE CARGO DOOR ENTRANCE DOOR STRUCTURE AT FR66 REMOVED FOR REPLACEMENT. LH ANGLE CARGO DOOR ENTRANCE AT FR66, NEW CARGO DOOR ENTRANCE AT FR66, NEW PART HOLES TRANSFERRED. LH CASDR JJBA20240306030Skin · corrodedRF1, CORROSION FOUND BELLY SKIN BTW FR 61-62 AND BTW STR 21L-21R AROUND DRAIN FITTINGS. BELLY SKIN FR61-62 STR 21L-21R REPAIREDSDR JJBA20240306028Angle · corrodedRF1, CARGO DOOR SURROUND STRUCTURE AFT L-SHAPE AT FR 68 FOUND CORRODED. RF1, CARGO DOOR SURROUND STRUCTURE AFT L-SHAPE AT FR68 FOUND OUT OF LIMITS. RF1, AFT L-SHAPE AT FR68 REPAIR COMPLETED AND INSTALLED.SDR JJBA20240304066Shear Tie · crackedCF1, FRAME 16 RH SHEAR CLIP FOUND CRACKED BTW STR 16R-17R. IN CF1 AT FR16 BTW STR 16R-17R. SHEAR CLIP REPLACED WITH MADE REPAIR PART LOCALLY FABRICATED.SDR JJBA20240304064Shear Tie · crackedCF4, FRAME 61, LH SHEAR CLIP FOUND CRACKED BTW STR 6L-7L. LH SHEAR CLIP FR61 BTW STR 6L-7L REPLACED WITH NEW SHEAR CLIP.SDR JJBA20240306035Floor Support · crackedCF2, CRACKS (3) FOUND ON LH OMEGA BEAM #3 FLOOR STRUCTURE BTW FR 29-36. AFTER NDT INSPECTION, CRACKS (3) CONFIRMED ON LH OMEGA BEAM #3 AT FR33, 34, AND 35. AT CF2, ON LH OMEGA BEAM #3 BTW FR 29-36 3X ANGLES REPAIR FABRICATED. AT CF2, ON LH OMEGA BEAM #3 AT FR3SDR JJBA20240306034Angle · bentRF1, LH ANGLE POST CARGO DOOR ENTRANCE FLOOR STRUCTURE AT FR67 FOUND BENT. RF1, ANGLE POST CARGO DOOR ENTRANCE FLOOR STRUCTURE AT FR67 REMOVED FOR REPLACEMENT. RF1, LH ANGLE POST CARGO DOOR ENTRANCE AT FR67 NEW PART HOLES TRANSFERRED. RF1, LH ANGLE POST CARGO SDR JJBA20240306031Beam · corrodedRF1, LOWER BEAM OF CARGO DOOR SURROUND STRUCTURE BTW FR 65-68 FOUND CORRODED. RF1, LOWER BEAM OF CARGO DOOR SURROUND STRUCTURE BTW FR 65-68 LH REMOVED FOR ACCESS. BEAM SURROUND STRUCTURE BTW FR65-68 LH FOUND OUT OF LIMITS. RF1, LOWER BEAM DOOR SURRPUNT BTW FR SDR JJBA20240304025Gusset · corrodedAFTER REMOVAL OF LH GUSSET BTW FR 59-61, OMEGA BEAM FOUND CORRODED BTW FR60-61. LH OMEGA BEAM BTW FR 60-61, CUTOUT MADE FOR BEAM REPAIR. LH OMEGA BEAM REPAIRED BTW FR 60-61SDR JJBA20240304016Tee Angle · corrodedRF1, CORROSION FOUND ON AFT T ANGLE LOWER CARGO DOOR SURROUND STRUCTURE AT FR68. RF1, AFT T ANGLE LOWER CARGO DOOR SURROUND STRUCTURE AT FR68 REMOVED FOR ACCESS. R-ANGLE AT FR68 FOUND OUT OF LIMITS. T-ANGLE A FR68 REPLACEDSDR JJBA20240304014Doubler · damagedLH ENGINE AIR INTAKE REAR BULKHEAD TOP DOUBLER FROM COWL ALIGNMENT PIN DAMAGED. LH ENGINE AIR INTAKE REAR BULKHEAD TOP DOUBLER FOR COWL ALIGNMENT PAN REPAIR CARRIED OUT
Back to Embraer EMB-145XR