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 JJBA20220413021None · inoperativePSU ATTENDANT CALL LIGHT AT SEAT ROW 18A NOT ILLUMINATED. PSU PRINTED CIRCUIT BOARD REPLACEDSDR JJBA20220413019Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20220413014None · inoperativeEMERGENCY EXIT LIGHT AT LEFT EMERGENCY HATCH INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT AT LEFT EMERGENCY HATCH. OPS CHECK SAT.SDR JJBA20220412008None · noneLH OMEGA BEAM AT FR 38 - FR 44 HAS CORROSION AROUND SURFACE OF FASTENER HOLES. REMOVED AND REPLACED LH OMEGA BEAM.SDR JJBA20220412020None · noneVERY PUNGENT ODOR IN COCKPIT AND CABIN AFTER PERFORMING THE B TEST (14,000 FT). REMOVED AND REPLACED #2 WS TEMP CPNTROLLER. DID NOT FIX. FOUND TERMINAL (G) DAMAGED AT WIRE W102-0850-6N OF WINDSHIELD 2 HEATING SYSTEM. REMOVED AND REPLACED GROUND WIRE TERMINAL ASDR JJBA20220411015None · noneRH WING FLEX SHAFTS 1-4 HAVE CORROSION ON FITTINGS UNDER HEAT SHRINK. REMOVED AND REPLACED FLAP FLEX SHAFTS ON RIGHT WINGSDR JJBA20220410013Battery Pack · inoperativeEMERGENCY LIGHT NEAR MAIN DOOR INOPERATIVE. REMOVED AND REPLACED #1 EMERGENCY BATTERY. OPS CHECK SAT AT THIS TIMESDR JJBA20220410012None · wornRIGHT HAND EXTERIOR OVERWING "EXIT" PLACARD ILLEGIBLE. REMOVED AND REPLACED EXTERIOR OVERWING EXIT PLACARD. NO DEFECTS NOTED.SDR JJBA20220409011Controller · overheatedWINDSHIELD HEAT TERMINALS OVERHEATING PRODUCED BURNING SMELL. REMOVED AND REPLACED WINDSHIELD HEAT TEMP CONTROLLER. NO BURNING SMELL. OPS CHECK SAT.SDR JJBA20220406010None · damagedSUPPLEMENTAL INFORMATION: REMOVED DAMAGE PORTION OF WIRES AND DAMAGED ELECTRICAL CONNECTOR PLUG TO #1 WINDSHIELD TEMP CONTROLLER. PINNED NEW ELECTRICAL CONNECTOR PLUG TO #1 WINDSHIELD TEMP CONTROLLER. PINNED ELECTRICAL CONNECTOR PINS FOR #1 WINDSHIELD TEMP CONSDR JJBA20220406009None · noneCOCKPIT CEILING RH A/O FRAME CRACKED. REMOVED AND REPLACED FRAME AT COCKPIT CEILING RH A/O FRAMESDR JJBA20220406008None · noneLT WING FLAP FLEX SHAFTS #1, #2, #4 DAMAGED FERRULES. REMOVED AND REPLACED LEFT WING FLAP FLEX SHAFTS SECTIONS 1, 2, AND 4.SDR JJBA20220406007None · noneDENT LOCATED ON PASS DOOR AT 7" FROM LOWER EDGE AND ON AFT EDGE. FABRICATED AND IND INSTALLED REPAIR DOUBLER AND REPAIR FILLER AT PASS DOOR AT 7" FROM LOWER AFT SIDE.SDR JJBA20210404018None · noneAT CF IV AREA, CRACKS FOUND ON LH FRAME 59 BTW STR 15L-17L. LH SPLICE FR59 BTW STR 15L-17L REMOVED. AT CFIV AREA ON LH FRAME 59 BTW STR 15L-17L INSTALLED REPAIR SPLICE. DURING INSPECTION, FRAME REPAIR AND SPLICE FOUND TO BE FABRICATED WITH WRONG THICKNESSSDR JJBA20220404017None · noneAT REAR FUSE AREA, CORROSION FOUND ON FWD L-SHAPE CARGO DOOR SURROUND STRUCTURE AT FR65 AND BTW STR 16L-17L. AT REAR FUSE, AT FR65 BTW STR 16L-17L L-SHAPE IS OUT OF LIMITS. REPLACED WITH NEW PART SECTION AT REAR FUSE AREA ON FWD L-SHAPE CARGO DOOR SURROUND STRSDR JJBA20220404016None · noneCF1 REPAIR ON RH FLOOR BEAM AT FR 23 FOUND CORRODED. CF1 REPAIR ON RH FLOOR BEAM AT FR23 BLENDED OUT OF LIMITS. REMOVED CF1 REPAIR ON RH FLOOR BEAM AT FR23 FOR REPLACEMENT. FABRICATED REPAIR DOUBLER FOR RH FLOOR BEAM AT FR23. INSTALLED NEW FABRICATED REPAIR DOSDR JJBA20220404006None · noneRT WING AILERON ON AILERON DAMPER HINGE GOUGED. REMOVED AND REPLACED RT WING AILERON DAMPER HINGE.SDR JJBA20220404004None · noneSIGNS OF CORROSION AT RH SERVICE DOOR AT STRINGER 16 FRM ST20 AND 22 LWR FWD AND AFT CORNERS. REMOVED AND REPLACED SILL AT SERVICE DOOR AT STR 16 FR 20 AND 22SDR JJBA20220402005None · noneREMOVED ELEVATOR LH TO EVALUATE DAMAGE. REMOVED LH ELEVATOR AND REPAIRED ONE ELEVATOR FITTING. RE-INSTALLED ORIGINAL ELEVATOR FITTING. ELEVATOR RE-INSTALLED.SDR JJBA20220402003Acm · odorPACK 1 EMITTED SMOKE AND BURNING SMELL. REMOVED AND REPLACED PACK #1 AIR CYCLE MACHINE. OPS CHECK GOOD. NO DEFECTS NOTED.SDR JJBA20220401002Lamp · inoperativeEMERGENCY CEILING LIGHT IN COCKPIT INOPERATIVE. REMOVED AND REPLACED EMERGENCY CEILING LIGHT IN COCKPIT. OPS CHECK SATSDR JJBA20220401001None · noneCABIN LATERAL FLOOR SUPPORT BETWEEN FRAMES 48-52 AT STRINGER 15R HAS SIGNS OF CORROSION. REMOVED AND REPLACED CABIN LATERAL FLOOR SUPPORT BETWEEN FRAMES 48-52 STRINGER 15RSDR JJBA20220331053None · nonePASSENGER DOOR FRAME HAS SIGNS OF CORROSION UNDER THRESHOLD FR15-FR18. REMOVED AND REPLACED SHAPE YSDR JJBA20220331058None · noneFLOOR EMERGENCY EXIT SIGN AT SEAT 18A DETACHED FROM FLOOR. RESECURED FLOOR EMERGENCY EXIT SIGN. NO FURTHER DEFECTS NOTED AT THIS TIMESDR JJBA20220331057Lamp · inoperativeFWD EXIT EMERGENCY LIGHT INOPERATIVE. REPLACE FWD EMERGENCY EXIT LIGHT, OPS CHECK GOODSDR JJBA20220331056Wire Harness · damagedBURNING SMELL COMING FROM CABIN FROM SEATS 11A AND 18A. INSPECTED AND FOUND 11A SIDEWALL END SOCKET DAMAGED. REMOVED 11A AND 10A SIDEWALL LIGHTS. BALLAST DEACTIVATED. REMOVED AND REPLACED HARNESS, ELECTRICAL ASSEMBLY. NO MORE BURNING SMELL, OPS CHECK SAT. BALLSDR JJBA20220330055Lamp · inoperativeLH EXTERNAL EMERGENCY LIGHTS AFT LAMP INOPERATIVE. REMOVED AND REPLACED LH EXTERNAL EMERGENCY LIGHT AFT LAMP. OPS CHECK SAT.SDR JJBA20220329051Light · inoperativeUPPER EMERGENCY LIGHT INOPERATIVE AT ROW 18A. REMOVED AND REPLACED LIGHT ASSEMBLY. OPS CHECK SATSDR JJBA20220327047Floor Support · corrodedMIDDLE LATERAL FLOOR SUPPORT BETWEEN FRAMES 16-18 IN FWD WET AREA HAS SIGNS OF CORROSION. REMOVED AND REPLACED MIDDLE LATERAL FLOOR SUPPORT BETWEEN FRAMES 16-18 FWD WET AREA.SDR JJBA20220326049Lamp · inoperativeEMERGENCY LIGHTS MAIN CABIN DOOR AND SERVICE DOOR INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHTS AT MAIN CABIN DOOR AND SERVICE DOOR. MAIN CABIN DOOR EMERGENCY LIGHT OPS CHECK SAT. OPS CHECK SATSDR JJBA20220325011None · noneCORROSION FOUND ON THE OMEGA BEAM LOCATED BETWEEN FR59 TO FR 61, Y.00-19. REPAIRED OMEGA BEAM AT FR 59 - FR61 AND Y.00-16SDR JJBA20220325010None · noneCORROSION FOUND ON THE OMEGA BEAM LOCATED BETWEEN FR59 TO FR 61. REPAIRED OMEGA BEAM AT FR 59 - FR61 AND Y.00+16SDR JJBA20220325050Lamp · inoperativeOVERWING EMERGENCY LIGHT AT SEAT 18CD INOPERATIVE. REMOVED AND REPLACED OVERWING EMERGENCY LIGHT AT SEAT 18CD. OPS CHECK SATSDR JJBA20220324054None · noneDENT LOCATED ON BAGGAGE DOOR AT 2.25 FROM UPPER EDGE AND 11.5 FROM AFT EDGE. DRESS BACK DENT LOCATED ON BAGGAGE DOOR AT 2.25 FROM UPPER EDGE AND 11.5 FROM AFT EDGE AND PERFORMED NDTSDR JJBA20220324046Floor Support · corrodedLAV/CARGO LATERAL FLOOR SUPPORT FR 59-61+4 BUT LINE 0 CORROSION. REMOVED AND REPLACED LAV/CARGO LATERAL FLOOR SUPPORT FR 59-61+4 BUT LINE 0SDR JJBA20220323052Floor Support · corrodedLAV/CARGO LATERAL FLOOR SUPPORT FR 59-61+4 STR 17L CORROSION. REMOVED AND REPLACED LAV/CARGO LATERAL FLOOR SUPPORT FR 59 - 61+4 STR 17L. NO DEFECTS NOTED AT THIS TIMESDR JJBA20220323045Not Reported · not reportedSIGNS OF CORROSION ON LH IB FLAP IB SHROUD RING SUPPORT NUT PLATE. REMOVED AND REPLACED SUPPORT AT LH IB FLAP IB SHROUDSDR JJBA20220322048Battery · overtempBATT 2 OVERTEMP EICAS MESSAGE. REPLACED #2 MAIN BATTERY AND OPS CHECKED GOOD,SDR JJBA20220321042None · noneEMERGENCY LIGHTS WILL NOT ILLUMINATE. SUSPECT BATTERIES ARE DISCHARGED.SDR JJBA20220320043Not Reported · not reportedPERFORM REPAIR AT REAR FUS II AT NAME PLATE MOUNT LOCATION. PERFORMED REPAIR AT REAR FUS II AT NAMEPLATE MOUNT LOCATION. RESTORED FINISH.SDR JJBA20220318041Not Reported · not reportedLARGE INTERIOR EMERGENCY LIGHT ROW 18A LEFT SIDE INOPERATIVE. ZONE 251 LH CABIN ESCAPE HATCH. LH EXIT MARKING SIGN ASSEMBLY CONNECTORS FOUND TO BE LOOSE. OPS CHECK SAT. NO FURTHER DEFECTS NOTED AT THIS TIMESDR JJBA20220316044Not Reported · not reportedRH AFT LAV FLOOR SUPPORT HAS SIGNS OF CORROSION FR 59-61+5 STR 17R. REMOVED AND REPLACED GUSSETSDR JJBA20220316040Lamp · inoperativeOVERWING EMERGENCY LIGHT ON 18CD IS INOPERATIVE. REMOVED AND REPLACED OVER WING EMERGENCY LAMP ON 18CD. OPS CHECK SAT.SDR JJBA20240404017Rivet · looseAT CF1 FLOOR STRUCTURE AREA, CORROSION AND TWO LOOSES RIVETS FOUND ON R/H OCTOGONAL DOUBLER AT FR 20 CF1, FLOOR STRUCTURE, OXTOGONAL DOUBLER RH OMEGA BEAM AT FR20 REMOVED/REPLACEDSDR JJBA20220315039Not Reported · not reportedEMERGENCY FLOOR LIGHT STRIP MISSING IN FRONT OF 1A. INSTALLED EMERGENCY FLOOR LIGHT STRIP IN FRONT OF SEAT 1ASDR JJBA20240404014Support · corrodedL/H SILL 3 BTW FR30-36 FOUND CORRODED. L/H SILL 3 REMOVED FOR REPLACEMENT. L/H SILL 3 REPLACEDSDR JJBA20220314038Not Reported · not reportedAFTER NDT INSPECTION, BOTH PYLON SPAR II YOKE HOLES HAVE INDICATIONS. X2 BUSHINGS FLUSH - PYLON-00 LOCALLY FABRICATED. DAMAGED HOLES ON PYLON SPAR II YOKES REPAIRED.SDR JJBA20220314037Not Reported · not reportedRH FRAME 62 HAS CRACK ON THE FLOOR SUPPORT AREA. REPLACED DAMAGE FLOOR SUPPORT AND ANGLE AT RH FRAME 62SDR JJBA20220314036Not Reported · not reportedWHILE PERFORMING THE OPERATIONAL CHECK EMERGENCY LIGHTING SYSTEM, DC BUS 1-2 OFF AND SHED BUSS 1-2 OFF CAUTION MESSAGE DOES NOT COME INTO VIEW ON THE EICAS. FOUND MULTIPLE BUTTONS PUSHED IN. PUT BACK INTO ORIGINAL CONFIGURATION AND PERFORMED THE EMERGENCY LIGHSDR JJBA20220311035Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT. OPS CHECK SAT
Back to Embraer EMB-145XR