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 JJBA20241223047Inverter · inoperativeRH EMERGENCY EXIT ROW AFT EXIT SIGN INOPERATIVE. REMOVED AND REPLACED EXIT MARKING ASSEMBLY. OPS CHECK FAILED. REINSTALLED ORIGINAL ASSEMBLY AND REMOVED AND REPLACED #5. OPS CHECK SAT.SDR JJBA20241223035Valve · intermittentON CLIMB OUT, BLEED 1 OVERTEMP FOLLOWED BY BLEED 2 OVERTEMP, BLEED 1 & 2 VALVE FAIL MESSAGE ASSOCIATED WITH WING 1 & 2 ANTI ICE FAIL MESSAGE. FOUND PACK 1 VALVE TO BE INTERMITTENTLY OPEN & CLOSE UNCOMMANDED. R & R NR 1 PACK VALVE. OPS CHK SAT. PERFORMED AIR BLSDR JJBA20241223051Beam · corrodedCF1, SERVICE DOOR ENTRANCE LOWER BEAM BTW FR 20-22 FOUND CORRODED. ON CF1, SERVICE DOOR ENTRANCE LOWER BEAM BTW FR 20-22 REMOVED FOR REPLACEMENT, BLENDED OUT OF LIMIT. ON CF1, SERVICE DOOR ENTRANCE LOWER BEAM BTW FR 20-22 INSTALLED AT SERVICE DOOR SEAL BOTTOM SDR JJBA20241223053Skin · dentedFF2, DENT FOUND ON SKIN UNDER EXTERNAL POWER RECEPTACLE ACCESS PANEL BTW FR 6-7 ON LH SIDE. FF2, ON SKIN UNDER EXTERNAL POWER RECEPTACLE ACCESS PANEL BTW FR 6-7 ON LH SIDE, DENT FOUND OUT OF LIMMIT. FF2, SKIN UNDER EXTERNAL POWER RECEPTACLE ACCESS PANEL BTW FRSDR JJBA20241223050Plate · crackedNOSE LANDING GEAR W/W, PLATE 123-01754-001 CRACKED. NOSE LANDING GEAR W/W PLATE 123-01754-001 REMOVED AND REPLACEDSDR JJBA20241219046Floor Support · corrodedCF4, CENTER OMEGA BEAM FOUND CORRODED BTW FR 60-61. REPAIR DOUBLER ON CENTER FUSE IV CENTER OMEGA BEAM ON UPPER SURFACE BTW FR 60-61SDR JJBA20241219045Floorbeam · corrodedCF1, CENTER CROSS BEAM AT FR20 FOUND CORRODED. CROSS BEAM FABRICATED WITH AN ALTERNATE MATERIAL. CROSS BEAM REPLACED WITH FABRICATED PARTSDR JJBA20241219041Floor Support · corrodedCF3, LH OMEGA BEAM OUTBD STUB ANGLE BTW FR 46-50 FOUND CORRODED. LH OMEGA BEAM OUTBD STUB ANGLE BTW FR46-50 BLENDED OUT OF LIMITS. LH OMEGA BEAM OUTBD STUB ANGLE REMOVED FOR REPLACEMENT. NEW OMEGA BEAM OUTBD STUB ANGLES INSTALLED AND REPLACEDSDR JJBA20241219034Tire · failedAIRCRAFT JARRING AT VR. COMPLIED WITH LANDING GEAR TIRE BUST OR TIRE TREAD FAILURE INSPECTION. NO DAMAGE OR DEFECTS NOTED AT THIS TIME.SDR JJBA20241219033Control Lever · inoperativeFLAP FAIL IN FLIGHT. FOLLOWED FIM. FOUND NO DEFECTS. COULD NOT DUPLICATE FLAP FAIL FAULT. CHECKED ELECTRICAL CONNECTORS P1100 AND P110415 IS PROPERLY PLUGGED. OPS CHECK SAT. REMOVED AND REPLACED FLAP SELECTOR LEVER. OPS CHECK SATSDR JJBA20241216032Sealant · overservicedMCD REQUIRES FORCE FROM INSIDE AND OUTSIDE TO OPEN. FOUND EXCESSIVE SEALANT ON FWD TOP CORNER OF SEAL TRIMMED EXCESSIVE SEALANT. OPS CHECKED SAT FROM BOTH OUTSIDE AND INSIDESDR JJBA20241216031Lamp · inoperativeEMERGENCY LIGHT AT SEAT 18D OVERHEAD INOPERATIVE. REMOVED AND REPLACED LAMP AT 18D OVERHEAD. OPS CHECK SAT.SDR JJBA20241210028Shear Tie · crackedTAIL COMPARTMENT, SHEAR CLIP CRACKED AT FRAME 80, BETWEEN STRINGER 5R AND 7R. REMOVED AND REPLACED SHEAR CLIP AT FR80 BTW STR 5R-7RSDR JJBA20241210027Gusset · corrodedCF4, CENTER GUSSET BTW FR 59-62 IN TOILET AREA FOUND CORRODED. CF4, CENTER GUSSET BTW FR 59-62 CORROSION BLENDED AND FOUND OUT OF LIMIT. CENTER GUSSET BTW FR 59-62 REPLACED WITH MADE REPAIR PARTSDR JJBA20241212025Stop Fitting · faultedMCD WILL NOT CLOSE. REMOVED AND REPLACED AFT UPPER STOP SEAT. OPS CHECK SAT.SDR JJBA20241219042Floor Support · crackedCF3, RH OMEGA BEAM OUTBD STUB ANGLE BTW FR46-50 FOUND CRACKED. REMOVED RH OMEGA BEAM OUTBD STUB ANGLE BTW FR46-50 FOR REPLACEMENT. RH OMEGA BEAM OUTBD STUB ANGLE BTW FR46-50 REPAIREDSDR JJBA20241216029Shear Tie · crackedRF1, SHEAR CLIP AT FR72 BTW STR 17L-18L FOUND CRACKED. RF1, SHEAR CLIP AT FR72 BTW STR 17L-18L REMOVED AND REPLACEDSDR JJBA20241209005Battery · inoperativeEMERGENCY EXIT SIGNS BY COCKPIT DOOR INOPERATIVE. REMOVED AND REPLACED BPS #1. OPS CHECK SAT.SDR JJBA20241210009Heat Exchanger · crackedFUMES IN COCKPIT ON DECENT. NO FUMES NOTED IN THE CABIN. PERFORMED HIGH POWER ENGINE RUNS WITH BOTH PACKS RUNNING. RUBBERY SMELL WAS ONLY NOTED DURING ENGINE 1 RUN UP. SMELL ONLY IN COCKPIT NOT IN CABIN. FOUND LH PACK HEAT EXCHANGER CRACKED. REMOVED AND REPLACSDR JJBA20241209007Light · detachedFLOOR PROXIMITY LIGHT STRIP MISSING FROM ALONGSIDE SEAT 20C. REINSTALLED FLOOR PROXIMITY LIGHT STRIP.SDR JJBA20241209008Landing Gear · collapsedNOSE LANDING GEAR COLLAPSED UPON PUSH BACK. INSPECTED NOSE LANDING GEAR FOR ADDITIONAL DAMAGE. PERFORMED DVI OF FLOOR STRUCTURE OF FORWARD FUSELAGE. NO DEFECTS NOTED. PERFORMED DVI OF FWD 1 AND II EXTERIOR SKINS, ONLY DEFECTS NOTED WAS 2 PULLED THRU RIVETS ATSDR JJBA20241230059Shear Tie · crackedCF2, SHEAR CLIP AT FR28 AND BTW STR 15R-16R FOUND CRACKED. SHEAR CLIP FABRICATED. CF2 SHEAR CLIP FR28 BTW 15R-16R REPLACED WITH FABRICATED PART.SDR JJBA20241223052Floor Support · corrodedCORROSION FOUND ON LH CF4 OMEGA BEAM BTW FR 59-62. OMEGA BEAM AT CF4 BTW FR59-62 LH CORRODED BEYOND LIMIT. REWORKED DEPTH OF 30% EXCEEDED INTO TWO LOCATIONS, NOMINAL THICKNESS 0.050, 0.030 REMOVED. LH CF4 OMEGA BEAM BTW FR 59-62 REPAIRED WITH DOUBLERSDR JJBA20241219043Floor Support · crackedCF3, LH OMEGA BEAM INBD STUB ANGLE BTW FR 46-50 FOUND CORRODED. AFTER INVESTIGATION LH OMEGA BEAM INBD STUB ANGLE BTW FR 46-50 FOUND CRACKED. LH OMEGA BEAM INBD STUB ANGLE REMOVED FOR REPLACEMENT. NEW OMEGA INBD STUB ANGLES INSTALLEDSDR JJBA20241219040Floor Support · corrodedCF3, CENTER OMEGA BEAM INBD STUB ANGLE BTW FR 46-50 FOUND CORRODED. CENTER OMEGA BEAM LH STUB ANGLE BTW FR 46-50 BLENDED OUT OF LIMITS. REMOVED AND REPLACED CENTER OMEGA BEAM LH STU ANGLE BTW FR 46-50SDR JJBA20241219038Floor Support · crackedCF1, LH OMEGA BEAM INBD FLANGE, CRACK SUSPECTED AT FR21-22. 2 REPAIR DOUBLERS ON LH CENTER FUSE I OMEGA BEAM, ON INBD FLANGE AT FR 21 & 22.SDR JJBA20241209018Support · corrodedCF4, RH SILL BTW FR53-59 FOUND CORRODED. ON CF4, RH SILL BTW FR 53-59 BLENDED OUT OF LIMIT. CF4, RH SILL BTW FR 53-59 REMOVED AND REPLACEDSDR JJBA20241209017Bracket · corrodedINBD L-SHAPE BRACKET FOUND HEAVY CORROSION ON LH INBD FLAP. INBD L-SHAPE BRACKET ON LH INBD FLAP BLENDED OUT OF LIMIT. LH INBD FLAP INBD L-SHAPE BRACKET REPLACEDSDR JJBA20241209006A/C Pack · odorDIRTY SOCK SMELL ON DECENT FROM PACK 1. FOLLOWED FIM. DIRTY SOCK SMELL ODOR WAS NOT PRESENT AT THIS TIME. PERFORMED GVI INSPECTION OF THE #1 PACK SYSTEM, NO DEFECTS NOTED. HIGH POWER ENG RUNS PERFORMED. DIRTY SOCK SMELL NOT PRESENT. PERFORMED BORESCOPE INSPECTSDR JJBA20250106006Pin · damagedMLG TRAILING ARM, AXLE PIN HAS ROTATED AND DAMAGES TAILING EDGE ASSEMBLY. MLG MAIN WHEEL AND BRAKE ASSEMBLY REMOVED FOR ACCESS. MLG TRAILING ARM REPLACED. MLG MAIN WHEEL AND BRAKE ASSEMBLY INSTALLED. MLG AUX DOOR INSTALLED. MLG CARDON JOINT AND AXLE PIN REMOVESDR JJBA20241227055Wire · burnedUPON REMOVAL OF STANDBY PITOT PROBE, WE FOUND EVIDENCE OF OVERHEATING ON WIRING AND CONNECTOR P0089. THE WIRE W102-0270-16 REMOVED FROM P0089 AND RELAY K0058 AND REPLACED.SDR JJBA20241209023Shear Tie · crackedCF2, SHEAR CLIP AT FR27 AND BTW STR 15R-16R FOUND CRACKED. CF2, SHEAR CLIP AT FR27 BTW STR 15R-16R REMOVED AND REPLACEDSDR JJBA20241209021Shear Tie · crackedCF2, SHEAR CLIP AT FR26 BTW STR 16R-17R FOUND CRACKED. CF2, SHEAR CLIP AT FR26 BTW STR 16R-17R REMOVED AND REPLACEDSDR JJBA20241209020Floor Support · corrodedOCTOGONAL DOUBLER AT FR20 ON RH OMEGA BEAM FOUND CORRODED. ON CF1, ON RH OMEGA BEAM AT FR20, OCTOGONAL DOUBLER FOUND CORRODED OUT OF LIMITS. ON CF1, ON RH OMEGA BEAM AT FR20, OCTOGONAL DOUBLER REMOVED FOR REPLACEMENT AND NEW DOUBLER FULLY DRILLED. ON CF1 ON RHSDR JJBA20241209019Floor Support · corrodedCF1, OCTOGONAL DOUBLER AT FR22 ON RH OMEGA BEAM CORRODED. ON CF1, ON RH OMEGA BEAM AT FR22 OCTOGONAL DOUBLER FOUND CORRODED OUT OF LIMITS. ON CF1, ON RH OMEGA BEAM AT FR22, OCTOGONAL DOUBLER REMOVED FOR REPLACEMENT AND NEW DOUBLER FULLY DRILLED ON CF1, ON RH OSDR JJBA20241210026Doubler · corrodedFWD BELLY FAIRING, RH EMERGENCY LIGHT 191JL, DOUBLER FOUND CORRODED. FWD BELLY FAIRING, RH EMERGENCY LIGHT 191JL DOUBLER REMOVED FOR ACCESS. DOUBLER FOUND CORRODED OUT OF LIMITS. ON FWD BELLY FAIRING, RH EMERGENCY LIGHT 191JL DOUBLER REPLACED.SDR JJBA20241209024Shear Tie · crackedCF2, SHEAR CLIP AT FR25 AND BTW STR 15R-16R FOUND CRACKED. CF2, SHEAR CLIP FR25 BTW STR 15R-16R REMOVED AND REPLACEDSDR JJBA20241209022Floor Support · crackedCF1, ANGLE ON LH OMEGA BEAM BTW FR 19-20 FOUND CRACKED. AT CF1, ANGLE ON LH OMEGA BEAM BTW FR 19-20 ANGLE REPLACEDSDR JJBA20241206003Actuator · inoperativeLANDING GEAR / LEVER DISAGREE EICAS WARNING ON GEAR RETRACTION. RIGHT MAIN GEAR DID NOT RETRACT. REMOVED AND REPLACED RH MANEUVERING ACTUATOR. OPS CHECK SAT. GEAR SWING SAT. LEAK CHECK SAT. ORIGINAL SUBMISSION DATE: 12/6/2024SDR JJBA20241204004Seal · damagedMCD GETS STUCK WHEN OPENING. REPAIRED MAIN CABIN DOOR CUT OUT SEALS. OPS CHECK SATSDR JJBA20241216030Shear Tie · crackedRF1, SHEAR CLIP AT FR62 AND BTW STR 6R-8R FOUND CRACKED. RF1, AT FR62 AND BTW STR 6R-8R SHEAR CLIP REPLACED. RF1 AT FR62 BTW STR 6R-8R GROUND ON SHEAR CLIP REMOVED AND REINSTALLED.SDR JJBA20241209013Bracket · crackedON RH ENG PYLON BLEED AIR PRECCOLER REMOVED, FWD STRUCTURAL BRACKET FOUND CRACKED AND BENT. ON RH ENG PYLON BLEED AIR PRECOOLER FWD STRUCTURE BRACKET REMOVED AND REPLACEDSDR JJBA20241209012Shear Tie · corrodedCF2, SHEAR CLIP AT FR24 AND BTW STR 15R-16R FOUND CRACKED. CF2, SHEAR CLIP FR24 BTW STR 15R-16R REMOVED AND REPLACEDSDR JJBA20241209011Shear Tie · crackedCF2, SHEAR CLIP AT FR24 AND BTW STR 14R-15R FOUND CRACKED. CF2, SHEAR CLIP AT FR24, BTW STR 14R-15R REMOVED AND REPLACEDSDR JJBA20241204002Door Frame · fodMCD TAKES EXCESSIVE EFFORT TO OPENING AND CLOSING. REMOVED DEBRIS FROM DOORWAY AND CLEANED AND LUBED MCD STOPS. OPS CHECK GOOD.SDR JJBA20241204001Display · failedDURING FLIGHT CAPT MFD FAILED TO BLACK SCREEN FOLLOWED BY SMOKE IN THE COCKPIT. REMOVED AND REPLACED CAPT MFD AND OPS CHECK GOOD. NO FURTHER DEFECTS NOTED. NO MEDICAL ATTENTION OR INJURIES REPORTED.SDR JJBA20241202011Battery · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY POWER SUPPLY. OPS CHECK SAT.SDR JJBA20241219044Floor Support · crackedCF4, RH OMEGA BEAM FOUND CORRODED BTW FR60-61. REPAIR DOUBLER ON CENTER FUSE IV RH OMEGA BEAM ON UPPER SURFACE BTW FR60-61SDR JJBA20241209016Shear Tie · corrodedRF1, SHEAR CLIP AT FR73 AND BTW STR 8R-10R FOUND CRACKED. SHEAR CLIP AT FR73 BTW STR 8R-10R REPLACEDSDR JJBA20241209015Support · corrodedCF2, LH SILL BTW FR 29-36 FOUND CORRODED. CF2, LH SILL BTW FR 24-36 BLENDED CORROSION AND FOUND OUT OF LIMIT. CF2, LH SILL BTW FR 29-36 REMOVED AND REPLACED.
Back to Embraer EMB-145XR