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 JJBA20240219044Floor Support · corrodedAT CFII, CORROSION FOUND ON RH SILL #2 BTW FR 29 AND FR 36 IN FLOOR STRUCTURE AREA. RH SILL #2 BTW FR 29 AND FR 36 IN FLOOR STRUCTURE AREA, CORROSION BLENED AND FOUND OUT OF LIMITS. RH SILL #2 BTW FR 29 AND FR 36 REMOVED AND REPLACED.SDR JJBA20240213034Door Sill · corrodedCF1, CORROSION FOUND ON RH SERVICE DOOR AFT SILL FRAME BTW FR 22-23. IN CF1, RH SILL AFT SERVICE DOOR BTW FR 22-23 BLENDED AND FOUND OUT OF LIMIT. RH STILL AFT SERVICE DOOR REPLACEDSDR JJBA20240304002Support · corrodedAT CFIII, CORROSION FOUND ON LH SILL #4 BTW FR35 AND FR42 IN FLOOR STRUCTURE AREA. LH SILL #4 BTW FR35-FR42 BLENDED OUT OF LIMIT. LH SILL #4 BTW FR35-FR42 REPLACEDSDR JJBA20240219046Floor Support · corrodedAT CFIII, CORROSION FOUND ON LH SILL #5 BTW FR 41 AND FR 48 IN FLOOR STRUCTURE AREA. LH SILL #5 BTW FR 41-FR48 BLENDED OUT OF LIMITS. LH SILL #5 BTW FR 41-FR48 REPLACEDSDR JJBA20240219045Floor Support · corrodedAT CFIII, CORROSION FOUND ON LH SILL #6 BTW FR 47 AND FR 53 IN FLOOR STRUCTURE AREA. LH SILL #6 BTW FR 47-FR53 BLENDED OUT OF LIMITS. LH SILL #6 BTW FR 47-FR53 REPLACEDSDR JJBA20240219043Floor Support · corrodedAT CFII, CORROSION FOUND ON LH SILL #3 BTW FR 29 AND FR 36 IN FLOOR STRUCTURE AREA. LH SILL #3 BTW FR 29-FR36 BLENDED OUT OF LIMITS. LH SILL #3 BTW FR 29-FR36 REPLACEDSDR JJBA20240213038Crossbeam · crackedCF1, RH SERVICE DOOR OUTBD CROSSBEAM AT FR20 FOUND CRACKED. RH SERVICE DOOR OUTBD CROSSBEAM AT FR20 REPLACED BY NEW CROSSBEAMSDR JJBA20240209021Ground Wire · unreliableMCD EMERGENCY LIGHT OUT . REMOVED AND REPLACED BULB. OPS CHECK FAIL. REMOVED EMERGENCY LIGHT HOUSING. INSPECTED WIRING AND IDENTIFIED POORLY BONDED GROUND AT TERMINATION OF W734-0002-20. DISSASSMBLED, CLEANED, AND REASSEMBLED TERMINAL AND GROUNDING POINT AND VSDR JJBA20240209022Door · unknownMCD WILL NOT OPEN FROM OUTSIDE. OPEN MAIN CABIN DOOR FROM OUTSIDE, OPS CHECK GOOD.SDR JJBA20240213037Frame · crackedCF4, CRACK FOUND ON LH FRAME 59 AT FLOOR STRUCTURE BTW STR 15L-16L. EXTENDED SPLICE REPAIR ON LH CENTER FUSE 4, ON FRAME 59 BTW STR 15L-16LSDR JJBA20240213035Angle · corrodedCF1, CORROSION FOUND ON AFT RH STEP ANGLE AT FR 23-24 BTW MIDDLE OMEGA BEAM AND OUTBD FLOOR STRUCTURE. CF1, AFT RH STEP ANGLE AT FR 23-24 BTW MID OMEGA BEAM AND OUTBD FLOOR STRUCTURE CORROSION BLENDED AND FOUND OUT OF LIMITS. CF1, RH STEP ANGLE BTW MIDDLE OMEGSDR JJBA20240207019Angle · crackedAT RF1 EXT, LH TOP L-SHAPE ANGLE BTW FR 75-77 AND BTW STR 1L-3L FOUND CRACKED. AT RF1, EXT LH TOP L-SHAPE ANGLE BTW FR 75-77 AND BTW STR 1L-3L REMOVED FOR REPLACEMENT. RF1, EXT LH TOP L-SHAPE ANGLE BTW FR 75-77 AND BTW STR 1L-3L REPLACEDSDR JJBA20240207008Signal Cond Unit · inoperativeFUEL TRANSFER INOPERATIVE. REMOVED AND REPLACED FUEL SIGNAL CONDITIONING UNIT. OPS CHECK GOOD, PUSHED IN CIRCUIT BREAKERS.SDR JJBA20240304074Gusset · corrodedCF4, LH GUSSET IN TOILET AREA BTW FR59-61 FOUND CORRODED. CF4, LH GUSSET IN TOILET AREA BTW FR59-61 BLENDED AND FOUND OUT OF LIMIT. CF4, LH GUSSET IN TOILET AREA BTW FR59-61 REMOVED FOR REPLACEMENT. CF4, LH GUSSET IN TOILET AREA BTW FR59-61 INSTALLED.SDR JJBA20240304072Gusset · corrodedCF4, MIDDLE GUSSET IN TOILET AREA BTW FR59-61 FOUND CORRODED. IN CF4, CTR GUSSET BTW FR 59-61 BLENDED OUT OF LIMITS AND REMOVED FOR REPLACEMENT. IN CF4, CTR GUSSET BTW FR59-61 REPLACED WITH NEW ONE.SDR JJBA20240304065Gusset · corrodedCF4, RH GUSSET IN TOILET AREA BTW FR 59-61 FOUND CORRODED. RH GUSSET IN TOILET AREA BTW FR 59-61 BLENDED OUT OF LIMITS. RH GUSSET BTW FR 59-61 REPLACED BY NEW GUSSETSDR JJBA20240209023Floor Support · crackedCF2, CRACKS (5X) FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BTW FR 23-30. CF2, LH OMEGA BEAM #2 FLOOR STRUCTURE BTW 23-30 REMOVED FOR REPLACEMENT. CF2, LH OMEGA BEAM #2 BTW 23-30 REPLACEDSDR JJBA20240304083Gusset · corrodedAT CFIII, CORROSION FOUND ON LH GUSSET #5 BTW FR38 AND FR 46 IN FLOOR STRUCTURE AREA. IN CFIII, LH GUSSET #5 BTW FR 38-46 BLENDED AND FOUND OUT OF LIMIT. AT CFIII, LH GUSSET #5 BTW FR38 AND FR46 IN FLOOR STRUCTURE AREA REMOVED FOR REPLACEMENT. AT CFIII, LH GUSSDR JJBA20240209030Seat Track · corrodedCORROSION FOUND ON RH SIDE SEAT TRACKS SUPPORT BEAM BTW FR 41-48 AT STR 13R. RH SEAT TRACK SUPPORT BEAM BTW FR 41-48 AT STR 13R CORRODED OUT OF LIMIT. SUPPORT BEAM REMOVED FOR REPLACEMENT. CORRODED RH SIDE SEAT TRACKS SUPPORT BEAM BTW FR 41-48 AT STR 13R AREA SDR JJBA20240207018Support Frame · crackedCF1, CRACK FOUND ON MIDDLE STEP FRAME FLOOR STRUCTURE BTW FR 18-20. CF1, MIDDLE STEP FRAME STRUCTURE BTW FR 18-20 REMOVED AND REPLACED BY NEW ONESDR JJBA20240202064Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT BULB. OPS CHECK GOODSDR JJBA20240209029Bulkhead · crackedAT RH WHEEL WELL, AFT BULKHEAD IS CRACKED. CRACKED RH W/W AFT FAIRING BULKHEAD REMOVED. CRACKED RH W/W AFT BULKHEAD REPLACED AND INSTALLED WITH NEW PART AND SOLID RIVETS. DURING REPLACEMENT OF CRACKED BULKHEAD, LOWER REAR ANGLE FOUND CORRODED OUT OF LIMITS. LOSDR JJBA20240207020Floor Support · corrodedCF1, CORROSION FOUND ON MIDDLE GUSSET FLOOR STRUCTURE BTW FR18-22. CF1, MIDDLE GUSSET FLOOR STRUCTURE BTW FR18-22 BLENDED OUT OF LIMITS. MIDDLE GUSSET REMOVED FOR REPLACEMENT. CF1, NEW MIDDLE GUSSET FLOOR BTW FR 18-22 INSTALLEDSDR JJBA20240202002Bulkhead · crackedAT LH WHEEL WELL, AFT BULKHEAD IS CRACKED. CRACKED LH W/W BULKHEAD REMOVED FOR REPLACEMENT. CRACKED LH W/W AFT BULKHEAD REPLACED. INSTALLED NEW PART AND SOLID RIVETS. DURING REPLACEMENT OF CRACKED BULKHEAD, LOWER REAR ANGLE FOUND CORRODED OF LIMITS. LOWER REARSDR JJBA20240207014Crossbeam · crackedNLG W/WELL, CRACK FOUND ON NLG FWD TOP CROSSBEAM. NLG W/WELL, NLG FWD TOP CROSSBEAM REMOVED FOR REPLACEMENT. NLG W/WELL, NLG FWD NEW TOP CROSSBEAM INSTALLEDSDR JJBA20240130063Door · lack of lubeMAIN CABIN DOOR IS BECOMING STUCK WHILE TRYING TO OPEN. LUBED AND OPS CHECK MAIN CABIN DOOR. OPS CHECK GOODSDR JJBA20240129046Lamp · inoperativeMCD EMERGENCY LIGHT OUT. REMOVED AND REPLACED BULB. OPS CHECK SAT.SDR JJBA20240205007Nut Plate · crackedCRACKS FOUND ON TOP OVERHEAD MIDDLE FRAME AROUND NUTPLATE ON WINDSHIELD SURROUND STRUCTURE COCKPIT AREA. TOP OVERHEAD MIDDLE FR AROUND NUTPLATE ON WINDSHIELD SURROUND STRUCTURE REPAIREDSDR JJBA20240129045Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT ASSEMBLY. OPS CHECK GOOD.SDR JJBA20240209032Floor Support · crackedCF1, CRACKS (3X) FOUND ON LH OMEGA BEAM #1 FLOOR STRUCTURE BTW FR 18-24. REMOVED AND REPLACED OMEGA BEAM CH #1SDR JJBA20240209031Shelf · crackedNLG W/WELL CRACKS FOUND ON NLG TOP SHELF ASSEMBLY. NLG W/WELL, NLG TOP SHELF ASSY, TOP (2) CUT-OUT DONE. HFEC INSPECTION CARRY OUT ON TWO CUT-OUT, NO CRACK INDICATION FOUND. NLG TOP SHELF ASSEMBLY SHIM DOUBLERS AND FILLER LOCALLY FABRICATED AND ISNTALLED.SDR JJBA20240209028Floorbeam · corrodedCF1, LH OUTBD CROSSBEAM AT FR22 ON FLOOR STRUCTURE FOUND CORRODED. LH OUTBD CROSSBEAM AT FR22 BLENDED OUT OF LIMITS. REMOVED FOR REPLACEMENT. NEW CROSSBEAM AT FR22 INSTALLEDSDR JJBA20240209027Floor Support · corrodedCF1, CORROSION FOUND AT MANY PLACES ON AFT DIGITAL FLOOR STRUCTURE BTW FR 17-18. AFT DIGITAL FLOOR STRUCTURE BTW FR 17-18 BLENDED OUT OF LIMITS. REMOVED AND REPLACED AFTDIGITAL FLOOR STRUCTURE BTW FR 17-18SDR JJBA20240209026Floor Support · crackedCF1 (4X) ANGLES FOUND CRACKED U/FLOOR ON L AND MIDDLE OMEGA BEAM AT FWD AND AFT DIGITAL PLATE JUNCTION. AFTER INVESTIGATION LH INBD ANGLE ON LH OMEGA BEAM #1, ANGLE NOT FOUND CRACKED. REMOVED AND REPLACED 2 ANGLES. 1X ON LH OMEGA BEAM #1 OUTBD. 2X ON MIDDLE #1SDR JJBA20240209025Gusset · corrodedCF1, LH GUSSET #1 BTW FR 18-24 FOUND CORRODED. LH GUSSET #1 BLENDED OUT OF LIMITS. REMOVED AND REPLACED.SDR JJBA20240129047Wire · brokenRT EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH EXT EMERGENCY LIGHT LAMP AND ASSY. NO FIX. VERIFIED CONTINUITY FROM P0782 PIN 7 TO GROUND GS8524, NO DEFECTS NOTED, EWIS GOOD ON EXTERNAL FUSELAGE. NO VOLTAGE AT J0782 PIN 7 TO GROUND. SWAPPED BASDR JJBA20240126044Terminal · intermittentMCD EMERGENCY LIGHT INTERMITTENT (BAD GROUND). REPLACED GROUND WIRE RING TERMINAL. PERFORMED OPS CHECK OF MCD EMERGENCY LIGHT. OPS CHECK GOOD.SDR JJBA20240126043Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPS CHECK GOOD.SDR JJBA20240130062Bracket · crackedON LH PRECOOLER REMOVAL, LH PRECOOLER FWD STRUCTURE BRACKET FOUND CRACKED AND BENT. LH FWD PRECOOLER STRUCTURE BRACKET REMOVED AND REPLACEDSDR JJBA20240130059Cowling · crackedLH LOWER COWL, AFT LIP CRACKED. LH ENG LOWER COWL LIP REPLACEDSDR JJBA20240205005Gusset · corrodedCF4, RH GUSSET IN TOILET AREA BTW FR 59-61 FOUND CORRODED. IN CF4, RH GUSSET BLENDED AND FOUND OUT OF LIMIT. IN CF4, RH GUSSET BTW FR 59-61 REPLACED WITH NEW ONESDR JJBA20240130060Doubler · corrodedCF1, CORROSION FOUND ON RH DOUBLERS FLOOR STRUCTURE AT FR20 AND FR22. RH DOUBLER REMOVED AND REPLACEDSDR JJBA20240130058Floor Support · crackedCF2, CRACK FOUND ON CENTER OMEGA BEAM #1 INBD FLANGE AT FR25 ON FLOOR STRUCTURE AREA. REPAIR DOUBLER FABRICATED FOR OMEGA BEAM #1 INBD FLANGE AT FR25. CENTER OMEGA BEAM #1 FLANGE AT FR25 REPAIRED.SDR JJBA20240130057Floor Support · crackedCF2, CRACK FOUND ON CENTER OMEGA BEAM #1 INBD. FLANGE AT FR27 ON FLOOR STRUCTURE. REPAIR DOUBLER FABRICATED FOR OMEGA BEAM #1 INBD FLANGE AT FR27. CENTER OMEGA BEAM #1 INBD FLANGE AT FR27 REPAIRED.SDR JJBA20240130052Doubler · corrodedRF1, RH FR 65 REINFORCEMENT FRAME DOUBLER AT FLOOR LEVEL BTW STR 15R-16R FOUND CORRODED. ON RF1, RH FR65 REINFORCEMENT FRAME DOUBLER AT FLOOR LEVEL BTW STR 15R-16R REPLACEDSDR JJBA20240213036Intercostal · crackedRF1, RH FWD I/COSTAL CARGO DOOR MECH BTW STR 4R-5R AT FR 62 FOUND CRACKED. RF1, RH FWD I/COSTAL CARGO DOOR MECH BTW STR 4R-5R AT FR 62 REMOVED AND REPLACEDSDR JJBA20240209024Floor Support · crackedCF2, CRACKS (5X) FOUND ON LH OMEGA BEAM #3 FLOOR STRUCTURE BTW 29-36. CF2 ON LH OMEGA BEAM #3 FLOOR STRUCTURE BTW FR 29-36, REMOVED FOR REPLACEMENT. CF2 ON LH OMEGA BEAM #3 FLOOR STRUCTURE BTW FR 29-36, ALL PARTS DRILLED AND READY TO INSTALL. CF2, LH OMEGA BEASDR JJBA20240207016Cup · corrodedCF4, CORROSION FOUND ON TOILET WASTE CUP U/FLOOR BTW FR 60-61 AND BTW STR 18R-20R. REPLACED PROFILE Z TOILET + WASTE CUPSDR JJBA20240207015Crossbeam · crackedNLG W/WELL, CRACK FOUND ON NLG AFT TOP CROSSBEAM. NLG W/WELL, NLG AFT TOP CROSSBEAM REMOVED FOR REPLACEMENT. NLG W/WELL, NEW CROSSBEAM DRILLED AND INSTALLEDSDR JJBA20240130053Floor Support · corrodedAFTER REMOVAL OF CTR GUSSET BTW FR 59-61, OMEGA BEAM FOUND CORRODED AT FR 59 (AROUND ANCHOR NUT). BEAM REPAIRED WITH A DOUBLER. CORROSION LEVEL 1.
Back to Embraer EMB-145XR