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 JJBA20240603069Support · corrodedCORROSION FOUND ON LH SILL #3. LH SILL #3 BLENDED OUT OF LIMIT. LH SILL #3 REMOVED AND REPLACEDSDR JJBA20240603068Support · corrodedLH SILL #2 FOUND CORRODED. LH SILL #2 BLENDED OUT OF LIMIT. LH SILL #2 REMOVED AND REPLACEDSDR JJBA20240522049Skin · scratchedLH EXTERNAL FWD FUSELAGE, SCRATCH FOUND LOWER GPU POWER CONNECTOR AT REPAIR DOUBLER. ON LH EXTERNAL FWD FUSELAGE, LOWER GPU POWER CONNECT AT REPAIR DOUBLER SCRATCH BLEND OUT OF LIMITS. EXISTING DOUBLER REMOVED FOR REPLACEMENT. REPAIR DOUBLER FABRICATED. REPAISDR JJBA20240520040Shear Tie · crackedCF4, LH SHEAR CLIP ON FR56 BTW STR 15L-16L FOUND CRACKED. CF4 LH SHEAR CLIP ON FR56 BTW STR 15L-16L REPLACEDSDR JJBA20240520032Support Angle · crackedRF1, CARGO DOOR LIFTING AND LOWERING MECHANISM AT RH SIDE, UPPER HORIZONTAL SUPPORT ANGLE BTW FR 67-68 AND AT STR 4R FOUND CRACKED. RF1, CARGO DOOR LIFTING AND LOWERING MECHANISM AT RH SIDE UPPER HORIZONTAL SUPPORT ANGLE BTW FR 67-68 AT STR 4R REPLACED.SDR JJBA20240607004Plate · corrodedON CF1, RH OMEGA BEAM PLATES AT FR22 AND 20 CORRODED. ON CF1, RH OMEGA BEAM PLATES AT FR22 AND 20 FOUND CORRODED OUT OF LIMIT. ON CF1, AT FR20 AND 22 AT RH OMEGA BEAM, 2 DOUBLER DRILLED. AT FR1, RH OMEGA BEAM AT FR20 AND 22, DOUBLER REPLACEDSDR JJBA20240520039Tee Angle · corrodedON CF1, LH FUSE T PROFILE AT FR22 CORRODED. ON CF1, LH FUSES T PROFILE AT FR22 CORRODED OUT OF LIMIT. ON CF1, LH FUSELAGE T-PROFILE AT FR22 INSTALLEDSDR JJBA20240520031Gusset · corrodedCF2, UNDERFLOOR, LH GUSSET NO 2 BTW FR 24-30 FOUND CORRODED. CF2, UNDER FLOOR, LH GUSSET #2 BTW FR 24-30 CORROSION BLENDED AND FOUND OUT OF LIMIT. CF2, UNDER FLOOR, LH GUSSET NO 2 BTW FR 14-30 IS REMOVED. CF2, UNDER FLOOR LH GUSSET NO 2 BTW FR 24-FR 30 INSTALLSDR JJBA20240506002Unknown · odorSMELL OF SMOKE IN COCKPIT HAPPENED AFTER LIGHT / MOD TURBULENCE IN CRUSE , AFTER SHUTTING PAC 1 DOWN SMELL WENT AWAY .SMELL WAS NOT PRESENT THE REST OF THE FLIGHT NO VISIBLE SMOKE OR MSGS PRESENT .SMELL ONLY IN COCKPIT .ELECTRICAL SMELL . NOT IN CABIN OR LAV SDR JJBA20240603071Floor Support · corrodedRF1, UNDERFLOOR, LH SILL BTW FR 61-65 FOUND CORRODED. LH SILL BTW FR 61-65 BLENDED AND FOUND OUT OF LIMIT. REMOVED AND REPLACED LH SILL BTW FR 61-65SDR JJBA20240522045Window Frame · crackedCOCKPIT WINDSHIELD OVERHEAD PANEL FR PN 123-07751-005 FOUND CRACKED. LH COCKPIT OVERHEAD PANEL FR PN 123-07751-005 REPAIR PERFORMED.SDR JJBA20240522044Window Frame · crackedCOCKPIT ABOVE RH WINDSHIELD, HORIZONTAL RIB-OVERHEAD PANEL FOUND CRACKED. IN COCKPIT ABOVE RH WINDSHIELF HORIZONTAL RIB-OVERHEAD PANEL REPAIRED AND INSTALLEDSDR JJBA20240522043Shear Tie · crackedRF1, LH SHEAR CLIP AT FR68 BTW STR 8L-7L FOUND CRACKED. RF1, LH SHEAR CLIP AT FR68 BTW STR 8L-7L REMOVED AND REPLACEDSDR JJBA20240520030Latch · brokenFWD FUSELAGE 1, FR 1A LH & RH UPPER RADOME LATCHE FAIRING BROKEN. LH AND RH UPPER RADOME LATCHE REMOVED AND REPLACEDSDR JJBA20240520028Floor Support · crackedCENTER FUSE 3, UNDER FLOOR STRUCTURE, BRACKET RH OMEGA BEAM AT FRAME 41 FOUND CRACKED. IN CF3, UNDER FLOOR STRUCTURE, ON RH OMEGA BEAM AT FR41, SUPPORT BRACKET REPLACEDSDR JJBA20240506003Battery Pack · inoperativeFOUND EMERGENCY LIGH BPS 4 TO BE INOP R&R BPS 4. OPS CHECK SAT.SDR JJBA20240607008Gusset · corrodedCENTER GUSSET BTW FR 59-61 FOUND CORRODED. CENTER GUSSET BTW FR 59-61 REPLACED BY MADE REPAIR PARTSDR JJBA20240603070Gusset · corrodedRH GUSSET BTW FR 59-61 FOUND CORRODED. RH GUSSET BTW FR 59-61 BLENDED AND FOUND OUT OF LIMIT. RH GUSSET BTW FR 59-61 REPLACEDSDR JJBA20240522046Floor Support · corrodedCENTER FUSELAGE IV, UNDERFLOOR, RH GUSSET BTW FRAME 59-61 FOUND CORRODED. CF4 RH GUSSET BTW FR 59-61 REMOVED AND REPLACEDSDR JJBA20240502001Lamp · inoperativeRH EXTERNAL EMERGENCY LIGHT ON FWD LOWER FAIRING INOPERATIVE. REMOVED AND REPLACED RH EXTERNAL EMERGENCY LIGHT BULB. ISSUE REMAINS. RMOVED AND REPLACED RH EXTERNAL LIGHT ASSEMBLY. OPS CHECK SAT.SDR JJBA20240523055Skin · crackedLH EXTERNAL FUSELAGE, BTW FRAME 77-80 AND STR 3L-9L, CRACKS (X5) FOUND AROUND FASTENERS. LH EXTERNAL FUSE, PAINT REMOVED BTW FR 77-80 AND BTW STR 3L-9L. LH EXTERNAL FUSELAGE, BTW FRAME 77-80 AND STR 3L-9L. LH EXTERNAL FUSELAGE BTW FR 77-80 STR 3L-9L FOUR REPAISDR JJBA20240522047Floor Support · corrodedCENTER FUSELAGE IV, UNDERFLOOR, CENTER OMEGA BEAM AT FRAME 59, CORROSION FOUND UNDER NUT PLATE. CENTER OMEGA BEAM REPAIRED AT FR59 AND FR60SDR JJBA20240520029Floor Support · corrodedCENTER FUSE 3, UNDER FLOOR STRUCTURE, LH SILL 5 FOUND CORRODED. CENTER FUSE 3, UNDER FLOOR STRUCTURE LH SILL 4 BLEND OUT OF LIMITS. AT CENTER FUSE 3, LH SILL 5 REPLACEDSDR JJBA20240502068Connector · disconnectedFOUND MULTIPLE EMERGENCY LIGHTS INOPERATIVE. FOUND CONNECTOR DISCONNECTED, RE-CONNECTED CONNECTOR. OPS CHECK SATSDR JJBA20240429065Light · inoperativeLH EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LH EXTERNAL LIGHT. OPS CHECK SAT.SDR JJBA20240429064Lamp · inoperativeCOCKPIT EMERGENCY LIGHT OUT. REMOVED AND REPLACED BULB. OPS CHECK SAT.SDR JJBA20240429063Lamp · inoperativeCOCKPIT EMERGENCY LIGHT OUT. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT BULB. OPS CHECK GOOD.SDR JJBA20240430066Support · corrodedCENTER FUSELAGE 4, RH SILL 6 CORRODED. ON CENTER FUSELAGE 4, RH SILL BLEND OUT CORROSION OUT OF LIMITS. CENTER FUSELAGE 4, RH SILL 6 REMOVED. ON CENTER FUSELAGE 4, RH SILL, 6 INSTALLEDSDR JJBA20240425061Lamp · inoperativeOVERWING EMERGENCY LIGHT LAMP INOPERATIVE AT BOTH SEATS. REMOVED AND REPLACED BOTH EMERGENCY LIGHT LAMPS. OPS CHECK SATSDR JJBA20240425060Hose · inoperativeHYD SYSTEM 1 FAIL WHEN RETRACTING GEAR. PERFORMED GVI OF HYD SYS #1, FOUND A NLG DOOR HYD LINE TO RH ACTUATOR IS LEAKING. INSPECTED EDP #1 FOR SIGNS OF DAMAGE OR LEAKS, NO DEFECTS NOTED. EDP RAN WITH HYD RESERVOIR AT ZERO, NO DEFECTS FOUND. SERVICED HYD SYS. PSDR JJBA20240422059Valve · inoperativeBLEED 1 AND 2 OVERTEMP MESSAGE ON EICAS. REMOVED AND REPLACED LH FAN VALVE AND CLEANED RH FAN AIR VALVE FILTER. OPS/LEAK CHECK SATSDR JJBA20240422058Cover · out of positionMAIN CABIN DOOR HARD TO OPEN. FOUND PART OF MICRO-SWITCH COVER TO BE CATCHING WHEN OPENING AND CLOSING DOOR. RESECURED MICROSWITCH COVER. DOOR OPENS AND CLOSES NORMALLYSDR JJBA20240422057Battery · inoperativeGALLEY EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY 2 BATTERY. OPS CHECK SATSDR JJBA20240513018Gusset · corrodedCF4, UNDER FLOOR, CENTER GUSSET BTW FRAME 59-61 FOUND CORRODED. CTR GUSSET BTW FR59-61 REPLACED.SDR JJBA20240508010Shear Tie · crackedCENTER FUSELAGE IV, SHEAR CLIP CRACKED AT FRAME 61 BTW 7R-6R CENTER FUSELAGE IV SHEAR CLIP AT FR 61 BTW STR 7R-6R REPLACED (MADE REPAIR PART), INSTALLED WITH SOLID RIVETS.SDR JJBA20240425062Shear Tie · crackedRF1, RH SHEAR CLIP AT FR 73 BTW STR 7R-10R FOUND CRACKED. RF1, RH SHEAR CLIP AT FR73 BTW STR 7R-10R REMOVED, REPLACED WITH NEW PARTSDR JJBA20240422056Light · faultedGALLEY EMERGENCY EXIT SIGN INOPERATIVE. GALLEY EMERGENCY LIGHT OPS CHECK SAT. NO DEFECTS NOTED.SDR JJBA20240422055Door · faultedMCD WONT OPEN FROM OUTSIDE OF AIRCRAFT. PERFORMED OPS CHECK ON MCD. OPS CHECK SATSDR JJBA20240513016Angle · crackedL/H WING TO BODY FAIRING UPPER ANGLE #1 AND #3 FOUND CRACKED. ON L/H WING TO BODY FAIRING UPPER ANGLE #1 AND #3 REPAIRED.SDR JJBA20240516025Shear Tie · crackedRF1, L/H SHEAR CLIP AT FR66 BTW STR 6L-7L FOUND CRACKED RF1, L/H SHEAR CLIP AT FR66 BTW STR 6L-7L REMOVED AND REPLACED.SDR JJBA20240513023Shear Tie · crackedRF1, L/H SHEAR CLIP AT FR73 BTW STR 15L-16L FOUND CRACKED. L/H SHEAR CLIP AT FR73 BTW STR 15L-16L REPLACED.SDR JJBA20240513021Support · crackedCARGO DOOR LIFTING AND LOWERING MECHANISI, FWD BOX SUPPORT CRACKED BTW FR 61-62 AND BTW STR 3R-4R CORGO DOOR LIFTING AND LOWERING MECHANISM FWD BOX SUPPORT REPLACEDSDR JJBA20240513020Angle · crackedVERTICAL U-SHAPE ANGLE BTW FR 67-68 AND BTW STR 3-4R CRACKED. VERTICAL U-SHAPE ANGLE BTW FR 67-68 AND BTW 3R-4R REPLACED.SDR JJBA20240513019Shear Tie · crackedSHEAR CLIP CRACKED BTW STR 15L-16L AT FR 56 SHARE CLIP AT FR56 BTW STR 15L-16L REPLACEDSDR JJBA20240513013Shear Tie · crackedREAR FUSELAGE 1, UNDR FLOOR, SHEAR CLIP CRACKED AT FRAME 65 BTWN STR 19L-18L SHEAR CLIP AT FR 65 STR 19L-18L REPLACEDSDR JJBA20240508009Shear Tie · crackedREAR FUSELAGE, UNDER FLOOR, SHEAR CLIP CRACKED AT FRAME 72 BTW STR 18L-17L. REAR FUEDLAGE, UNDER FLOOR, SHEAR CLIP AT FRAME 72 BTW STR 18L-17L REPLACED WITH NEW PART.SDR JJBA20240508008Shear Tie · crackedREAR FUSELAGE 1, UNDER FLOOR, SHEAR CLIP CRACKED AT FRAME 71 BTWN STR 18L-17L SHEAR CLIP AT FR71 BTW STR17L-18L REPLACED.SDR JJBA20240418054Light · malfunctionedEMERGENCY LIGHTS OVER EXIT ROW 18 WILL NOT ILLUMINATE DURING TEST. RESET SYSTEM, GROUND FUNCTIONAL CHECK GOOD.SDR JJBA20240513022Shear Tie · crackedCF2 UNDERFLOOR , L/H SHEAR CLIP AT FR24 BTW STR 15L-16L FOUND CRACKED.CF2, UNDERFLOOR, L/H SHEAR CLIP AT FR 24 BTW STR 15L-16L REMOVE AND REPLACE WITH NEW PART.SDR JJBA20240508012Shear Tie · crackedCF2, UNDERFLOOR, R/H SHEAR CLIP AT FR27 BTW STR 15R-16R FOUND CRACKED AT FR27 BTW STR 15R-16R, NEW SHEAR CLIP INSTALLED.
Back to Embraer EMB-145XR