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 JJBA20240909008Lamp · inoperativeCOCKPIT EMERGENCY LIGHT OUT. REMOVED AND REPLACED BULB. OPS CHECK SAT.SDR JJBA20240906006Lamp · inoperativeRH FORWARD LOWER FAIRING EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD LOWER FAIRING EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20240906005Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB ON MCD EMERGENCY LIGHT. OPS CHECK FAILED. REMOVED AND REPLACED MCD EMERGENCY LIGHT HOUSING. OPS CHECK SATSDR JJBA20240906007Door · unknownMAIN CABIN DOOR JAMMED. OPS CHECK PAX DOOR. OPS CHECK GOOD. NO DEFECTS NOTEDSDR JJBA20240906004Lamp · inoperativeEMERGENCY LIGHTS ON CEILING PANELS AT SEATS 3, 18, AND 23 INOPERATIVE. REMOVED AND REPLACED AISLE EMERGENCY LIGHT LAMPS. OPS CHECK SAT.SDR JJBA20240906003Control Unit · inoperativeFLAP FAIL MESSAGE WHEN PERFORMING CLIMB CHECK AT 1300 AFTER MOVING FLAP LEVER FROM 9 TO 0 DEGREES. ON POST WALK AROUND FLAPS ARE STILL AT 9 DEGREES, SPEED WHEN THE FLAP FAIL OCCURRED WAS AROUND 160 TO 170 KNOTS. FOUND RH TRANSMISSION FAIL ON CMC. PERFORMED FIMSDR JJBA20240903018Lamp · inoperativeLH FWD LOWER FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH FWD LOWER FAIRING EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR JJBA20240830017Inverter · inoperativeAFT OVERWING EMERGENCY EXIT CEILING LIGHT INOPERATIVE. SWAPPED BATTERY NUMBER 3. OPS CHECK FAILED. REINSTALLED ORIGINAL BATTERY. REMOVED AND REPLACED #4 INVERTER. OPS CHECK SAT.SDR JJBA20240830016Smoke Detector · inoperativeLAV SMOKE DETECTOR INOPERATIVE. REMOVED INSERT MODULE AND REPLACED WIRE CRIMP CONTACTS. REINSTALLED LAVATORY SMOKE DETECTOR. PERFORMED OPERATIONAL TEST. OPS CHECK SAT.SDR JJBA20240822015Control Unit · inoperativeBRAKE OUTBOARD INOPERATIVE EICAS MESSAGE. BRAKES NOT ENGAGING 100% ON LANDING ROLL. LEFT INBOARD BRAKE TEMP IN YELLOW. FOUND NO BRAKE RELATED CMC MESSAGES. REMOVED ALL 4 HUB CAPS AND INSPECTED TRANSDUCERS, FOUND NO VIABLE FAULT, REINSTALLED HUB CAPS. REMOVED ASDR JJBA20240819014Unknown · noiseLOUD GRINDING SOUND AT 1000 FEET. SOUNDED LIKE STRUCTURAL FAILURE, WENT AWAY AFTER 5 SECONDS. ALL SYSTEMS CHECKED AND FLIGHT CONTROLS FELT NORMAL, THEN AT 27000 FEET IT HAPPENED AGAIN. FLOOR VIBRATED AND CONTROLS. WENT AWAY AFTER 5 SECONDS. PERFORMED GVI ON RUSDR JJBA20240819013Charger · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT AND FA OVERHEAD LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPS CHECK FAIL. FOUND QUICK DICONNECT SP 7425 BROKEN. REPAIRED QUICK DISCONNECT. OPS CHECK FAIL. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY #1. OVERHEAD LIGHT OPS CSDR JJBA20240812012Battery Pack · inoperativeRH EXTERNAL FORWARD EMERGENCY LIGHT OUT. GALLEY OVERHEAD EMERGENCY LIGHT FLICKERS. REMOVED AND REPLACED BPS 2. OPS CHECK GOOD.SDR JJBA20240808011Inverter · inoperativeSERVICE DOOR UPPER EXIT SIGN EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR UPPER EXIT SIGN EMERGENCY LIGHT. OPS CHECK FAIL. REMOVED AND REPLACED INVERTER ASSEMBLY. OPS CHECK SATSDR JJBA20240807010Stop Fitting · missingMCD FWD TOP STOP MISSING, WITH SHIMS FELL OUT. FWD TOP STOP FOUND TO BE IN SERVICEABLE CONDITION. FOUND AFT MIDDLE STOP TO BE MISSING INSTEAD. INSTALLED AND ADJUSTED AFT MIDDLE STOP. PERFORMED PRESSURIZATION TEST. LEAK CHECK SAT.SDR JJBA20240807009Roller · lack of lubeMCD DIFFICULT DOOR HARD TO OPEN FROM INSIDE. LUBED MCD ROLLERS AND STOPS. OPS CHECK GOODSDR JJBA20240805005Light · inoperativeMCD EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EXTERNAL EMERGENCY LIGHT HOUSING. OPS CHECK SAT.SDR JJBA20240805004Lamp · inoperativeEMERGENCY EXIT ROW CEILING LIGHTS BOTH INOPERATIVE. REMOVED AND REPLACED RH AND LH OVERWING EMERGENCY LIGHT LAMPS. OPS CHECK SAT.SDR JJBA20240805003Light · misinstalledRH OVERWING EMERGENCY EXIT LIGHT INSTALLED UPSIDE DOWN. REMOVED AND REINSTALLED OVERWING EMERGENCY EXIT LIGHT CORRECTLY.SDR JJBA20240805002Sign · inoperativeFWD EXIT EMERGENCY SIGN ABOVE ROW 18 INOPERATIVE. REMOVED AND REPLACED FWD EXIT EMERGENCY SIGN ABOVE ROW 18. OPS CHECK SAT.SDR JJBA20240725007Unknown · smokeAFTER RUNNING QRH FOR I/A FAIL SMOKE IN COCKPIT. PERFORMED OPS CHECK OF DISTRIBUTION SYSTEM AND PACKS. NO DEFECTS OR SMOKE NOTED.SDR JJBA20240716006Lamp · inoperativeLH ABOVE THE WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH ABOVE THE WING EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20240712005Control Lever · inoperativeLANDING GEAR WILL NOT RETRACT, WITH LANDING GEAR LEVER DISAGREE MESSAGE ON TAKEOFF. REMOVED AND REPLACED LH CONTROL LEVEL. OPS CHECK SAT. PERFORMED MLG EXTENSION AND RETRACTION OPS CHECK. OPS CHECK SAT. CLEANED LG WOW PROX SWITCHES. OPS CHECK SAT.SDR JJBA20240709004None · nonePOSSIBLE SMOKE INTO CABIN, MAY HAVE BEEN CONDENSATION. DETERMINED TO BE CONDENSATION AND NOT SMOKE. OPS CHECK OF PACKS GOOD. NO ABNORMALITIES FOUND.SDR JJBA20240708003Door · lack of lubeMAIN CABIN DOOR IS HARD TO CLOSE WITH HANDLE. LUBRICATED DOOR. OPS CHECK SAT.SDR JJBA20240708002Lamp · inoperativeRH FWD LOWER FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH FWD LOWER FAIRING EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR JJBA20240918017Floor Support · corrodedCENTER OMEGA BEAM HAS CORROSION PRESENT BETWEEN FR59 AND FR61. REPAIR CENTER OMEGA BEAM BETWEEN FR59 AND FR61.SDR JJBA20240918016Profile · corrodedCORROSION FOUND NEAR FR65 AND STGR 16L ON PROFILE. REMOVED AND REPLACED LOWER SECTION OF SHEAR CLIP AT FRAME 65.SDR JJBA20240624041Display · inoperativeMFD FLICKERING ON/OFF WHEN RADAR TURNED ON AND BURNING ODOR. REMOVED AND REPLACED CAS MFD DISPLAY UNIT WITH NEW. OPS CHECK GOOD. NO SMELL OR ODOR NOTED.SDR JJBA20240906002Door Sill · corrodedUPON REMOVAL OF BAGGAGE DOOR PROTECTOR STRIP, FOUND CORROSION ON FRAME 66 DIRECTLY UNDER REMOVED PROTECTOR STRIP AREA. REMOVED AND REPLACED BAGGAGE DOOR SILL. APPLIED TOP COAT TO BAGGAGE DOOR SILL.SDR JJBA20240808008Frame · corrodedUPON REMOVAL OF BAGGAGE DOOR PROTECTOR STRIP, FOUND CORROSION ON FRAME 66 DIRECTLY UNDER REMOVED PROTECTOR STRIP AREA. REMOVED AND REPLACED BAGGAGE DOOR SILL. APPLIED TOP COAT TO BAGGAGE DOOR SILL.SDR JJBA20240624040Retaining Ring · faultedMAIN CABIN DOOR CAN OPEN ONLY FROM OUTSIDE. TROUBLESHOOT DOOR CHECK SECURITY OF INTERNAL DOOR RED HANDLE FOUND NO DEFECTS RESECURED DOOR HANDLE AND TRIED TO OPEN MCD. THE RETAINING RING WAS HYPER EXTENDED AND OUT OF PLACE. THIS CAUSED THE TORQUE TUBE TO INTERMSDR JJBA20240808001Plate · corrodedFOUND CORROSION ON INSIDE TOP MID PORTION OF BUMPER PLATE, APPROX 5 IN THE LENGTH FROM TOP DOWN. AFTER CLEANING BUMPER PLATE NO CORROSION FOUND.SDR JJBA20240618038Cam · lack of lubeMAIN CABIN DOOR ONLY OPENS FROM THE OUTSIDE. INSPECTED MAIN CABIN DOOR AND LATCHES. LUBRICATED MCD ACTUATING CAM. OPENED AND CLOSED DOOR SEVERAL TIMES. OPS CHECK SAT.SDR JJBA20240618037Door · bindingMCD DIFFICULT TO OPEN AFTER FLIGHT. LUBED AND PERFORMED OPS CHECK OF MAIN CABIN DOOR. OPS CHECK GOOD. ALSO PRESSURIZED AIRCRAFT. OPS CHECK SATSDR JJBA20240618036Light · misinstalledRH OVERWING EXTERNAL EMERGENCY LIGHT INSTALLED UPSIDE DOWN. REMOVED AND CORRECTLY INSTALLED RH OVERWING EXTERNAL EMERGENCY LIGHT.SDR JJBA20240618035Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPS CHECK GOOD.SDR JJBA20240612034Skin · damagedEXTERNAL BAGGAGE DOOR SKIN, DENT FOUND 7.500 INCHES FROM LOWER EDGE AND 3.000 INCHES FROM FWD EDGE. EXTERNAL BAGGAGE DOOR SKIN REPAIRED.SDR JJBA20240610010Lamp · inoperativeAFT CEILING PANEL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED AFT AISLE EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20240612032Skin · corrodedREAR FUSELAGE 1, FRAME 61 BTW STR 19L-18L, CORROSION SUSPECTED ON INNER SKIN SURFACE. CORROSION DAMAGE ON INNER SKIN SURFACE AT FR61 BTW STR 19L-18L REPAIRED.SDR JJBA20240611030Frame · crackedLH OVERHEAD COCKPIT FRAME FOUND CRACKED. LH OVERHEAD COCKPIT FRAME SPLICE REPAIREDSDR JJBA20240611028Skin · damagedCENTER FUSELAGE 2, EXTERNAL SKIN, SEVERAL LIGHTNING STRIKE FOUND BTW FRAME 25-31 AND STR 21L-19L. PERFORMED REPAIRS ON CENTER FUSELAGE 2, EXTERNAL SKIN BTW FR 25 - FR 31 AND STR 21L-19LSDR JJBA20240607003Gusset · corrodedLH GUSSET BTW FR 59-61 FOUND CORRODED. LH GUSSET BTW FR59-61 BLENDED AND FOUND OUT OF LIMIT. LH GUSSET BTW FR 59-61 REMOVED AND REPLACEDSDR JJBA20240611031Floor Support · corrodedRF1, UNDERFLOOR, CENTER OMEGA BEAM FOUND CORRODED BTW FR 59-60 AND 60-61 AROUND ANCHOR NUT. REAR FUSELAGE I FLOOR STRUCTURE, CTR OMEGA BEAM REPAIRED BTW FR 59-60 AND FR 60-61SDR JJBA20240611029Skin · dentedFWD FUSELAGE, DENT FOUND 4.000 INCHES FWD FRAME 7 AND 14.000 INCHES STR 15L. REPAIR DOUBLER PERFORMED ON FWD FUSELAGE BTW FR 6-7 AND BELOW GPU ACCESS PANELSDR JJBA20240610015Shear Tie · crackedRF1, ABOVE FLOOR, SHEAR CLIP AT FR66 AND BTW STR 6L-7L FOUND CRACKED. SHEAR CLIP AT FR66 BTW STR 6L-7L LOCALLY FABRICATED. MADE REPAIR PART INSTALLEDSDR JJBA20240610014Floor Support · corrodedRF1, UNDERFLOOR, LH OMEGA BEAM FOUND CORRODED BTW FR 59-60 AND 60-61 AROUND ANCHOR NUT. REPAIR PERFORMED ON CENTER FUSELAGE IV, LH OMEGA BEAM HAT UPPER SURFACESDR JJBA20240607007Floor Support · crackedCF1, LH OMEGA BEAM AT FR22 VERTICAL FLANGE INBD CRACKED FOUND ON RIVET. CF1, LH OMEGA BEAM CRACK AT FR22 REPAIREDSDR JJBA20240607005Floor Support · crackedLH OMEGA BEAM #4 CORROSION FOUND AND CRACK SUSPECTED AT FR36. LH OMEGA BEAM #4 BLENDED WITHIN LIMITS AND REPROTECTED. LH OMEGA BEAM #4 CRACK AT FR36 REPAIRED. CORROSION LEVEL 1.SDR JJBA20240606002Floor Support · crackedLH OMEGA BEAM #6 FOUND CORRODED AND CRACK SUSPECTED AT FR51. CORROSION BLENDED AND WITHIN LIMITS. LH OMEGA BEAM #6 CRACK REPAIRED. CORROSION LEVEL 1
Back to Embraer EMB-145XR