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 JJBA20240207010Skin · crackedCRACKS SUSPECTED (17X) ON RH SKIN AROUND FASTENERS BTW FR77-80 BTW STR 3R-9R. AFTER NDT INSPECTION, 13X CRACK CONFIRMED. ALL 13X CRACKS REPAIREDSDR JJBA20240202003Intercostal · crackedRF1, UPPER I/COSTAL OF CARGO DOOR MECHANISM AT STR 4 BTW FR 67-68 FOUND CRACKED. UPPER I/COSTAL REMOVED AND REPLACEDSDR JJBA20240130061Shear Tie · crackedAT RF1, FRAME 62, RH SIDE SHEAR CLIP BTW STR 6R-8R FOUND CRACKED. AT RF1, FR62 RH SIDE SHEAR CLIP REPLACED BTW STR 6RSDR JJBA20240130056Doubler · corrodedTRACE OF CORROSION FOUND ON INNER DOUBLER AT ELT ANTENNA LOCATION. INNER DOUBLER REMOVED AND REFABRICATED AND INSTALLEDSDR JJBA20240130051Intercostal · crackedRF1, VERTICAL I/COSTAL OF CARGO DOOR MECHANISM BTW STR 4-5 BTW FR67-68 FOUND CRACKED. I/COSTAL REMOVED AND REPLACEDSDR JJBA20240130049Intercostal · crackedRF1, LOWER 1/COSTAL OF CARGO DOOR MECHANISM, AT STR 5 BTW FR 67-68 FOUND CRACKED. LOWER 1/COSTAL REMOVED AND REPLACEDSDR JJBA20240207017Skin · crackedCRACKS SUSPECTED (13X) ON LH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3L-9L. AFTER NDT INSPECTION, 11X CRACKS ONLY CONFIRMED. ALL 11X CRACKS REPAIRED.SDR JJBA20240130048Floor Support · corrodedCF1, CORROSION FOUND ON RH OMEGA BEAM AT FR23 ON FLOOR STRUCTURE AREA. CORROSION LEVEL 1. REPAIRED.SDR JJBA20240125042Shear Tie · crackedAT RF1, FRAME 71, LH U/FLOOR SHEAR CLIP BTW STR 17L-18L FOUND CRACKED. AT RF1, FR71, LH U/FLOOR SHEAR CLIP REPLACED BTW STR 17L-18LSDR JJBA20240125041Shear Tie · crackedAT RF1, FRAME 67, LH SIDE SHEAR CLIP BTW STR 6L-7L FOUND CRACKED. SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240125040Floor Support · corrodedAT CF IV, CORROSION FOUND ON RH SILL #6 BTW FR 52-59 IN FLOOR STRUCTURE AREA. RH SILL #6 REPLACEDSDR JJBA20240125038Support Bracket · brokenLH PACK VALVE ANTI-ROTATION SUPPORT BRACKET IS BROKEN ON FUSE. LH PACK VALVE ANTI-ROTATION SUPPORT BRACKET REMOVED AND REPLACED.SDR JJBA20240124034Gusset · corrodedCF4, MIDDLE GUSSET IN TOILET AREA BTW FR 59-61 FOUND CORRODED. CTR GUSSET REMOVED AND REPLACEDSDR JJBA20240124033Shear Tie · crackedCF1, FRAME 16, RH SHEAR CLIP FOUND CRACKED BTW STR 16R-17R. FR16, RH SHEAR CLIP BTW STR 16-17 REMOVED AND REPLACEDSDR JJBA20240124032Shear Tie · crackedCF1, FRAME 16, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. FR16, RH SHEAR CLIP BTW STR 15-16 REMOVED AND REPLACEDSDR JJBA20240124031Floor Support · corrodedAR CFII, CORROSION FOUND ON LH SILL #2 BTW FR23 AND FR30 IN FLOOR STRUCTURE AREA. LH SILL #2 REPLACEDSDR JJBA20240124029Bracket · crackedRF1, LH FR68 REINFORCEMENT BRACKET CARGO DOOR HOLDER FOUND CRACKED. BRACKET REMOVED AND REPLACEDSDR JJBA20240124028Shear Tie · crackedAT RF1, FRAME 73, LH SHEAR CLIP U/FLOOR BTW STR 16L-17L FOUND CRACKED. AT RF1, FR73, LH SHEAR CLIP REPLACED BTW STR 16L-17LSDR JJBA20240124027Shear Tie · crackedAT RF1, FRAME 72, LH SHEAR CLIP U/FLOOR BTW STR 17L-18L FOUND CRACKED. ON RF1, FR 72, LH SHEAR CLIP U/FLOOR BTW STR 17L-18L REPLACED BY NEW ONESDR JJBA20240130054Floor Support · crackedCF2, CRACK FOUND ON CENTER OMEGA BEAM #2 INBD. FLANGE AT FR33 ON FLOOR STRUCTURE AREA. CENTER OMEGA BEAM #2 AT FR33 REPAIREDSDR JJBA20240130050Shear Tie · crackedART RF1, FRAME 68, LH SIDE SHEAR CLIP BTW STR 6L-9L FOUND CRACKED. SHEAR CLIP FR65 REMOVED AND REPLACED.SDR JJBA20240124036Crossbeam · corrodedRF1, RH FR61 INBD CROSSBEAM AT FLOOR LEVEL STRUCTURE FOUND CORRODED. CROSS BEAM REMOVED AND REPLACEDSDR JJBA20240124035Gusset · corrodedCF4, LH GUSSET IN TOILET AREA BTW FR 59-61 FOUND CORRODED. LH GUSSET REMOVED AND REPLACEDSDR JJBA20240124030Shear Tie · crackedCF2, FRAME 25, LH SHEAR CLIP FOUND CRACKED BTW STR 15L-16L. REMOVED AND REPLACED LH FR 25 SHEAR CLIPSDR JJBA20240122025Floor Support · corrodedAT CFIII, CORROSION FOUND ON RH SILL #4 BTW FR 41 AND FR 48 IN FLOOR STRUCTURE AREA. RH SILL #4 REPLACEDSDR JJBA20240122024Floor Support · corrodedAT CFIII, CORROSION FOUND ON LH SILL #4 BTW FR 35 AND FR 42 IN FLOOR STRUCTURE AREA. LH SILL #4 REPLACED.SDR JJBA20240205006Door Frame · corrodedCARGO DOOR SURROUND STRUCTURE FWD L-SHAPE AT FR65 FOUND CORRODED. FWD L-SHAPE REPAIREDSDR JJBA20240202001Shear Tie · crackedCF4, FRAME 58, L SHEAR CLIP FOUND CRACKED BTW STR 15L-16L. CRACKED CF4 FRAME 58 LH SHEAR CLIP BTW STR 15L-16L REMOVED AND REPLACED WITH NEW PART AND SOLID RIVETS.SDR JJBA20240130055Door Frame · corrodedRF1, CARGO DOOR SURROUND STRUCTURE AFT L-SHAPE AT FR 68 FOUND CORRODED. AFT L-SHAPE REPAIRED.SDR JJBA20240125039Support · corrodedAT CFIII, CORROSION FOUND ON LH SILL #6 BTW FR 47 AND FR 53 IN FLOOR STRUCTURE AREA. LH SILL #6 REPLACEDSDR JJBA20240125037Support · corrodedAT CFIII, CORROSION FOUND ON RH SILL #3 BTW FR 35 AND FR 42 IN FLOOR STRUCTURE AREA. RH SILL #3 REPLACEDSDR JJBA20240117023Skin · dentedDENT FOUND ON MAIN DOOR AFT LOWER CORNER AREA LOCATION: 18 INCH FROM LOWER EDGE AND 4 INCH FROM AFT EDGE. MAIN DOOR SKIN REPAIRED WITH A DOUBLERSDR JJBA20240115011Lamp · inoperativeWING TO FUSELAGE FRONT FAIRING LH EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING. OPS CHECK SAT.SDR JJBA20240207013Shear Tie · crackedCF2, FRAME 24, RH SHEAR CLIP FOUND CRACKED BTW STR 16R-16R. CRACKED CF2 FRAME 24 RH SHEAR CLIP BTW STR 16-17R REMOVED FOR REPLACEMENT. CRACKED CF2 FRAME 24 RH SHEAR CLIP BTW STR 16-17R REPLACED AND INSTALLED WITH NEW PART AND SOLID RIVETS.SDR JJBA20240207012Shear Tie · crackedCF2, FRAME 27, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. CRACKED CF2 FRAME 27, RH SHEAR CLIP REMOVED FOR REPLACEMENT. CRACKED CF2, FRAME 27 RH SHEAR CLIP BTW STR 15-16R REPLACED AND INSTALLED WITH NEW PART AND SOLID RIVETSSDR JJBA20240207011Shear Tie · crackedCF2, FRAME 24, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. CRACKED CF2 FRAME 24 RH SHEAR CLIP REMOVED FOR REPLACEMENT. CRACKED CF2 FRAME 24 RH SHEAR CLIP BTW STR 15-16R REPLACED AND INSTALLED WITH NEW PART AND SOLID RIVETS.SDR JJBA20240124026Floor Support · corrodedAT CFII, CORROSION FOUND ON LH SILL #3 BTW FR 29 AND FR 36 IN FLOOR STRUCTURE AREA. LH SILL #3 REMOVED AND REPLACEDSDR JJBA20240117020Stringer · corrodedCF4 IN, SURFACE CORROSION FOUND ON RH STRINGER 20R BTW STR FR 57-58. SKIN AND STRINGER 20R REPAIREDSDR JJBA20240115010Battery · inoperativeMCD EMERGENCY LIGHT OUT. REMOVED AND REPLACED MCD EMERGENCY LIGHT ASSEMBLY & BULB. OPS CHECK FAILED. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY NO 1. LIGHT OPS CHECK FAIL. FOUND BROKEN WIRE AT MCD HINGE POINT. REPAIRED WIRING. LIGHT OPS CHECK GOOD.SDR JJBA20240115009Unknown · unknownFOUND MAIN DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE INTERMITTENTLY. REMOVED MAIN DOOR EXTERNAL EMERGENCY LIGHT ASSEMBLY TO BEGIN. FOUND ISSUE TO BE THE CONTACTORS INSIDE HOUSING AND WIRING HARNESS END TERMINAL. INSTALLED EMERGENCY LIGHT ASSEMBLY ON MAIN CABINSDR JJBA20240207009Frame · corrodedRF1, LH FR61 SIDE REINFORCEMENT DOUBLER AT FR61 BTW STR 7L-16L FOUND CORRODED. IN RF1, AT FR61, LH SIDE REINFORCEMENT DOUBLER BTW STR 7L-16L BLENDED AND FOUND OUT OF LIMITS. RF1, LH SIDE REINFORCEMENT DOUBLER FR61 BTW STR 7L-16L REMOVED FOR REPLACEMENT. RF1, LSDR JJBA20240205004Doubler · corrodedRF1, RH FR61 SIDE REINFORCEMENT DOUBLER AT FR61 BTW STR 7R-16R FOUND CORRODED. IN RF1, AT FR61, SIDE REINFORCEMENT DOUBLER BTW STR 7R-16R BLENDED OUT OF LIMIT. RF1, RH SIDE REINFORCEMENT DOUBLER AT FR61 BTW STR 7R-16R REMOVED FOR REPLACEMENT. INS RF1, RH FR61 SDR JJBA20240117022Skin · chafedRF1 EXT, CHAFFING FOUND ON LH SKIN INSIDE PYLON AREA BTW FR 67-68 AND BTW STR 7L-8L. SKIN REPAIRED WITH A DOUBLERSDR JJBA20240117021Fairing · crackedRH WING, AT TOP WING TO BODY FAIRING, ANGLE AFT SPAR II CRACKED. ANGLE REPLACEDSDR JJBA20240115017Unknown · unknownAFTER REMOVAL OF CTR GUSSET, OMEGA BEAM FOUND CORRODED AT FR 59 (AROUND ANCHOR NUT). BEAM REPAIRED WITH A DOUBLER. CORROSION LEVEL 1.SDR JJBA20240115016Bulkhead · crackedRH MLG WHEEL WELL, AFT BULKHEAD CRACKED. REPLACED WITH NEW PART.SDR JJBA20240115015Unknown · unknownLH MLG WHEEL WELL, AFT BULKHEAD CRACKED. PART REMOVED AND REPLACED.SDR JJBA20240102036Lamp · inoperativeMAIN DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20240102035Battery Pack · inoperativeRH FWD WING EMERGENCY LIGHT OUT. FOUND RH FWD WING, SERVICE DOOR EXIT SIGN, AND FWD LWR RH EMERGENCY EXIT SIGN DIMMING UNTIL OFF. REMOVED AND REPLACED #2 EMERGENCY LIGHT BATTERY. OPS CHECK SAT.SDR JJBA20240108005Unknown · unknownSERVICE DOOR, FUSELAGE LINING AFT MID SUPPORT CRACKED. SUPPORT ANGLE REMOVED AND REPLACED
Back to Embraer EMB-145XR