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 JJBA20210922021None · noneBAGGAGE DOOR SCRATCHED ABOVE FLAPPER DOOR. ON BAGGAGE DOOR ABOVE FLAPPER AREA STRIPPED FOR INVESTIGATION, SCRATCH WITH DENT OUT OF LIMITS. PERFORMED CUT-OUT ON BAGGAGE DOOR. FABRICATED, LOCATED, AND DRILLED REPAIR DOUBLER AND REPAIR FILLER. INSTALLED REPAIR PASDR JJBA20210922016None · noneCENTER FUSE IV, UNDER FLOOR, FRAME 59 CORRODED BTW STR 21R-21L. FR 59 SEGMENT BTW STR 20R-20L CUT OUT SPLICE REPAIR. FR 59 SEGMENT BTW STR 20R-20L. 2 SPLICE REPAIRS FABRICATED. NO CORROSION FOUND. CF IV, UNDERFLOOR FR 59 BTW STR 20L-20R REPAIRED WIT 2 SPLICES.SDR JJBA20210922008None · noneCF2, RH SIDE, FR25 AT FLOOR LEVEL BEHIND SILL, FRAME FOUND CRACKED. FRAME SPLICED.SDR JJBA20210922034None · noneCORROSION FOUND ON CENTER AISLE LH OMEGA BEAM LOCATED BETWEEN FR 23- FR 29. REMOVED AND REPLACED LH OMEGA BEAM, LOCATED BETWEEN FR 23-FR29SDR JJBA2021092200021None · noneTHE PASSENGER FWD CABIN LH FLOOR OMEGA DOUBLER HAS CORROSION ON THE FWD SURFACE BETWEEN FR 14 TO FR 18. REMOVED AND REPLACED DIGITAL PLATE ON PASSENGER FWD CABIN LH FLOOR BETWEEN FR 14 TO FR 18.SDR JJBA20210922020None · noneCORROSION AT MULTIPLE LOCATONS FOUND ON RH CENTER AISLE LONGITUDINAL BEAM LOCATED BETWEEN FR29-FR36 Y.00+8. REMOVED AND REPLACED BEAM ASSEMBLY ON RH CENTER AISLE LOCATED BETWEEN FR29-FR36 Y.00+8.SDR JJBA20210922019None · noneCORROSION NOTED AT ELT ANTENNA MOUNTING SURFACE. EVALUATED CORROSION AT ELT ANTENNA DOUBLER AND FOUND OUT OF LIMITS. REMOVED AND REPLACED ELT ANTENNA DOUBLER.SDR JJBA20210922018None · noneAFTER REMOVAL OF UPPER TCAS ANTENNA, INSPECTED AIRCRAFT SKIN FOUND SEVERAL SCRATCHES AT MATING SURFACE. REMOVED SCRATCHES ON UPPER TCAS ATTENNA DOUBLER BY BLENDING, MATERIAL LOSS FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED UPPER TCAS ANTENNA DOUBLERSDR JJBA20210922017None · noneCARGO DOOR INTERNAL STRUCTURE LOWER WEB HAS MULTIPLE AREAS OF SCREW INDENTION DAMAGE. REMOVED AND REPLACED AFT CARGO DOOR INNER SKIN WEB.SDR JJBA20210922015None · noneMAIN CABIN - RH O/B FLOOR BOARD SUPPORT STRUCTURE HAS CORROSION MULTIPLE LOCATIONS BETWEEN FR 40 TO FR 41 RH. REMOVED AND REPLACED SILL IN MAIN CABIN - RH OB FLOOR BOARD SUPPORT STRUCTURE BETWEEN FR 40 TO FR 41 RHSDR JJBA20210922014None · noneAFT CARGO COMPARTMENT AT DOOR CUT-OUT LOWER FRAME HAS 3 SCREW HOLES SHOWING SIGNS OF CORROSION BETWEEN FRAME 65 - 68. REMOVED AND REPLACED AFT CARGO COMPARTMENT, DOOR CUT-OUT LOWER FRAME BEAM BETWEEN FRAME 65-68SDR JJBA20210922013None · noneTHE PASSENGER ENTRY DOOR WAY FWD FRAME LOWER SPLICE TO FLOOR BEAM IS CRACKED. REMOVED AND REPLACED LOWER REINFORCEMENT SPLICE TO FLOOR BEAM PASSENGER ENTRY DOOR WAY FWD FRAME.SDR JJBA20210921011None · noneCENTER FUSE IV, UNDER FLOOR, LH GUSSET BTW FRAME 59-61 CORRODED. OMEGA BEAM BLENDED OUT OF LIMITS BTW FR 60-61. CENTER FUSE IV BTW FR 60-61, LH OMEGA BEAM REPAIRED AND GUSSET REPLACED. NO CORROSION FOUND.SDR JJBA20210921033None · noneLH FUSELAGE AT FR60 SILL AREA, SMALL PLATE FOR WATER SUPPLY HAS A CRACK AT NUT PLATE. INSTALLED EWIS PROTECTION ON LH FUSELAGE AT FR60 TO FR 59. REMOVED CABLE AND DUCT FAIRING FOR ACCESS. REMOVED DAMAGED SMALL PLATE, LOCATED AND DRILLED NEW PLATE. RE-INSTALLEDSDR JJBA20210920031Battery · inoperativeRH FWD EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT PLACARD ASSEMBLY. OPS CHECK BAD. R&R CHASSIS ASSEMBLY AND BATTERY PACK. OPS CHECK SATSDR JJBA20210919027None · noneRH FR19, Y=479 SUSPECT CORROSION ON HAT-BEAM. REMOVED AND REPLACED HAT BEAM AT Y=479 RH FR19 CORROSION LEVEL 2SDR JJBA20210915030Ballast · meltedSMELL OF INSULATION BURNT IN CABIN APPROX HALF WAY UP FOUND PLASTIC BULB SOCKET ON CEILING LIGHT BALLAST AT SEAT 18A MELTED. REMOVED AND REPLACED HARNESS ASSEMBLY ELECTRICAL. OPS CHECK SAT.SDR JJBA20210913009None · noneVENTRAL FUEL TANK, FWD SECTION BRACKET CORRODED. WEB REPAIRED. CORROSION LEVEL 1.SDR JJBA20210913032Skin · crackedRF 1, BTW FR 77-79 BTW STR 3R-9R, CRACK SUSPECTED AROUND FASTENERS. RF1, BTW FR77-79 BTW 3R, 9R PAINT REMOVED AROUND FASTENERS FOR INVESTIGATION CRACK CONFIRMED. AT FR 79 AND STR 4R 3 CRACKS FOUND AND REPAIRED WITH DOUBLERSDR JJBA202109153027Sign · brokenEMERGENCY EXIT SIGN ABOVE FA JUMP SEAT IS BROKEN. RESECURED EMERGENCY EXIT SIGN ABOVE FA JUMP SEAT. NO FURTHER DEFECTS NOTEDSDR JJBA202109153026Inverter · faultedEMERGENCY LIGHT ON AFT GALLEY WALL INOPERATIVE. SWAPPED CANNON PLUGS ON EMERGENCY LIGHT INVERTERS 2 AND 3, FAULT FOLLOWED ON INVERTER 3. REMOVED INVERTER 3. REPLACE INVERTER FOR EMERGENCY LIGHTS. OPS CHECK GOOD.SDR JJBA202109152029Structure · out of alignmentMCD TRIM IS PREVENTING THE DOOR FROM OPENING FULLY. RE-ALIGNED MAIN CABIN DOOR TRIM. NO FURTHER DEFECTS NOTED. OPS CHECK SAT.SDR JJBA20210909013None · noneCENTER FUSE IV, UNDER FLOOR, CENTER OMEGA BEAM BTW FRAME 59-61 CORRODED. CENTER OMEGA BEAM BTW FR 60-61 IN CENTER FUSE IV UNDERFLOOR, CORROSION UNDER NUT PLATE CUT. CENTER OMEGA BEAM BTW FR60-61 IN CENTER FUSE IV REPAIRED WITH DOUBLER. NO CORROSION FOUND.SDR JJBA20210909012None · noneCENTER FUSE IV, UNDER FLOOR, RH OMEGA BEAM BTW FR 59-61 CORRODED. RH OMEGA BEAM BTW FR 60-61 IN CENTER FUSE IV UNDERFLOOR, CORROSION UNDER NUT PLATE CUT. RH OMEGA BEAM BTW FR60-61 IN CENTER FUSE IV REPAIRED WITH DOUBLER. NO CORROSION FOUND.SDR JJBA2021091508028Muffler · disconnectedPACK 2 OVERHEAT IN FLIGHT. PACK 1 MUFFLER DISCONNECTED. RECONNECTED MUFFLER. OPS CHECK SATSDR JJBA2021091508025Battery Pack · inoperativeEMERGENCY LIGHT EXIT SIGN AT ROW 18 INOPERATIVE. R&R #3 BATTERY PACK. OPS CHECK SAT. NO DEFECTS NOTEDSDR JJBA202109085002Light · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN CABIN DOOR EMERGENCY LIGHT ASSY AND BULB. OPERATIONAL CHECK OF THE EMERGENCY LIGHT FOUND SATISFACTORYSDR JJBA202109083012Floor Support · corrodedTHE PASSENGER CABIN RH SIDE OMEGA FLOOR BEAM DOUBLER HAS CORROSION JUST FWD OF FR19 UPPER SURFACE. BLENDED CORROSION ON RH OMEGA BEAM JUST FORWARD OF FRAME 19. FOUND TO HAVE 100% MATERIAL LOSS AND OUT OF ALLOWABLE LIMITS. CUT OUT DAMAGE ON RH OMEGA BEAM JUST FSDR JJBA202109083001Lamp · inoperativeMCD ENTRANCE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT LAMP. OPS CHECK SATSDR JJBA202109082022Yoke · gougedLH FWD YOKE UPPER FWD BOLT HOLE HAS GOUGES. REPAIRED LH FWD YOKE UPPER FWD BOLT HOLE.SDR JJBA2021090830024Frame · corrodedCENTER FUSE IV UNDER FLOOR, FRAME 59 CORRODED. CENTER FUSE IV UNDERFLOOR FR59 HAS EXFOLIATED CORROSION AND IS OUT OF LIMITS. PERFORMED CUT OUT FRAME SECTION BTW STR 20L-20R FRABRICATED U FRAME SECTION FROM 7075-0 0.032" AND FABRICATED QTY 2 FRAME SPLICE REPAIRSDR JJBA2021090830023Yoke · cracked2X CRACK FOUND ON PYLON YOKES UPPER FLANGE AT 2X HOLE LOCATION. INSTALLED LH AND RH BUSHINGS AND PERFORMED COLD WORK BUSHING HOLES THEN REAMED FULL SIZE AND INSTALLED NEW JO-BOLTS AND WASHERS WET INSTALLED AND RESTORED FINISH ALL FASTENERS.SDR JJBA2021090130074Battery Pack · inoperativeEMERGENCY LIGHT BY 3C INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY #2. OPS CHECK SAT.SDR JJBA20210826057Light · inoperativeEMERGENCY LIGHT ABOVE PAX DOOR INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ABOVE PAX DOOR. OPS CHECK SATSDR JJBA20210825051Sign · unsecureEXIT SIGN AT ROW 18 UNSECURE. RESECURED EXIT SIGN AT ROW 18 AS REQUIRED.SDR JJBA20210823052Battery Pack · inoperativeBOTH LH EMERGENCY LIGHT, RH OVER WING EMERGENCY LIGHT MAIN CABIN DOOR EMERGENCY LIGHTS ALL INOPERATIVE. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY. OPS CHECK SAT.SDR JJBA20210822011Frame · crackedDIRECTLY UNDER CAPTAINS DV WINDOW CUTOUT FRAME 10 CRACKED. REMOVED CHANNEL UNDER CAPTAINS DV WINDOW CUTOUT AT FR10. LOCATED AND DRILLED NEW CHANNEL UNDER CAPTAINS DV WINDOW CUTOUT AT FR10. TREATED AND PRIMED ALL HOLES. INSTALLED NEW CHANNEL UNDER CAPTAINS DV WSDR JJBA20210822010Support · corrodedCARGO DOOR CUTOUT INTERNAL SUPPORT STRUCTURE CORRODED AT FWD LOWER EDGE. REMOVED LOWER PART OF SHEAR CLIP. LOCTED AND DRILLED NEW LOWER END OF SHEAR CLIP. INSTALLED LOWER PART OF SHEAR CLIP. INSTALLED DOOR CLIP. INSTALLED NEW T PROFILE. TOPCOATED FASTENERS ON SDR JJBA20210822009Support Beam · crackedPASSENGER DOOR UPPER AFT REINFORCING SUPPORT BEAM CRACKED AT FR19 AND STGR 3L. REMOVED BEAM AT FR19, LEFT STRINGER 3. LOCATED, DRILLED, DEBURRED NEW SUPPORT BEAM. TREATED AND PRIMED FASTENER HOLES. INSTALLED PASSENGER DOOR UPPER AFT REINFORCING SUPPORT BEAM. RSDR JJBA20210822008Doubler · damagedLH - FR 14 BETWEEN STGR LH7 AND STGR LH8 - LH BULKHEAD - SUPPORT DOUBLER - HOLE ELONGATED. REMOVED EXISTING DOUBLER. FABRICATED REPAIR DOUBLER. CLEANED, TREATED AND APPLIED PRIMER TO REPAIR AREA AND DOUBLER. INSTALLED REPAIR DOUBLER. RESTORED FINISH.SDR JJBA2021090822007Skin · crackedEXTERNAL SKIN CRACKED AT FO'S DV WINDOW CUTOUT AFT UPPER CORNER. CUTOUT DAMAGED AREA AND REMOVED ALL EXISTING FASTENERS IN REPAIR AREA. TREATED AND PRIMED FUSELAGE SKIN. FABRICATED, LOCATED AND DRILLED REPAIR FOR FUSELAGE SKIN ABOVE FO'S DV WINDOW. TREATED ANDSDR JJBA2021090822006Frame · crackedDIRECTLY UNDER FO'S DV WINDOW CUTOUT FRAME 10 CRACKED. REMOVED CHANNEL UNDER FO'S DV WINDOW CUTOUT AT FR10. LOCATED AND DRILLED NEW CHANNEL UNDER FO'S DV WINDOW CUTOUT AT FR10. TREATED AND PRIMED ALL HOLES. INSTALLED NEW CHANNEL UNDER FO'S DV WINDOW CUTOUT AT SDR JJBA20210821003Rib · corrodedLH AILERON INBD RIB SHOWS SIGNS OF CORROSION. FABRICATED AND REPLACED LH AILERON INBD RIB.SDR JJBA2021090127063Floor Support · crackedFLOOR SUPPORT FOR PANEL 271FF AT FRAME 66 IS CRACKED. REMOVED AND REPLACED FLOOR SUPPORT AT PNL 271FFSDR JJBA20210821050Light · inoperativeEMERGENCY LIGHT ON SERVICE DOOR NOT WORKING. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY ON DOOR. OPS CHECK SAT.SDR JJBA202108250056Rib · crackedFF2, LH FUSE OVER WINDSHIELD, RIB OVER HEAD PANEL HORIZONTAL CRACKED AT ANCHOR NUT LOCATION. PANEL REPAIREDSDR JJBA20210819053Doubler · not reportedINSPECT FWD PRESSURE BULKHEAD AND LOCATE CIRCULAR DOUBLER AND REMOVE MAP. REMOVED DOUBLER OF FWD PRESSURE BULKHEAD, FABRICATED NEW DOUBLER FROM 2024T3 .050" DIM 0 2.4, INSTALLED NEW DOUBLER.SDR JJBA20210819049Charger · inoperativeRH FWD WTF FAIRING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED #2 EMERGENCY LIGHT BATTERY CHASSIS. OPS CHECK SAT, ALSO R&R RH FWD EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SATSDR JJBA2021082518054Doubler · corrodedCORROSION ON LOWER REAR FUSE 1, ON ANTENNA DOUBLER FOR AFT RADIO ALTIMETER #2 BTW FR 68-69. SKIN REPAIRED.SDR JJBA20210818048Panel · corrodedVERTICAL STAB INSIDE PANEL 325CL THE UPPER RUDDER ACTUATOR CONNECTING HARDWARE IS CORRODED. REMOVED & REPLACED UPPER RUDDER ACTUATOR BOLT & HARDWARE
Back to Embraer EMB-145XR