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 JJBA20210722009Angle · crackedNLG BAY HYDRAULIC COMPARTMENT AT COCKPIT FLOOR LEVEL WEB-FRAME 6 LOWER RH REINFORCEMENT ANGLE FOUND CRACKED. CUT OUT ON REINFORCEMENT PERFORMED AND PARTS FABRICATED. REINFORCEMENT ANGLE IN NLG BAY HYDRAULIC COMP. FLOOR LEVEL WEB FR 6 REPAIRED WITH FILLER AND DSDR JJBA2021008042008Floor Support · damaged1 RIVET FOUND DAMAGE ON LH OMEGA BEAM INBD AT FR 23. AFTER INVESTIGATION OMEGA BEAM FOUND CRACKED AT RIVET LOCATION INBD AT FR 23. LH OMEGA BEAM INBD AT FR 23 REPAIRED WITH DOUBLER.SDR JJBA20210722006Frame · crackedRF1 LH FR72 CRACKED AT SILL AND FR JUNCTION, BTW LH STR 14-15. RF1 LH FR 71 BTW STR 14-15 REPAIR SPLICE COMPLETED.SDR JJBA20210722005Doubler · not reportedREPAIR DOUBLER ON LH CENTER FUSE 1, BTW FR 20-21 AND BTW STR 11L - 12L. REPAIR DOUBLER ON LH CENTER FUSE 1 BTW FR 20-21 AND STR 11L-12L REMOVED FOR INVESTIGATION. AFTER INVESTIGATION, CUT OUT NOT CONFORM. CUT OUT ON L/H FUSE, CF1, BTW FR20-21 AND BTW STR 11L-1SDR JJBA20210722023Valve · malfunctionedPACK 1 VALVE CLOSED MESSAGE 4 TIMES DURING CLIMB. INSPECTED AND FOUND PACK #1 HEAT EXCHANGER HOSE TORN. R&R PACK #1 EAT EXCHANGER HOSE, PACK OPS CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIMESDR JJBA20210722022Battery Pack · inoperativeEMERGENCY LIGHTS WILL NOT LIGHT. R&R EMERGENCY BATTERY PACK NO 3 AND NO 4. OPS CHECK SAT. #4 PN 2013-1A SN 91402 TSN 29997.06 CSN 22944 #3 PN ABS-2013-1A SN 51099 TSN 2674.38 CSN 2428SDR JJBA2021090171071Shear Tie · crackedSHEAR CLIP CRACKED IN CARGO BAY ON FR66 BETWEEN STGR 6-7L. REMOVED AND REPLACED SHEAR CLIP IN CARGO BAY FR66 BETWEEN STGR 6-7L.SDR JJBA2021080471004Floor Support · corrodedLH OMEGA BEAM, LWR INBD LIP CORRODED FROM FR 46-53 (LEVEL 2). OMEGA BEAM REPLACED.SDR JJBA2021090179069Door Frame · corrodedCORROSION ON CARGO DOOR AFT FRAME, AFT FACE, AROUND NUT PLATES HOLE. INSTALLED NEW AFT CARGO DOOR FRAME WEB.SDR JJBA20210719021Target · out of adjustLG AIR/GROUND FAIL CAUTION MESSAGE RIGHT AFTER ROTATION FOLLOWED BY ENG 1-2 REV DISAGREE. ADJUSTED NLG DOWNLOCK PROX SWITCH TARGET. OPS CHECK SAT. PERFORMED OPERATIONAL CHECK OF #1 AND #2 T/R. OPS CHECK SAT. NO FAULTS FOUND AT THIS TIME. OPS CHECK SAT ON GEAR SDR JJBA20210712020Doubler · unknownINSPECT THE FWD PRESSURE BULKHEAD TO LOCATE 9 CIRCULAR DOUBLER AND REMOVE DOUBLER. ACCOMPLISH A PERMANENT REPAIR. REMOVED CIRCULAR DOUBLER. DRILLED FASTENER HOLE TO OVERSIZED. TREATED AND PRIMED. RESTOWED TO ORIGINAL FINISH. REINSTALLED REMOVED DOUBLER AS PERMSDR JJBA202107152019Battery Pack · inoperativeEMERGENCY LIGHT INOP AT SEAT 18A. R&R INVERTER ASSY #2 WITH #3. OPS CHECK SAT, RETURNED TO ORIGINAL POSITIONS. FOUND INVERTER ASSY NOT TO BE AT FAULT. FOUND EMERGENCY BATTERY PACK #3 TO BE AT FAULT. R&R EMERGENCY BATTERY #3. OPS CHECK SAT. NO FURTHER DEFECTS NSDR JJBA20210710018Unknown · unknownSMOKE COMING FROM RT DIST PANEL IN COCKPIT. PERFORMED OPERATIONAL CHECK ON COOLING PACKS. NO SMOKE OF FAULTS DETECTED. OPS CHECK GOOD.SDR JJBA20210708017Gusset · corrodedFF2 LH INBD FLOOR GUSSET FOUND CORRODED FR 8-13. DOUBLER CUT. FF2 LH INBD FLOOR GUSSET BTW FR 8-13 REPLACED WITH REPAIR DOUBLER.SDR JJBA20210708015Flange · crackedRH PYLON YOKE UPPER FLANGE HOLE (X1) FOUND WITH CRACK. RH PYLON YOKE UPPER FLANGE HOLE REAMED. AFTER NDT INSPECTION, DAMAGE IS STILL PRESENT AT RH PYLON YOKE UPPER FLANGE. HOLE OVERSIZED AT SECOND PERMISSIBLE DIMENSION (0.421). 2 BUSHINGS LOCALLY FABRICATED. RSDR JJBA2021071508014Skin · corrodedCF1 ON RH FUSE AT FR23 AT LEVEL JUNCTION STRINGER SPLICE STR 16R-17R-18R CORRODED. CORROSION ON STR 16R AND 17R AT FR 23 RH FUSE BLENDED AND FOUND WITHIN LIMIT. NO SIGNIFICANT LOSS OF MATERIAL. CORROSION ON STR 18R AT FR 23 BLENDED, FOUND OUT OF LIMITS. STR 18SDR JJBA20210708011Beam · corrodedCF1 ON LH FUSE OMEGA BEAM LH AND REPAIR ANGLE CORRODED. OMEGA BEAM REPLACED AND INSTALLEDSDR JJBA20250721065Gusset · corrodedRH GUSSET BTW FR 59-61 FOUND CORRODED. RH GUSSET BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. RH GUSSET BTW FR59-61 REMOVED AND REPLACEDSDR JJBA2021071504004Heat Exchanger · inoperativeSMOKE IN CABIN ON ASCENT OCCURRED AROUND 18000 SMOKE DISAPATED ON DECENT. REMOVED ACM #2 DUE TO T/S FOUND ACM TURBINS SHATTERED. REMOVED #2 DUEL HEAT EXCHANGER. INSTALLED #2 DUEL HEAT EXCHANGER AND INSTALLED #2 ACM. OPS CHECK SAT. NO OTHER DEFECTS NOTED.SDR JJBA20210704005Light · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R SERVICE DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20210703012Window Frame · corrodedLH FWD COCKPIT WINDOW FRAME POSSIBLE CORROSION AFT SIDE. REMOVED CORROSION ON LH FWD COCKPIT WINDOW AT AFT SIDE FRAME, NO DAMAGE FOUND, BLENDED AREAS. FOUND TO BE WITHIN LIMITS.SDR JJBA20210702003Light · crackedMCD EXTERNAL EMERGENCY LIGHT CRACKED AND INOPERATIVE. FOUND WIRE TO HAVE AN OPEN ON MCD EMERGENCY LIGHT. R&R WIRE. OPS CHECK SAT. R&R MCD EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20210701002Control Handle · faultedNLG DOORS OPENED IN FLIGHT AT FL 210 AT 265 KTS. REMOVED AND REPLACED NLG DOOR SEQ VALVE (DID NOT FIX). SLAVED IN LGCU (DID NOT FIX). REMOVED AND REPLACED L CONTROL HANDLE PERFORMED GEAR SWINGS. OPS CHECK GOOD. SOLENOID VALVE - PN 2225-0100-003 SN 822 TSN 4374SDR JJBA20210701001Target · out of adjustLG AIR/GND FAIL ON TAKE OFF. NLG WOW PROX SWITCH TARGET FOUND OUT OF ADJUSTMENT. ADJUSTED NLG WOW SWITCH TARGET. BREAKOUT BOX CONNECTED, CHECKED ALL WOW, DOWN LOCKS AND UP LOCKS. OPS CHECK SAT. GEAR SWINGS PERFORMED. ALL CHECKS SATISFACTORY.SDR JJBA20210630046Light · inoperativeMCD EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R MCD EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20210630045Inverter · inoperativeCENTER CABIN EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT INVERTER. REMOVED AND REPLACED EXIT SIGN. OPS CHECK SAT,SDR JJBA20210629008Doubler · corrodedCF 1 ON RH FUSE BTW FR 19-20 SILL ASSEMBLY FWD AND DOUBLER SILL AFT CORRODED. CF1 ON RH FUSE BTW FR 19-20 SILL ASSY FWD CORROSION REMOVED WITHIN LIMITS AND REPROTECTED. LESS THAN .001" REMOVED. DVI INSP C/OUT WITH MAGN GLASS 30X NO FAULT FOUND. CF1 RH SILL AFTSDR JJBA20210629007Flange · corrodedFRAME 65 LOWER FLANGE AT STR 16L CORRODED. FRAME 65 LOWER FLANGE AT STR 16L BLENDED OUT OF LIMIT. CUT OUT ON FR65 LOWER FLANGE AT STR 16L REPAIRED.SDR JJBA20210629006Door Frame · corrodedCORROSION FOUND ON CARGO DOOR FRAME 65 BTW STR 16 & 17. CARGO DOOR FR65 BTW STR 16L AND 17L CORROSION REMOVED OUT OF LIMITS. FR65 CUT AND SPLICE MFG BTW STR 14L-15L. CARGO DOOR FRAME 65 LH BTW STR 14-15 REPAIRED.SDR JJBA20210628043Channel · corrodedCENTER FUSELAGE 4, Y=-479, FRAME 61 TO 58 SIGNS OF CORROSION ON HAT BEAM. REMOVED AND REPLACED GUSSET AT CENTER FUSELAGE 4, 4=-479, FRAME 61-58SDR JJBA20210628042Floor Support · corrodedRH AFT CABIN FRAMES 61-64, SUSPECTED CORROSION AROUND FLOOR SILL. REMOVED AND REPLACED SILL AT RH FLOOR SUPPORT BETWEEN FR 61-64, STR 15R.SDR JJBA2021080427003Floor Support · corrodedCENTER FUSELAGE 4, Y=0.0, FRAME 61 TO 58, SIGNS OF CORROSION HAT BEAM. REMOVED AND REPLACED GUSSET AT FLOOR SUPPORT BETWEEN FR 59 @ FR 61.SDR JJBA20210627044Channel · corrodedCENTER FUSELAGE 4, Y=479, FRAME 60-58 SIGNS OF CORROSION ON HAI BEAM. AFTER EVAL FURTHER HAI BEAM SECTION FOUND TO BE CORRODED IN A 100% ON FASTENERS DRAIN HOLES. REMOVED GUSSET BEAM FROM RH Y=479 AT FR 60-58. INSTALLED GUSSET.SDR JJBA20210626010Support Bracket · crackedFRM SUPPORT BRACKET CRACKED IN AFT CARGO COMP AT AFT BLK HEAD UPPER SURFACE BETWEEN O1L AND O1R, X=24389.5. REMOVED SHEAR CLIP IN AFT CARGO COMP AFT BLK HEAD, FAB SUPPORT BRACKET, SHEAR CLIP. INSTALLED SHEAR CLIP ON AFT CARGO AT BLK HEAD UPPER SURFACE BETWEEN SDR JJBA20210626038Light · misinstalledLH OVER WING EXTERNAL EMERGENCY LIGHT INSTALLED UPSIDE DOWN. PAINT MARKS ARE NOT PRESENT. REPOSITIONED LH OVERWING EXTERNAL EMERGENCY LIGHT.SDR JJBA20210625035Light · inoperativeRH TOP EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R RH TOP EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR JJBA20210624041Stringer · corrodedSERVICE DOOR LOWER STRINGER 16R BETWEEN FRAMES 20 AND 22 RH SHOWS CORROSION EVIDENCE. REMOVED DAMAGE CHANNEL. LOCATED, DRILLED AND INSTALLED NEW CHANNEL AT SERVICES DOOR LOWER CUT OUT BETWEEN FR 20 - FR 22. APPLIED ALODINE, PRIMER AND TOP COAT HOLES AND RIVET SDR JJBA20210624039Support Bracket · crackedFRM SUPPORT BRACKET CRACKED IN AFT CARGO COMP. AT BULK HEAD UPPER SURFACE BETWEEN OIL ANNOIR, X=24389.5. REMOVED SHEAR CLIP IN AFT CARGO COMP. AFT BULK HEAD. FABRICATED SUPPORT BRACKET, SHEAR CLIP MAT USED 7075 T6 .032". INSTALLED SHEAR CLIP ON AFT CARGO AT BUSDR JJBA20210623034Blade · damagedENGINE 1 OUT IN CLIMB, IN FLIGHT SHUT DOWN. CW BORESCOPE INSPECTION. FOUND VERIABLE AND COMPRESSOR BLADES DAMAGED. REMOVED AND REPLACED #1 ENGINE. OPS AND LEAK CHECK GOOD.SDR JJBA2021071521009Floor Support · corrodedSIGNS OF CORROSION LH SILL (UNDER FLOOR) BETWEEN FRM 61 AND FRM 64 ABOVE STGR 16. REMOVED DAMAGE SILL, LOCATED AND DRILLED NEW SILL AT LH FLOOR SUPPORT BETWEEN FR 61-64 STR 16L. APPLIED ALODINE AND PRIME HOLES. INSTALLED NEW SILL AND APPLIED TOP COAT.SDR JJBA20210621040Floor Support · corrodedSIGNS OF CORROSION LH SILL (UPPER FLOOR) BETWEEN FRM 61 AND FRM 64 ABOVE STGR 16. REMOVED DAMAGE SILL, LOCATED AND DRILLED NEW SILL AT LH FLOOR SUPPORT BETWEEN FR 61-64 STR 161. APPLIED ALODINE AND PRIMED HOLES. INSTALLED NEW SILL AND APPLIED TOP COAT.SDR JJBA20210618026Unknown · odorDIRTY SOCK SMELL ON CLIMB OUT AND APPROACH. PERFORMED BOROSCOPE INSPECTION OF COMPRESSOR FLOWPATH EXTENSION FOR FRONT SUMP OIL LEAKAGE. NO DEFECTS NOTED. #1 PERFORMED BACK LIGHT INSPECTION OF ENGINE #1 FOR OIL LEAKAGE. .0 CARBON SEAL, NO FAULT NOTED. PERFORMESDR JJBA20210618025Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. R&R SERVICE DOOR EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20210617024Cabin Pressure · faultedAIRCRAFT FAILED TO PRESSURIZE. PERFORMED CMC AND DFDR DOWNLOAD. PERFORMED PRESSURIZATION CONTROL SYSTEM OPERATIONAL CHECK. OPS CHECK SAT, NO DEFECTS NOTED. PER FDR DOWNLOAD ENGINE BLEEDS WERE IN THE OFF POSITION DURING FLIGHT AND ON DURING APPROACH.SDR JJBA20210616036Floor Support · corrodedCF3, LH OMEGA BEAM LOWER FLANGE CORRODED FROM FR 45-46 TO 52-53. LH OMEGA BEAM LOWER FLANGE FROM FR 45-46 TO 52-53 IS OUT OF LIMIT. LH OMEGA BEAM FR 45-46 TO 52-53 REMOVED FOR REPLACEMENT. LH OMEGA BEAM CROSS BEAM O/B FR49 AND CROSS BEAM MIDDLE FR49-50 REMOVEDSDR JJBA20210616032Frame · corrodedAT RF1, FR65 BTW STR 15-16 LH CORROSION FOUND ON FRAME. AT RF1, FR65 BTW STR 15-16 LH CORROSION ON FRAME REMOVED AND FOUND OUT OF LIMITS. SPLICE FABRICATED. FR 65 CUT BTW STR 13L AND 15L, SPLICE CHANNEL TRIMMED AND FIT TO FRAME 65 SEGMENTS. FR 65 AND SPLICE DRSDR JJBA20210616031Frame · crackedCF4 BTW STR 15L-14L, FR 59 CRACKED. FR 59 REMOVED FOR REPLACEMENT. LH AND RH FRAME SPLICE AND FLOOR SILL RH SIDE AFT OF FR 59 REMOVED FOR ACCESS. CF4 FR59 BTW STR 15L-14L REPLACED BY NEW ONE. LH AND RH FRAME SPLICE AND FLOOR SILL RH SIDE AFT OF FR 59 REINSTALLSDR JJBA20210616030Floor Support · corrodedCF1 BTW FR 21-23, LH BEAM FLOOR SUPPORT LIP CORRODED. CF1 BTW FR 21-23, LH BEAM FOUND CRACKED AFTER INVESTIGATION. CF1 BTW FR 21-23, LH BEAM REPLACED.SDR JJBA20210616029Window Post · crackedFF2 LH COCKPIT WINDSHIELD LATERAL POST TOP EXTERNAL SKIN ONE RIVET HOLE FOUND CRACKED. SKIN CUT OUT DONE. UPPER STIFFENER ABOVE PILOT WINDOW FOUND CRACKED. CRACK ON LH COCKPIT WINDSHIELD LATERAL POST EXTERNAL SKIN REPAIRED. UPPER STIFFNER ABOVE PILOT WINDOW RESDR JJBA20210616028Support · corrodedCF2 RH SILL #1 CORRODED. CF2 RH SIDE FRAME 25 UNDER SILL NO 1 CUT FOR REPAIR. CF2 RH SIDE FRAME 25, BTW STR 15R-16R T BAR REMOVED FOR ACCESS. CF2 RH SIDE FRAME 25 UNDER SILL NO 1 REPAIRED. CF2 RH SIDE FRAME 25, BTW STR 15R-16R T BAR REINSTALLEDD.
Back to Embraer EMB-145XR