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 JJBA20220103032Light · inoperativeLH EXTERIOR OVERWING EMERGENCY LIGHT IS INOPERATIVE. LH EXT OVERWING EMERGENCY LIGHT REMOVED AND REPLACED. NO DEFECTS NOTED AT THIS TIME.SDR JJBA20221230029Light · detachedEMERGENCY LIGHTING FLOOR STRIP AT 1A IS DETACHED. RESECURED EMERGENCY LIGHT STRIP AT 1A.SDR JJBA20221229027Container · puncturedFO LIFE VEST BAG PUNCTURED. REMOVED AND REPLACED FO LIFE VESTSDR JJBA20220103031Sign · inoperativeCTR AISLE FWD FACING EMERGENCY SIGN INOPERATIVE AT EMERGENCY EXIT ROW. REMOVED AND REPLACED CTR AISLE FWD FACING EMERGENCY SIGN. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIMESDR JJBA20221227026Charger · inoperativeLH FWD WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY CHARGER. OPS CHECK SAT.SDR JJBA20221227025Light · unsecureEMERGENCY LIGHT STRIP AT 1A NEEDS RESECURED. RESECURED EMERGENCY LIGHT STRIP AT 1A.SDR JJBA20221227024Unknown · odorSMELL IN CABIN POSSIBLY PAC. PERFORMED CABIN VISUAL INSPECTION, RE-RUN PACK AND NO SMELL DETECTED. OPS CHECK SATSDR JJBA20221227023Battery Pack · inoperativeRH FWD EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH FWD EXTERNAL EMERGENCY LIGHT. REMOVED AND REPLACED #2 EMERGENCY LIGHT BATTERY. OPS CHECK SATSDR JJBA20221227022Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXT MCD EMERGENCY LIGHT BULB. FAILED OPS CHECK. MCD EMERGENCY LIGHT OPS CHECK SAT. FOUND EXT MCD EMERGENCY LIGHT TO FAIL OPS CHECK. REMOVED AND REPLACED EXT MCD EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR JJBA20221223021Light · looseCABIN FWD FLOOR BOARD PHOTO ILLUMINESCENT STRIPS LOOSE SECURED FOWARD PHOTO ILLUMINANT STRIPSSDR JJBA20221223020Handle · out of adjustMCD DIFFICULT TO OPEN FROM INSIDE. ADJUSTED THE DOOR HANDLE.SDR JJBA20221222015Inverter · inoperativeLH OVERWING INTERNAL AFT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED #5 AC/DC INVERTER. OPS CHECK SATSDR JJBA20221222014Door · bindingMCD DIFFICULT TO OPEN FROM INSIDE.SDR JJBA20221223019Light · intermittentEMERGENCY LIGHTS NOT ARMED EICAS INTERMITTENTLY DISPLAYED. PERFORMED ELECTRICAL RESET AND OPS TEST FOR EMERGENCY LIGHTING. OPS CHECKED GOOD.SDR JJBA20221222013Flashlight · inoperativeREAR FLASHLIGHT INOPERATIVE. PERFORMED OPS CHECK. OPS CHECK SAT.SDR JJBA20221222017Skin · corrodedCORROSION ON REAR FUSE 2 LOWER SKIN. BTW FR 80-61 AND BTW STR 19L-21L. ON FR2 LOWER SKIN, BTW FR80-81 AND BTW STR 19L-21L, CORROSION BLENDE DOUT OF LIMITS. CUTOUT AND REPAIR DOUBLER PERFORMED. REAR FUSE 2 LOWER SKIN BTW FR 80-81 AND BTW STR 19L-21L CORROSION RSDR JJBA20221222018Floor Support · corrodedCF4, CENTER OMEGA BEAM CORROSION UNDER NUT-PLATE BTW FRAME 59-61. CORROSION ON CENTER OMEGA BEAM BLENDED AND FOUND OUT OF LIMIT AT 2X NUT PLATE LOCATION FR59 AND FR61. CENTER OMEGA BEAM REPAIRED AT 2X NUT PLATE LOCATION FR59 AND FR61.SDR JJBA20221222016Gusset · corrodedCF4, LH GUSSET CORRODED BTW FRAME 59-61. CORROSION ON LH GUSSET FR 59-61 BLENDED AND FOUND OUT OF LIMIT. LH GUSSET BTW FR59 AND 61 REPLACED. CUT OUT PERFORMED AT 2X ANCHOR NUT LOCATION. LH OMEGA BEAM REPAIRED AT 2X ANCHOR NUT LOCATION WITH HAT SECTION REPAIR.SDR JJBA20221215008Flashlight Assy · odorFUMES ON DECENT COMING FROM COCKPIT VENTS. SMELLS LIKE BURNT SILICON. FOUND ABNORMAL SMELL ON CAPT SIDE EMERGENCY FLASH LIGHT. REMOVED AND REPLACED. OPS CHECK SAT.SDR JJBA20221215007Unknown · odorVERY STRONG SMELL IN COCKPIT ON DECENT. COMPLIED WITH FIM TASK FOR ABNORMAL SMELL. RAN PACKS AND ENGINES WITH CREW. NO DEFECTS FOUND. COULD NOT DUPLICATESDR JJBA20221212006Battery Pack · inoperativeLH AND RH EMERGENCY EXIT DOOR OVERHEAD LIGHTS AND EXIT MARKERS DO NOT ILLUMINATE. REMOVED AND REPLACED BPS #3. ALL LIGHTS ILLUMINATE. OPS CHECK GOOD.SDR JJBA20221212005Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20221208004Light · missingFOUR EMERGENCY LIGHTS MISSING ON FLOOR. INSTALLED THE FLOOR EMERGENCY LIGHTS.SDR JJBA20221208003Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS IN GALLEY AND EXTERNAL RH FWD EMERGENCY LIGHTS INOPERATIVE. FOUND EMERGENCY LIGHT BATTERY PACK NOT SECURED TO CHARGER. REINSTALLED AND SECURED BATTERY PACK. OPS CHECK SAT.SDR JJBA20221205002Lamp · inoperativeLH WING LOWER EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH EXT EMERGENCY LIGHT BULB. OPS CHECK GOOD.SDR JJBA20221205001Seat · looseFWD PAX SEAT FEET AT SEATS 3, 5, 6, 8, 9, 10, 11, 19, 20, 21, 22 AND 23CD AND 7, 8, 9, 22A WERE FOUND TO BE SEVERELY LOOSE AND NOT FULLY TIGHTENED. RESCURED ALL DISCREPANT SEATSSDR JJBA20221130033Snap Ring · wornMAIN CABIN DOOR NOT OPENING FROM INSIDE. FOUND SNAP RING ON INTERMEDIATE TORQUE TUBE WORN AND OUT OF PLACE. REMOVED AND REPLACED SNAP RING. OPS CHECK SATSDR JJBA20221129027Duct · leakingBLEED 1 LEAK IN FLIGHT. INSPECTED AND FOUND BLEED LEAK AT DUCT BETWEEN PRECOOLER AND BLEED VALVE, R/R DUCT AND Y DUCT L/H PYLON. PERFORMED HIGH POWER RUNS FOR ENG LEAK CHECKS, NO BLD 1 LEAK CHECK NOTED , OPS CHECK SAT LEAK CHECK SATSDR JJBA20221129032Doubler · corrodedAT REAR FUSE 1 EXT, RADIO ALT ANTENNA NO 2 AFT LOWER DOUBLER CORRODED ON BELLY SKIN BTW FR 68-70. SKIN IS REPAIRED WITH A DOUBLERSDR JJBA20221129029Skin · dentedFUSELAGE SKIN DENT HAS CREASE/GOUGE. DENT IS 3.75" X 2.25" AT FR 23-24, STR 12L-13L. DEPTH 0.125, FR 23 TO DENT IS 1", FR24 TO DENT IS 1.5", STR 13L TO DENT IS .75", STR 12L TO DENT IS 2.5". REMOVED SKIN CREASE/GOUGE. DENT FR 23-24 BTW STR 12L-13L. PERFORMED HSDR JJBA20221129028Wire · looseSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. SERVICE DOOR EMERGENCY LIGHT CONTACT SOLDER DEFORMED, ADDED SOLDER. OPS CHECK GOODSDR JJBA20221125023Battery · inoperativeR/H FWD EXTERNAL WING TO FUSELAGE EMERGENCY LIGHT INOP. R/R BPS#2. OPS CHECK SATSDR JJBA20221215012Panel · crackedCAPT OVERHEAD PANEL IS CRACKED AND HAS HDW ATTACH HOLES DAMAGED. REMOVED AND INSTALLED CAPT OVERHEAD PANELSDR JJBA20221125022Wire · brokenSVC DOOR EXTERNAL EMERGENCY LIGHT INOP R&R SVC EXTERNAL EMERGENCY LIGHT HOUSING ASSY. OPS CHECK FAIL. CHECKED SPLICE SP7376 FOR POWER. CHECK GOOD. CHECKED SP7377 FOR CONTINUITY TO GROUND. CHECK FAIL. FOUND WIRE W716-0008-20 BROKEN. WORK DONE REPLACED BROKEN WISDR JJBA20221125021Acm · lockedFOUL ODOR ON CLIMB/DESCENT BETWEEN 5000` AND 14000` PERFORMED ROLLS ROYCE FIM. COMPLIED WITH #1 ENGINE BORESCOPE INSPECTION ENGINE FLOWPATH AREA, NO OIL POOLING, NO WET OIL FOUND ON OR NEAR THE BOLT HEADS, JUST SOME DUST OR DAMP GRIME. #1 PACK ACM LOCKED UP SDR JJBA20221129031Shear Tie · crackedRF 1 , FRAME 71, SHEAR CLIP BTWN STR 6L-10L CRACKED. SHEAR CAP FR 71 BTW STR 6L-10L REMOVED FOR REPLACEMENT. NEW SHEAR FABRICATED. SHEAR CLIP FR 71 BTW STR 6L-10L REPROTECTED. FR 71 BTW STR 6L-10L, NEW SHEAR CLIP INSTALLED.SDR JJBA20221121016Actuator Cable · jammedMAIN CABIN DOOR WON'T OPEN, ACTUATING MECHANISM JAMMED. INSPECTED AND FOUND MAIN DOOR FORWARD LOCK JAMMING. ADJUSTED MAIN CABIN DOOR CABLE D TO FRONT LOCK BOX. FOUND AFT LOCKING-MECHANISM CAM OVER CENTER. THE LOCKING FORCE OUT OF LIMITS (ON LOW SIDE WITH FORCESDR JJBA20221129030Skin · gougedGOUGE ON PAX DOOR EXTERNAL SKIN AFT EDGE LOWER AREA. REPAIR DOUBLER ON PAX DOOR EXTERNAL SKIN, ON AFT EDGE AND AT STR 14LSDR JJBA20221122020Skin · corrodedRH PYLON, FUSELAGE SKIN WORN BY FRETTING FROM LANYARD BETWEEN FR67 AND FR68 AND STGR 07R. REPAIR DOUBLER ON RH REAR FUSE 1 SKIN, BTW FR 67-68 AND BTW STR 7R-8RSDR JJBA20221121017Frame · corrodedFRAME 25 FOUND CRACKED BTW STR 15R-16R. FRAME IS REPAIRED WITH AN EXTENDED SPLICE REPAIR ON RH CENTER FUSE 2 FRAME 25, BTW STR 15R-16RSDR JJBA20221117011Handle · out of adjustNOT ABLE TO OPEN THE MAIN CABIN DOOR FROM INSIDE THE PLANE. REPOSITIONED MAIN CABIN DOOR HANDLE. OPS CHECK GOODSDR JJBA20221114010Battery Pack · inoperativeRH AND LH CABIN ESCAPE HATCH EXIT MARKING SIGNS INOPERATIVE. REMOVED AND REPLACED BATTERY POWER SUPPLY. OPS CHECK SAT.SDR JJBA20221121015Beam · crackedCF1, UNDERFLOOR, LH OMEGA BEAM CRACK SUSPECTED AT FRAME 21, 22, 23. 3 REPAIR DOUBLERS ON LH CENTER FUSE 1 OMEGA BEAM, ON INBD FLANGE AT FR 21, 22 AND 23SDR JJBA20221121014Beam · crackedCF2, UNDERFLOOR, LH OMEGA BEAM #2 BTW FR 23-30 CRACK SUSPECTED AT FRAME 24, 25, 27, 28. 4 REPAIR DOUBLERS ON LH CENTER FUSE 2 OMEGA BEAM, ON INBD FLANGE AT FR 24, 25, 27, AND 28SDR JJBA20221121013Beam · crackedCF2 U/FLOOR STRUCTURE LH OMEGA BEAM #3 BTW FR 29-36 CRACKS SUSPECTED AT FRAME 33-34-35. 3 REPAIR DOUBLERS ON LH CENTER FUSE 2 OMEGA BEAM, ON INBD FLANGE AT FR 33, 34, 35SDR JJBA20221121012Bulkhead · noneEXISTING REPAIR DOUBLER ON FWD PRESSURE BULKHEAD NEED TO BE REMOVED FOR INVESTIGATION. BULKHEAD REPAIRED WITH A DOUBLERSDR JJBA20221111009Unknown · odorWHEN SELECTING ENGINE BLEEDS RUBBER SMELL NOTED. TURNED OFF BLEEDS, SMELL DISSIPATED. ON TAXI OUT AND UNTIL 1000 THEY WERE ON APU BLEEDS. AT 1300 GOING TO 3000 TURNED ON ENGINE BLEEDS, CAPTAIN AND FO NOTED RUBBER SMELL COMING FROM THE DUCTS. TURNED OFF BLEEDS SDR JJBA20221122019Stringer Clip · crackedSTRINGER CLIP, JUST AFT OF COCKPIT BULKHEAD ON RH SIDE AT FLOOR LINE HAS A CRACK COMING OUT OF RIVET. REMOVED STRINGER CLIP. STRINGER CLIP WAS REPLACEDSDR JJBA20221121018Floorbeam · corrodedCORROSION AT FS60, ON FLOOR STRUCTURE CENTER FLOORBEAM SCREW HOLE. COMPLETED GUSSET INSTALL BY INSTALLING PROTECTIVE TAPE AS REQUIREDSDR JJBA20221215011Gusset · corrodedMINOR POWDERING CORROSION, AT FS60, ON FLOOR STRUCTURE CENTER FLOOR BEAM SCREW HOLE. UPON INSPECTION OF CORROSION AT FS60, CORROSION FOUND TO BE LEVEL 2. REMOVED AND REPLACED GUSSET
Back to Embraer EMB-145XR