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 JJBA20211119013None · noneCARGO DOOR INNER SKIN HAS MULTIPLE SCREW DAMAGE. REMOVED AND REPLACE LOWER INNER CARGO DOOR SKIN WEB.SDR JJBA20211119032Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BULB. OPS CHECK PASS.SDR JJBA20211118038Skin · dentedLH FWD FUSELAGE II, DENT FOUND ON EXTERNAL SKIN BTW FR 8-9 AND STR 18L-20L. DENT REMOVED BY CUT OUT ON LH FWD FUSE II EXTERNAL SKIN BTW FR 8-9 AND STR 18L-20L. PATCH DOUBLER LOCALLY FABRICATED. AT LH FWD FUSELAGE II, EXTERNAL SKIN BTW FR 8-9 AND STR 18L-20L DESDR JJBA20211118034None · noneCF1 FLOOR STRUCTURE PROFILE OMEGA BTW FR 20-23 LH CORRODED. AFTER FURTHER INVESTIGATION OMEGA BEAM FOUND CRACKED AT FASTENERS LOCATION. CF1 FLOOR STRUCTURE, OMEGA BEAM REPLACED.SDR JJBA20211118028Strap · missingEMERGENCY EXIT LIGHTING STRIP MISSING BY 1A. R&R EMERGENCY EXIT LIGHTING STRIP.SDR JJBA20211117033None · noneLH FLOOR SILL FROM FRM 53-59 HAS SIGNS OF CORROSION. REMOVED AND REPLACED FLOOR SILL FROM FR 53 TO 59. RESTORED FINISH AND APPLIED CICSDR JJBA20211116031Light · inoperativeLH WING INSPECTION LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT. OPS CHECK SATSDR JJBA20211115030None · noneFOUND LH UPPER EMERGENCY EXIT LIGHT INOPERATIVE ON OVERWING HATCH SIDEWALL. REMOVED LIGHT. TROUBLESHOT LIGHT AND FOUND CONNECTORS TO LIGHT TO BE NOT PROPERLY SEATED, RESEATED CONNECTORS AND REINSTALLED LIGHT. OPS CHECK SATSDR JJBA20211115029None · noneBIRD STRIKE. PERFORMED SECTION 1: TEMPORARY REPAIR TO FWD FUSELAGE SKIN.SDR JJBA20211115023None · noneSIGNS OF CORROSION ON RH UPPER FLOOR BEAM TRACK SUPPORTS AFT OF FRM 52. REMOVED AND REPLACED BEAM, HAT ASSY FROM FR 49 - FR 55 RHSDR JJBA20211115017Life Vest · tornFO LIFE VEST BAG TORN OPEN. R&R FO LIFE VESTSDR JJBA20211114015Flashlight Assy · odorSMOKE ODOR AT FLT 190 AND REMAIN THE REMAINDER OF THE FLIGHT. REMOVED AND REPLACED BOTH THE CAPTAINS AND FLT ATTENDANTS FLASH LIGHT ASSEMBLIES.SDR JJBA20211113024None · noneLH AFT FUSELAGE, INTERIOR AT FR59-FR61 @ Y=479.0 HAS SIGNS OF CORROSION UNDER FLOOR BY LAV. REMOVED AND REPLACED LH FR 59 - FR 61 @ Y=479 GUSSETSDR JJBA20211113022None · noneSIGNS OF CORROSION UNDER GUSSET LH AT HAT BEAM FR59-61 BL-479. ACCOMPLISHED CENTER FUSELAGE IV-CF IV FLOOR STRUCTURE OMEGA BEAM, CORROSION PERMANENT REPAIR AT FR 59 AT FR61 BL479 LSDR JJBA20211113021None · noneSIGNS OF CORROSION UNDER GUSSET CENTER AT HAT BEAM FR59-61, BLO. ACCOMPLISHED CENTER FUSELAGE IV-CF IV FLOOR STRUCTURE-OMEGA BEAM CORROSION PERMANENT REPAIR. HAT BEAM, CENTER FR59-FR61, BLOSDR JJBA20211113020None · noneAFT FUSELAGE INTERIOR, FR 59-61 C Y=0.0 HAS SIGNS OF CORROSION UNDER FLOOR BY LAV. REMOVED AND REPLACED GUSSET AT FR 59 - 61 CY=0.0SDR JJBA20211111016None · crackedFOUND OBSERVER SEAT SMOKE GOGGLE LENS CRACKED. R&R OBSERVER SMOKE GOGGLE.SDR JJBA20211110019None · noneRH FLOOR SILL FROM FR 65-68 HAS SIGNS OF CORROSION. REMOVED AND REPLACED DAMAGE SILL AT FR 65-68 RH SIDE,SDR JJBA20211110018None · noneFLOOR BEAM DOUBLERS LOCATED AT STGR 15R BETWEEN FRM 20 & 22 SHOW SIGNS OF CORROSION ON HARDWARE HOLES. BLEND OUT CORROSION DOUBLER AT FR 22 FOUND TO BE IN LIMITS AND RESTORED FINISH. REMOVED AND REPLACED DOUBLER AT FR 20 RH.SDR JJBA20211107014None · noneMAIN CABIN DOOR EMERGENCY LIGHT INOPERATIVE. R&R LIGHT BULB. OPS CHECK SAT.SDR JJBA20211107013None · noneRH AFT EMERGENCY LIGHT INOPERATIVE. R&R AFT EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR JJBA20211106012None · noneEXIT MARKING SIGNS AT MAIN DOOR FOUND TO BE INOPERATIVE. R&R EXIT MARKING SIGN BATTERY POWER SUPPLY. OPS CHECK SAT.SDR JJBA20211103005None · noneLH OB FLOOR SILL SHOWS SIGNS OF CORROSION BETWEEN FRAMES 36-42. REMOVED AND REPLACED FLOOR SILL FRAME 36-42 LH OB SIDESDR JJBA20211102026None · noneMAIN CABIN CENTER BOX AREA, RH SIDE MOST O/B BUTT STRAP ATTACH ANGLE BELOW FRAME 46 PLUS "5" INCHES THRU PLUS "17" INCHES HAS SEVERAL HI-LOCS THAT HAVE SURFACE CORROSION SHOWING. REMOVED AND REPLACED OB BUTT STRAP ATTACHE ANGLE BELOW FRAME 46 PLUS "5" INCHES TSDR JJBA20211102004None · noneREINFORCEMENT SILL SHOWS SIGNS OF CORROSION AFT OF SERVICE DOOR STARTING AT FRM 22. REPAIRED AREA AT AFT OF SERVICE DOOR STARTING AT FR 22. CORROSION LEVEL 2SDR JJBA20211101011None · noneSMALL DENT FOUND IN BOTTOM CORNER OF MAIN DOOR. CUT OUT PERFORMED, FILLER AND DOUBLER FABRICATED. DENT ON BOTTOM AFT CORNER OF THE MAIN DOOR REPAIRED.SDR JJBA20211101010None · noneAS PER CUSTOMER REQUEST, REPAIR DOUBLER ON RH CENTER FUSE 1 BTW FR 22A-23 AND BTW STR 13R-14R, NEED TO BE REMOVED FOR INVESTIGATION. REMOVED REPAIR DOUBLER ON RH CENTER FUSE 1 BTW FR 22A-23 & BTW STR 13R-14R FOR INVESTIGATION. CUT AWAY DAMAGE ON RH CENTER FUSESDR JJBA20211101009None · noneCORROSION FOUND ON LH AFT L-SHAPE CARGO DOOR SURROUND STRUCTURE AT FR68 BTW STR 15-17. AT FR 68 BTW STR 15 AND 17 SHEAR CLIP BLENDED AND FOUND OUT OF LIMIT. "L" SHAPE AT FR68 BTW STR 15-17 LOCALLY FABRICATED. RPAIR PARTS INSTALLED ("L" SHAPE) AT CARGO DOOR FR6SDR JJBA20211101008None · noneNICKS FOUND ON TOP SKIN AROUND EXISTING REPAIR DOUBLER BTW FR 54 TO 55 AND STR 1R TO 1L IN CENTER FUSE IV AREA. ON TOP SKIN AROUND EXISTING REPAIR DOUBLER BTW FR 54 TO 55 AND STR 1R-1L, NICKS FOUND OUT OF LIMITS. ON TOP FUSE BTW FR 54 TO 55 AND STR 1R TO 1L SKSDR JJBA20211101007None · none2 DENT FOUND SKIN BTW FR 6 AND JUN 1 BTW STR 13-15 LH. ON LH FWD FUSE 1 SKIN, BTW FR 6-7 AND BTW STR 13L-15L DENTS (2X) ARE OUT OF LIMITS. PERFORMED CUT OUT AND FABRICATED REPAIR DOUBLER AND QTY 2 FILLERS. INSTALLED REPAIR DOUBLER & 2 FILLERS ON SKIN BTW FR56 SDR JJBA20211101006None · noneCF1, BTW FR 13-14 AND BTW STR 10R-11R, SKIN DAMAGED DURING RIVET REPLACEMENT. BTW FR 13-14 AND BTW STR 10-11 RH REPAIR ON SKIN PERFORMEDSDR JJBA20211030066Lamp · dimEMERGENCY LIGHT DIM IN GALLEY OVERHEAD PANEL. REMOVED AND REPLACED LIGHT BULB. OPS CHECK SATSDR 2021F00301Light · no testEMERGENCY EXIT LIGHT AT ROW 18A, LT OVER WING EMERGENCY EXIT FAILED OPERATIONAL CHECK.SDR JJBA20211028064None · noneAFT EMERGENCY EXIT LOCATING SIGN INOPERATIVE. RE SECURED CONNECTORS ON AFT EMERGENCY EXIT LOCATOR SIGN. OPS CHECK SAT.SDR JJBA20211027060None · noneMCD EXTERIOR EMERGENCY LIGHT INOPERATIVE. R&R MCD EXT EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR JJBA20211026002None · noneDENT FOUND ON EXTERNAL SKIN BTW FR 79-80 AND BTW STR 11LH - 12LH. ON LH REAR FUSE 2 SKIN, AFTER INVESTIGATION, DENT IS LOCATED BTW FR80-81 AND BTW STR 11L-13L. DENT IS OUT OF LIMITS. PAINT STRIPPED FOR INVESTIGATION AT DENT LOCATION. DENT ON EXTERNAL SKIN BTW SDR JJBA20211026001None · noneCRACK FOUND ON LH FRAME 59 BTW STR 15L-16L IN CF IV AREA. LH FRAME 59 REPAIR FRAME SEGMENT AND SPLICE FABRICATED. LH FRAME 59 REPAIR PERFORMED BTW STR 14L-18L WITH NEW FABRICATED FRAME SEGMENT AND SPLICE.SDR JJBA20211026059Valve · inoperativeENG 2 A/ICE FAIL IN FLIGHT (FL 200 CLIMBING OUT, IN ICING, CLIMBED OUT OF ICING TO FL 230, ON FOR 1 MIN, "ICING CONDITION WITH ANTI ICING INOPERATIVE WARNING MSG", THROTTLES AT 89N2). R&R #2 ENG ANTI ICE VALVE. R&R E2 ANTI ICE PRESS XDUCER. PERFORMED OPS CHECKSDR JJBA20211025056Strap · missingFLOOR PATH EXIT LOCATION NOT CORRECT PER FA. REPLACED MISSING SECTION OF PHOTOLUMINESCENT STRIPSDR JJBA20211024055Fairing · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. R&R MCD EMERGENCY LIGHT HOUSING. OPS CHECK SAT.SDR JJBA20211024054Inverter · faultyEXIT MARKING ASSEMBLY FORWARD OF SEAT 3C INOPERATIVE. SWAPPED EXIT MARKING WITH EXIT SIGN ABOVE FA SEAT. FAULT DID NOT FOLLOW. SWAPPED EMERGENCY LIGHT DC/AC INVERTER. FAULT FOLLOWED #3 INVERTER. ALL PARTS RETURNED TO ORIGINAL POSITION. R&R EMERGENCY LIGHT INVESDR JJBA20211022058Inverter · inoperativeFWD SIDE OF EMERGENCY EXIT SIGN OVER ROW 18 NOT ILLUMINATED. R&R #5 EMERGENCY LIGHT INVERTER. OPS CHECK GOOD AT FWD SIDE EMERGENCY ROW 18SDR JJBA20211020057Battery Pack · inoperativeEMERGENCY EXIT SIGN INOPERATIVE OVER ROW 18. REMOVED AND REPLACED BATTERY (EMERGENCY) PACK AND R&R BATTERY CHARGER ASSEMBLY. OPS CHECK GOOD.SDR JJBA20211019030None · noneRH SIDE EMERGENCY LIGHT STRIP FROM SEAT 3C TO 5C NOT GLOWING. CHECKED RH EMERGENCY ILLUMINE-SCENT STRIP BETWEEN ROW 3D TO 5D. FOUND EMERGENCY ILLUMINE-SCENT STRIP TO FUNCTION NORMALLY.SDR JJBA20211017053None · noneAT CF4 LH SIDE, CRACK FOUND IN FR59 AROUND FLOOR. ON LH CENTER FUSE 4, SPLICE AT FR59 AND STR 13L REMOVED FOR ACCESS. ON LH CENTER FUSE 4, SPLICE AT FR 59 REPAIRED AND ALTERNATE MATERIAL FOR FABRICATION OF FR59 SECTION AND SPLICE REPAIR. SPLICE ON FR59 AND STRSDR JJBA20211017052None · noneCF II CENTER OMEGA BEAM 2 CRACKS FOUND AT FR 25 AND FR 27. CFII, CENTER OMEGA BEAM AT FR 25-27 REPAIREDSDR JJBA20211017051None · nonePAX DOOR UPPER BALANCING BAR FUSELAGE FITTING BOLT HOLE ELONGATED. ON PAX DOOR UPPER HINGE FITTING, BOLT LUGS REWORKED. 2X BUSHINGS LOCALLY FABRICATED ON PAX DOOR UPPER HINGE FITTING, BUSHING INSTALLED ON BOTH. REWORKED LUGS.SDR JJBA20211017029None · noneLARGE EXIT SIGN NEXT TO RH EMERGENCY EXIT DOOR DOES NOT ILLUMINATE. R&R EXIT MARKING SIGN ASSEMBLY. OPS CHECK SATSDR JJBA20211016028None · noneRIGHT HAND FWD EMERGENCY EXTERNAL LIGHT INOPERATIVE. R&R RIGHT HAND FWD EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20211015027None · noneRIGHT WING CENTER LEADING EDGE #612, HAS LARGE DENT 37 INCHES FROM I/B END. REPAIRED DENT IN RIGHT WING CENTER LEADING EDGE 612 37 INCHES FROM INBD END.
Back to Embraer EMB-145XR