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 JJBA20231130037Unknown · unknownRF1 EXTERNAL LOWER FUSELAGE, CORROSION BTW FR 61-62A RH AND AT STR 19R. RH STRINGER 19R SECTION BTW FR 61-66 INSTALLED AND STRINGER SPLICE COMPLETEDSDR JJBA20231130036Unknown · unknownRF1 EXTERNAL LOWER FUSELAGE, CORROSION SUSPECTED BTW FR 61-63 RH AND AT STR 18R. RH STRINGER 18R SECTION BTW FR 61-66 INSTALLED AND STRINGER SPLICE COMPLETEDSDR JJBA20231128030Lamp · inoperativeFOUND RH FORWARD LOWER FAIRING EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH FORWARD LOWER FAIRING EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20231128021Acm · inoperativeSMOKE IN CABIN. REMOVED AND REPLACED RH ACM. OPS CHECK SAT. FOUND RH RECIRC FAN OUTLET MUFFLER DISCONNECTED, REATTACHED. OPS CHECK SAT.SDR JJBA20231128018Battery Pack · inoperativeFOUND FWD CENTER INTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY #4. OPS CHECK SAT. REMOVED AND REPLACED FWD CENTER INTERIOR EMERGENCY EXIT LIGHT. OPS CHECK SAT. NO FURTHER DEFECTS NOTED.SDR JJBA20231127017Lamp · inoperativeLEFT WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BULB FOR LH WING. OPS CHECK SAT.SDR JJBA20231127019Battery Pack · burned outFOUND LH OVERWING EMERGENCY LIGHT BURNT. REMOVED AND REPLACED BATTERY POWER SUPPLY #1 FOR THE LH FWD LWR FAIRING EXTERNAL EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20231128034Unknown · unknownUNRECORDED REPAIR DOUBLER FOUND ON BAGGAGE DOOR SKIN AROUND HANDLE CUT-OUT. SKIN REPAIRED WITH A DOUBLER BTW STA X22132.6-X22716.2 AND BTW HB#3-4SDR JJBA20231128033Unknown · unknownDENT FOUND ON BAGGAGE DOOR SKIN, 7 INCHES FROM FWD SKIN EDGE AND 9.5 INCHES FROM LOWER SKIN EDGE. SKIN REPAIRED WITH A DOUBLER BTW STA X22132.6-X22716.2 AND BTW HB#3-4SDR JJBA20231127016Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXTERNAL EMERGENCY LIGHT BULB. OPS CHECK GOOD.SDR JJBA20231128032Unknown · unknownCRACKS SUSPECTED (3X) ON RH SKIN AROUND FASTENERS BTW FR 77-80 & BTW STR 3R-9R. AFTER NDT INVESTIGATION, 1 CRACK FOUND, SKIN REPAIRED WITH 1 BUSHINGSDR JJBA20231128031Unknown · unknownRA #2 FWD ANTENNA BASE FOUND CORRODED. SKIN REPAIRED WITH A DOUBLER. CORROSION LEVEL 1SDR JJBA20231127020Radome · delaminatedELECTRICAL SMELL AND VISIBLE ARCING AT RADOME WHILE RADAR ON AND IN CLOUDS. PERFORMED DVI OF RADAR. OPS CHECKED. STBY SWITCH IN NORMAL POSITION, OPS CHECKED GOOD - NO FAULTS FOUND. PERFORMED DVI OF RADOME. FOUND DELAMINATION ON RADOME AND BOTH BONDING JUMPERS SDR JJBA20231127024Unknown · unknownCF1 EXTERNAL UPPER FUSELAGE SCRATCHES FOUND UNDERNEATH TOP TCAS ANTENNA. SKIN REPAIRED WITH A DOUBLER BTW FR 16-17 AND BTW STR 1L-1R UNDER TCAS ANTENNASDR JJBA20231120012Pump · inoperativeHYD SYS 1 FAIL. FOUND ENGINE DRIVEN PUMP AT FAULT, REMOVED AND INSPECTED PRESSURE AND CASE DRAIN FILTERS. OPS AND LEAK CHECK SAT. NO DEFECTS NOTED. REMOVED AND REPLACED ENGINE DRIVEN PUMP #1. REMOVED AND REPLACED E1 HYD EDP DUE TO LEAKS FOUND AFTER OPS CHECK. SDR JJBA20231121014Unknown · unknownCF1, CRACK FOUND ON ANGLE (2X) UNDER MIDDLE GUSSET BTW FR 20-22, ON FLOOR STRUCTURE AREA. REPLACED ANGLE (2X)SDR JJBA20231121013Unknown · unknownFWD FUSE II, FRAME 10 STR 9L ANGLE FOUND CRACKED. FWD FUSE II, FR10 STR 9L ANGLE REPLACED BY NEW ANGLESDR JJBA20231127029Unknown · unknownIN LH ENG PYLON, LH PRECOOLER STRUCTURE FWD BRACKET IS CRACKED. REPLACEDSDR JJBA20231127028Unknown · unknownRF2, DENT FOUND ON LH AFT DUAL STRAKES INBOARD SIDE, 1" FWD OF END RIB FR 81. DENT IS ACCEPTEDSDR JJBA20231127027Unknown · unknownNLG W/WELL, CRACK FOUND ON NLG UP-LOCK AFT CROSSBEAM. REPLACEDSDR JJBA20231120011Engine · faultedOILY SMELL COMING FROM THE ENGINE BLEED. ENGINE 2 HAS BEEN REPLACED.SDR JJBA20231113010Lamp · inoperativeFOUND LH OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH OVERWING EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20231113009Unknown · unknownELECTRICAL SMOKE ODOR IN FLIGHT. ODOR WAS ONLY IN THE FLIGHT DECK. EICAS SCREEN FLASHED WHITE THEN DISPLAYED NORMAL AGAIN A LITTLE BEFORE THE ODOR PRESENTED. NO SMOKE SMELL PRESENT WITH PACKS/APU RUNNING. COMPLIED WITH FIM. REMOVED, CLEANED, REINSTALLED EICAS SDR JJBA20231113008Unknown · unknownBURNING SMELL IN FLIGHT. PACK 2 IN MANUAL MODE, ALL THE WAY COLD. CREW PUT THE PACK 2 BACK IN AUTO MODE, AND THE SMELL SEEMED TO CLEAR. ALL INDICATIONS NORMAL, NO EICAS MESSAGES. POWER SETTING NEAR IDLE WHEN IT HAPPENED. NO SMOKE BAGGAGE/LAV ALARMS OR VISIUAL SDR JJBA20231108006Unknown · unknownCRACKS SUSPECTED (6X) ON RH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3R-9R. AFTER NDT INVESTIGATION, 5 CRACKS FOUND. SKIN REPAIRED WITH DOUBLER AND BUSHINGS.SDR JJBA20231106002Battery Pack · inoperativeFOUND EMERGENCY MARKER EXIT MAIN DOOR AND COCKPIT STEP INOPERATIVE. REMOVED AND REPLACED NUMBER 1 EMERGENCY LIGHT BATTERY. LIGHT OPS CHECK GOOD.SDR JJBA20231108007Unknown · unknownFWD FUSE 2, LH OVERHEAD SIDE FRAME ABOVE COCKPIT POST FOUND CRACKED. FRAME REPAIRED WITH A SPLICE.SDR JJBA20231106004Unknown · unknownCF1, EXT DENT FOUND ON LH MAIN DOOR SKIN JUST BELOW STR 15L ON LOWER EDGE OF DOOR SKIN. DENT ACCEPTEDSDR JJBA20231106003Unknown · unknownCF1, EXT DENT FOUND ON LH MAIN DOOR SKIN JUST BELOW STR 12L ON FWD EDGE OF DOOR SKIN. DENT ACCEPTEDSDR JJBA20231106001Controller · inoperativeLOST PRESSURIZATION ON CLIMB OUT IN AUTO. PERFORMED MANUAL PRESSURIZATION. OPS CHECK SAT. PERFORMED AUTO PRESSURIZATION. OPS CHECK FAILED. REMOVED AND REPLACED DIGITAL CONTROLLER. OPS CHECK SAT FOR NEW CONTROLLER. AIRCRAFT FAILED LEAK DOWN CHECK. REMOVED AND SDR JJBA20231106005Unknown · unknownCF1, ANGLE FOUND CRACKED ON LH AFT MAIN DOOR SURROUND STRUCTURE FR 19A STR 13L. REPLACEDSDR JJBA20231127026Unknown · unknownRH OUTBD FLAP SHOUD, OUTBD HINGE FOUND CRACKED. NEW PART INSTALLEDSDR JJBA20231127025Unknown · unknownCF1, CRACKS (3X) FOUND ON LH OMEGA BEAM #1 FLOOR STRUCTURE BTW FR 18-24. REPLACEDSDR JJBA20231127023Unknown · unknownCF1, CRACK FOUND ON FUEL RELAY AVIONIC BOX RH FWD SUPPORT BTW FR 15-16 AND BTW STR 7R-9R. CF1, ON FUEL RELAY AVIONIC BOX RH FWD SUPPORT BTW FR 15-16 AND BTW STR 7R-9R REPLACEDSDR JJBA20231127022Unknown · unknownLH OUTBD FLAP SHROUD, OUTB HINGE EYELET FOUND CRACKED. LH OUTBD FLAP SHROUD OUTBD HINGE REPLACEDSDR JJBA20231121015Unknown · unknownCF1, FRAME 16, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. ON CF1, FRAME 16, RH SHEAR CLIP REPLACED BTW STR 15R-16RSDR JJBA20231025042Amplifier · extinguishedCABIN AND CAB EMERGENCY LIGHTS WILL NOT EXTINGUISH. REMOVED AND REPLACED PA AMPLIFIER. OPS CHECK SAT.SDR JJBA20231026043Battery Pack · inoperativeFWD RH EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FWD RH EMERGENCY LIGHT BULB. OPS CHECK NOT SAT. PERFORMED OPS TEST ON #2 BPS. FOUND BPS #2 TO BE INOPERATIVE. REMOVED AND REPLACED BPS2. OPS CHECK SAT. NO FURTHER DEFECTS NOTED.SDR JJBA20231024041Battery Pack · inoperativeFOUND EMERGENCY BPS 1 INOPERATIVE. REMOVED AND REPLACED BPS #1. OPS CHECK SAT.SDR JJBA20231024040Unknown · unknownEMERGENCY ENGINE #1 OUT IN FLIGHT. PERFORMED #1 ENGINE BORESCOPE INSPECTION AND FOUND MISSING AND DESTROYED VARIABLE BLADES AND COMPRESSOR BLADES. FOUND NO DAMAGE TO AIR INLET AND T/R. REMOVED AND REPLACED #1 ENGINE.SDR JJBA20231023039Unknown · unknownEMERGENCY LIGHT ON MCD INOPERATIVE. REMOVED AND REPLACED MCD LAMP. OPS CHECK FAIL REMOVED MCD LINER. FOUND GROUNDING WIRE NOT ATTACHED TO EMERGENCY LIGHT HOUSING. REMOVED HOUSING SCREW. INSTALLED GROUNDING WIRE ONTO HOUSING SCREW. INSTALLED SCREW. INSTALLED MCSDR JJBA20231101055Unknown · unknownNLG W/WELL, CRACK FOUND ON NLG UP-LOCK AFT CROSS BEAM. REPLACEDSDR JJBA20231030053Unknown · unknownCF1, LH SILL #1 BTW FR 18-24 FOUND CORRODED. LH SILL #1 BTW FR 18-24 REPLACEDSDR JJBA20231030050Unknown · unknownCF1, FRAME 15, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20231030046Unknown · unknownAT RF1, LH ENTRANCE GUSSET BTW FR 65-68 ON FLOOR STRUCTURE FOUND CORRODED. AT RF1, LH ENTRANCE GUSSET BTW FR 65-68 REPLACEDSDR JJBA20231030054Unknown · unknownCF1, CRACK FOUND ON MIDDLE STEP FRAME ON FLOOR STRUCTURE MIDDLE OMEGA BEAM BTW FR 18-20. REPLACEDSDR JJBA20231030052Unknown · unknownCF1, CRACK FOUND ON FWD ANGLE UNDER MIDDLE GUSSET BTW FR 20-21 ON FLOOR STRUCTURE AREA. PART REMOVED AND REPLACEDSDR JJBA20231030051Unknown · unknownCF1, 2X ANGLES FOUND CRACKED ON LH BEAM AND 2X ANGLE CRACKED ON MID OMEGA BEAM AT FWD AND AFT DIGITAL PLATE JUNCTION. ANGLE REMOVED AND REPLACEDSDR JJBA20231030049Unknown · unknownIN RH ENGINE PYLON, RH PRECOOLER FWD STRUCTURE BRACKET IS CRACKED. BRACKET REPLACEDSDR JJBA20231030048Unknown · unknownIN LH ENGINE PYLON, LH PRECOOLER FWD STRUCTURE BRACKET IS CRACKED. BRACKET REPLACED
Back to Embraer EMB-145XR