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 JJBA202502265038Shear Tie · crackedREAR FUSELAGE I, FRAME 66, BTW STR 6L-7L, SHEAR CLIP FOUND CRACKED. RF I, FR66 BTW STR 6L-7L SHEAR CLIP REMOVED FOR REPLACEMENT. SHEAR CLIP FR66 MADE REPAIR PART, LOCALLY FABRICATED. REAR FUSE I, FR66 BTW STR 6L-7L, SHEAR CLIP FABRICATED INSTALLED.SDR JJBA20250221030Drive Unit · failedFLAP FAIL MESSAGE ON EICAS. NO FLAP CHANGE WHEN MOVING FLAP LEVER. REMOVED AND REPLACED FPDU. OPS CHECK GOOD.SDR JJBA20250221029Flap System · damagedFLAP FAIL, ON EICAS DURING CLIMB. RESET AND PERFORMED OPS CHECK OF FLAPS, FLAPS JAMMING AT 9 DEGREES, SUSPECTED BAD RH INBOARD ACTUATOR. INSPECTED AND FOUND RH INBOARD FLAP, RH FLAP SHROUD, AND RH ROLLER TO BE DAMAGED. REMOVED RH INBOARD FLAP AND SHROUD. REMOVSDR JJBA202502265040Repair · damagedREPAIR DOUBLER ON LH CENTER FUSE I SKIN BTW FR20-21 AND BTW STR 13L-14L. LH CENTER FUSE I, SKIN BTW FR 20-21 AND BTW STR 13L - 14L DOUBLER REMOVED. SKIN REPAIRED BTW FR20-21 AND BTW STR 13L-14LSDR JJBA20250217028Latch · stuckLG FREE FALL SELECTOR DOOR WON'T OPEN. OPENED FREE FALL SELECTOR DOOR. OPS CHECK SAT. UNABLE TO OPEN FREE FALL PANEL 222EF BY NORMAL MEANS. CLOSURE LATCH BUTTON APPEARS TO BE STUCK. REMOVED AND REPLACED LATCH. OPS CHECK SAT"SDR JJBA20250225035Panel · crackedHORIZONTAL - OVERHEAD PANEL IN COCKPIT FOUND CRACKED IN 2 PLACES. AFTER NDT INVESTIGATION, ONLY 1 CRACK FOUND ON RH SIDE. RH SIDE CRACK CUTOUT. RH SIDE REPAIRED.SDR JJBA20250225034Beam · corrodedCF IV, CENTER BEAM FOUND CORRODED BTW FR 59-61. CF4, CENTER BEAM BTW FR59-61 CORRODED OUT OF LIMIT. CF4, CENTER BEAM BTW FR 59-61 CUTOUT (2X) PERFORMED. CENTER BEAM BTW FR59-61 (2X) REPAIR DONESDR JJBA20250225033Skin · dentedEXTERNAL CENTER FUSELAGE, SKIN DENTED BTW FRAME 19-20 AND BTW STR 11L-12L. EXTERNAL CENTER FUSE, BTW FR 19-20 AT STR 11L. EXISTING RIVET REMOVED FOR REPAIR DOUBLER. EXTERNAL CENTER FUSELAGE I, SKIN BTW FR19-20 AND BTW 11L-12L DENT REPAIRED.SDR JJBA20250217016Connector · leakingBLEED 1 LEAK ON APPROACH WITH ASSOCIATED A/I FAULTS. FOUND ENGINE GROUND CONNECTION LEAKING. REMOVED AND REPALCED ENGINE GROUND CONNECTION. OPS CHECK, LEAK CHECK SAT AT THIS TIME AND FOUND MULTIPLE LEAKS ON PACK 1, GRATE ASSEMBLY AND DUEL TEMP VALVE UPPER SLEESDR JJBA20250213017Door Seal · unsecureMCD UNABLE TO LOCK/SECURE WHEN CLOSING. FOUND MCD SEAL POPPED FROM DOOR LOWER FWD, RESECURED DOOR SEAL. OPS CHECK SAT. NO FURTHER DEFECTS NOTED.SDR JJBA20250210010Lamp · inoperativeRH SIDE CENTER FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH SIDE CENTER FAIRING EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20250217027Skin · mechanic error2 MISDRILLED HOLES ON RUDDER II ABOVE ACCESS PANEL 327CL. REMOVED DAMAGE ON RUDDER 2 ABOVE ACCESS PANEL, FABRICATED REPAIR PARTS, LOCATED AND DRILLED HOLES. PREP, PRIMED DOUBLER AND FILLER. INSTALLED DOUBLER AND FILLER REPAIR PARTS ON RUDDER 2 ABOVE ACCESS PNLSDR JJBA20250213013Unknown · odorELECTRICAL BURNING SMELL IN CABIN DURING TAKE OFF. INSPECTION OKAY AT THIS TIME. CONDUCTED HIGH POWER RUN. NO SMELL NOTED DURING MULTIPLE CONFIGURATIONS OF BLEED AIR AND PACK SELECTIONS. NO OIL OVER SERVICING NOTED ON #1 ENGINE, #2 ENGINE OR APU. NO LEAKS NOTESDR JJBA20250210014Light · missingPHOTO-LUMINESCENT LIGHTING STRIP MISSING AT FRONT OF AIRCRAFT. INSTALLED MISSING LIGHT STRIPSDR JJBA20250210012Lamp · inoperativeAFT CEILING EMERGENCY LIGHT ON CEILING INOPERATIVE. REMOVED AND REPLACED LAMP. OPS CHECK SAT.SDR JJBA20250210011Lamp · inoperativeAFT CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED AFT EMERGENCY CEILING LIGHT LAMP. OPS CHECK SAT.SDR JJBA20250213023Spar · crackedVERT STAB AFT OF REAR SPAR 3, LH SKIN UPPER AND LOWER PROFILE CRACKED. REMOVED AND REPLACEDSDR JJBA20250213025Shear Tie · crackedIN REAR FUSELAGE, AT BULKHEAD 80, SHEAR CLIP CRACKED ON LH SIDE BETWEEN STRINGER 5L AND STRINGER 7L. IN REAR FUSELAGE AT BULKHEAD 80, SHEAR CLIP BTW STR 5L-7L PARTIALLY REMOVED. IN REAR FUSELAGE AT BULKHEAD 80, SHEAR CLIP BTW STR 5L AND 7L REPLACEDSDR JJBA20250213024Fairing · crackedAFT BODY FAIRING ON THE RH SIDE, ONE RIB IS CRACKED. AFT BODY FAIRING ON THE RH SIDE, ONE RIB REMOVED AND REPLACEDSDR JJBA20250225039Skin · crackedCRACK FOUND AROUND RIVET ON LH REAR FUSE II SKIN AT FR 79 STR 7L-8L. CRACK AROUND RIVET AT SKIN FR79 BTW STR 7L-8L REPAIREDSDR JJBA20250213018Gusset · corrodedCENTER FUSELAGE IV, CENTER GUSSET BTW FRAME 59-61 FOUND CORRODED. CF4, CENTER GUSSET BTW FR 59-61 CORRODED OUT OF LIMITS. GUSSET REMOVED FOR REPLACEMENT. GUSSET CENTER BTW FR 59-61 REPLACEDSDR JJBA20250213026Support · corrodedREAR FUSELAGE I, LH SILL BTW FRAME 61-65 FOUND CORRODED. LH SILL BTW FR 64-65 BLENDED OUT OF LIMIT. REAR FUSELAGE I, LH CARBON BULKHEAD REMOVED FOR ACCESS. RF I, L SILL BTW FR 61-65 REMOVED FOR REPLACEMENT. RF1, LH SILL BTW FR61-65 INSTALLED. RD1, LH CARBON BUSDR JJBA20250213022Support · corrodedCENTER FUSELAGE II, RH SILL BTW FRAME 29-35 FOUND CORRODED. CENTER FUSELAGE II, RH SILL BTW FR 29-35, CORROSION BLENDED OUT OF LIMIT. RH SILL BTW FR 29-35 REMOVED FOR REPLACEMENT. AT CF2, RH SILL BTW FR29-35 REPLACEDSDR JJBA20250213020Tee Angle · corrodedREAR FUSELAGE 1, LH T-POST AT FR61 FOUND CORRODED. RF1, LH T-POST AT FR61 BLENDED OUT OF LIMITS. LH T-POST AT FR61 REMOVED FOR REPLACEMENT. LH T-POST NEW PART INSTALLED.SDR JJBA20250210015Angle · crackedCENTER FUSELAGE 1, AT FRAME 14 AND STR 16L, REINFORCEMENT ANGLE FOUND CRACKED. AT CF1, AT FR 14 STR 16L REINFORCEMENT ANGLE REMOVED FOR REPLACEMENT. AT CF1 AT FR14 STR 16L REINFORCEMENT ANGLE REPLACEDSDR JJBA20250213021Support · corrodedCENTER FUSELAGE III, RH SILL BTW FRAME 35-41 FOUND CORRODED. RH SILL BTW FR 35-41 BLENDED OUT OF LIMITS. RH SILL BTW FR 35-41 REMOVED FOR REPLACEMENT. ON CF III, RH SILL BTW FR 35-41 REPLACEDSDR JJBA20250205009Precooler · leakingBLEED 2 OVERTEMP IN FLIGHT. RAN QRH DESELECTED BLEED 2 SYSTEM MESSAGE EXTINGUISHED, DURING CLIMB OUT FROM FL200 - FL2100, ROUGHLY AT 270-280 KIAS, OCCURRED IN ICING. REMOVED AND REPLACED BOTH RH FAN AIR CONTROL THERMOSTATS. WHILE PERFORMING ENGINE RUNS. FOUND SDR JJBA20250213019Floor Support · damagedCENTER FUSELAGE III, LH OMEGA BEAM BTW FRAME 50-46, OUTBD ANGLE, SURFACE BARE METAL. AFTER BEING CLEANED, FOUND TO BE CRACKED, REMOVED AND REPLACED.SDR JJBA20250203025Engine · faultedENG 1 SHUTDOWN IN FLIGHT. REMOVED AND REPLACED #1 ENGINE. OPS AND LEAK CHECK SAT.SDR JJBA20250131024Inverter · inoperativeLH AFT EXIT ROW EMERGENCY EXIT ILLUMINATED PLACARD INOPERATIVE. REMOVED AND REPLACED #4 INVERTER. OPS CHECK SAT.SDR JJBA20250225036Support · crackedREAR FUSELAGE I, BTW FRAME 67-68 AT BTW STR 4R-5R, SUPPORT FOUND CRACKED. REAR FUSELAGE I, BTW FRAME 67-68 BTW STR 4R-5R, SUPPORT REMOVED FOR REPLACEMENT. REAR FUSELAGE I, BTW FR 67-68 AT BTW STR 4R-5R SUPPORT REPLACED WITH NEW PART.SDR JJBA20250127023Oil System · overtempE2 HIGH OIL TEMP. PERFORMED E2 SHUT DOWN. MAX E2 OIL TEMP 142C. PERFORMED BORESCOPE INSPECTION OF THE MID-SPAN ROLLER BEARING ASSEMBLY. NO DEFECTS NOTED. REMOVED AND REPLACED RH ENGINE. OPS/LEAK CHECK SAT.SDR JJBA20250127022Display · burned outDESCENDING THROUGH 10000 CAPTAIN PFD BLANKED OUT WITH RED "X". BURNT ELECTRICAL SMELL FOLLOWED. REMOVED AND REPLACED CAPTAINS PFD DISPLAY UNIT. PFD OPS CHECK GOOD.SDR JJBA20250127021Lamp · inoperativeRH OVERWING EMERGENCY LIGHT OUT. REMOVED AND REPLACED BULB. OPS CHECK SAT.SDR JJBA20250127020Charger · inoperativeENTRYWAY EMERGENCY LIGHTS OUT. DUE TO EXCESSIVE HISTORY OF EXACT EMERGENCY LIGHTS BEING WRITTEN UP, REMOVED AND REPLACED #1 BATTERY POWER SUPPLY AND BATTERY PACK. OPS CHECK SAT.SDR JJBA20250123019Battery · inoperativeFWD LH EXT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT LAMP. OPS CHECK FAILED. FOUND #1 BATTERY PACK TO BE FAULT. REMOVED AND REPLACED BATTERY PACK #1. OPS CHECK SAT.SDR JJBA20250123018Battery · inoperativeMCD, FLOOR AND FIRST OVERHEAD EMERGENCY LIGHTS OUT. REMOVED AND REPLACED #1 BATTERY PACK. OPS CHECK SAT.SDR JJBA20250120017Lamp · inoperativeRIGHT EXTERIOR FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT EXTEIOR FWD EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20250113011Lamp · inoperativeLH EXTERNAL OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED LH EXTERNAL OVERWING EMERGENCY EXIT LIGHT. OPS CHECK SAT.SDR JJBA20250225008Skin · damagedDAMAGE TO THE LH REAR FUSELAGE 1 AT FRAMES 70 TO 72 AND STRINGERS 16L-18L. PERFORMED HIGH FREQUENCY EDDY CURRENT INSPECTION ON AND AROUND DAMAGED AREA OF LH REAR FUSELAGE I FROM FRAMES 70-72, STRINGERS 16L-18L. NO INDICATION OF CRACKS FOUND AT THIS TIME. REMOVSDR JJBA20250110010Transceiver · intermittentWEATHER RADAR FAILED INTERMITTENTLY IN FLIGHT. REMOVED AND REPLACED WEATHER RTA AND W025 HARNESS. OPS CHECK GOOD. NO DEFECTS NOTED.SDR JJBA20250110009Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR JJBA20250109008Battery Pack · inoperativeMULTIPLE INTERIOR EMERGENCY LIGHTS INOPERATIVE (ROW 18). REMOVED AND REPLACED #3 BATTERY PACK. OPS CHECK SATSDR JJBA2025010023060Battery · inoperativeLH EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH EMERGENCY LIGHT BULB AND REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY POWER SUPPLY. OPS CHECK SAT.SDR JJBA20241230058Doubler · corrodedRF1, AFT RADIO ALTIMETER 2 EXTERNAL DOUBLER FOUND CORRODED. REPAIR DOUBLER ON REAR FUSE I LOWER SKIN, BTW FR 68-69 AND BTW STR 21L-21RSDR JJBA20241227057Lamp · inoperativeCOCKPIT EMERGENCY LIGHT OUT. REMOVED AND REPLACED LAMP. OPS CHECK SATSDR JJBA20241227056Lamp · inoperativeLEFT FWD EXTERIOR EMERGENCY LIGHT OUT. REMOVED AND REPLACED LAMP. OPS CHECK SAT.SDR JJBA20241227054Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY #4. OPS CHECK SAT, EMERGENCY LIGHTS BACK TO NORMAL OPERATIONSDR JJBA20241223049Lamp · inoperativeLH WTF FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH AFT EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SATSDR JJBA20241223048Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT. OPS CHECK SAT.
Back to Embraer EMB-145XR