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 JJBA20221215010Bracket · crackedRH WING ROOT SKIN ANGLE FOR LATERAL FAIRING IS CRACKED IN TWO LOCTIONS BETWEEN SPAR 1 AND SPAR 2. ANGLE BRACKET OF RH WING LATERAL FAIRING BETWEEN SPAR 1 AND SPAR 2 WAS REMOVED AND REPLACEDSDR JJBA20221215009Angle · crackedLH WING ROOT SKIN ANGLE FOR LATERAL FAIRING IS CRACKED IN ONE LOCATION BETWEEN SPAR 1 AND SPAR 2. REMOVED AND REPLACE ANGLE FOR LATERAL FAIRINGSDR JJBA20221107005None · noneDAMAGE FOUND ON LH SIDE SKIN BTW FR 61-64 AND BTW STR 17L-18L. REPAIR DOUBLER ON LH REAR FUSE 1 SKIN, BTW FR 61-63 AND BTW STR 16L-18LSDR JJBA20221102025None · inoperativeSUPPLEMENTAL (NEW) INFORMATION: REMOVED AND REPLACED FUEL DOOR MICRO SWITCH. OPS CHECK SAT. FUEL DOOR SHOWS CLOSED.SDR JJBA20221031022Sign · inoperativeCENTER CEILING EMERGENCY EXIT SIGN BETWEEN SEATS 18A AND 18C IS INOPERATIVE ON FWD SIDE. REMOVED CEILING LIGHT LENS COVER AT SEATS 18A. REMOVED AND REPLACED LIGHT ASSEMBLY. OPS CHECK SAT. REINSTALLED LIGHT LENS COVER. OPS CHECK SAT.SDR JJBA20221107008None · none3 CRACKS SUSPECTED ON LH OMEGA BEAM #1 AT FR 21, 22, 23. BEAM REPAIRED WITH 3 DOUBLERS. 3 REPAIR DOUBLERS ON LH CENTER FUSE 1 OMEGA BEAM, ON INBD FLANGE AT FR 21, 22 AND 23SDR JJBA20221107006None · noneCF2 LH OMEGA BEAM #2, 2 SUSPECTED CRACKS AT FR 26, 28. CRACKS ON LH OMEGA BEAM #2 REPAIRED. 2 REPAIR DOUBLERS ON LH CENTER FUSE 2 OMEGA BEAM O INBD FLANGE AT FR 26 & 28SDR JJBA20221107001None · noneCF3 CORROSION FOUND ON LH SILL #4. AFTER INVESTIGATION, FITTING DAMAGED UNDERNEATH SILL. FITTING REPAIRED WITH 2 BUSHINGSSDR JJBA20221128026Angle · crackedRH MLG WHEEL WELL, AFT WEB, UPPER ANGLE CRACKED. DAMAGED AREA REMOVED BY CUT OUT ON R/H MLG WHEEL WELL AFT WEB UPPER ANGLE AT STA X 16783.5. R/H MLG WHEEL WELL AFT WEB UPPER ANGLE REPAIRED WITH ANGLE DOUBLE AND INSTALLED WITH SOLID RIVET AND HI-LOCK.SDR JJBA20221107007None · noneCF3 LH OMEGA BEAM FOUND CORRODED AND 2 CRACKS SUSPECTED AT FR51 AND FR 52. AFTER NDT INSPECTION (2X) CRACKS CONFIRMED ON LH OMEGA BEAM #2. CUT OUT AT 2X CRACK LOCATION AT FR 51 AND FR 52 PERFORMED. CF3 LH OMEGA BEAM CRACKS REPAIRED.SDR JJBA20221107004None · noneCENTER FUSE 4, FRAME 59 CRACKED BTW STR 15L-16L. CENTER FUSE 4, ON FRAME 59 BTW STR 15L-16L, RIVETS REMOVED FOR INVESTIGATION. FR 59 BTW 14L-15L SPLICE REMOVED. MADE REPAIR PART LOCALLY FABRICATED. CENTER FUSE 4, FRAME 59 BTW 15L-16L, CRACK REPAIREDSDR JJBA20221107003None · noneCORROSION FOUND ON RAD ALT #2 ANTENNA BASE DOUBLER BTW FR68-69 AND BTW STR 21L-21R IN RF1 AREA. AT RAD ALT #2, AFTER INVESTIGATION INNER AND EXTERNAL DOUBLER CORROSION FOUND OUT OF LIMIT AND SKIN CRACKED AROUND FASTENERS. DOUBLER AND FILLER FOR #2 ANTENNA FABRSDR JJBA20221026017Engine · failed#2 ENGINE FAILURE AT CRUISE. REMOVED AND REPLACED RH ENGINE. OPS AND LEAK CHECK GOOD.SDR JJBA20221107002None · noneCRACK SUSPECTED (6X) ON RH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3L-9L. SKIN REPAIRED WITH 8 BUSHINGS REPAIRSDR JJBA20221024016Lamp · inoperativeFWD AISLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FWD AISLE EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR JJBA20221021013Lamp · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT BULB. OPS CHECK SATSDR JJBA20221031024Frame · corrodedCENTER FUSE 4, FRAME 59 CORRODED BTW STR 20L-20R. CENTER FUSE 4, ON FRAME BTW STR 20L-20R CORROSION BLENDED AND FOUND T BE OUT OF LIMIT. MADE REPAIR PART, LOCALLY FABRICATED. CENTER FUSE 4, FRAME 59 BTW STR 20L-20R AREA REPAIRED.SDR JJBA20221026018Skin · corrodedREAR FUSE I, RH SILL BTW FRAME 61-65 CORRODED. RH SILL BTW FR61-65 CORROSION BLENDED AND FOUND OUT OF LIMIT. RH SILL BTW FR 61-65 REPLACED. IN ADDITION MIS DRILLED HOLE AT FR 63 REPAIRED.SDR JJBA20221021015Floor Support · corrodedCF1 CORROSION FOUND ON RH OUTBD OMEGA BEAM REPAIR BTW FR18-19 AND AT FR 23. CF1 ON RH OMEGA BEAM BTW FR 18-19 SURFACE CORROSION BLENDED WITHIN LIMIT AND REPROTECTED. CF1 ON RH OMEGA BEAM AT FR23 OLD REPAIR REMOVED FOR INVESTIGATION AND FOUND CORRODED OUT OF LISDR JJBA20221021014Mount Bracket · not reportedPERMANENT REPAIR TO PERFORM PER ETD 2020-145-003599 FOR FWD FUSELAGE LH UPPER LATERAL MOUNTING BRACKET. STRUCTURE REPAIRED WITH COLDWORKING OF 11 HOLESSDR JJBA20221021012Switch · pilot errorWING 1 FUEL QTY INDICATED 0 IN FLIGHT. FOUND REFUEL SWITCH IN OPEN POSITION. MOVED TO CLOSED POSITION. ALL MESSAGES CLEARED AND FUEL TY RETURNED TO NORMAL. VERIFIED QTY INDICATION CORRECT BY STICK MEASUREMENT. OPS CHECK GOODSDR JJBA20221026021Skin · crackedCRACK SUSPECTED (5X) ON LH SKIN AROUND FASTENERS BTW FR77-80 BTW STR 3L-9L. SKIN REPAIRED WITH 5 BUSHINGS REPAIR.SDR JJBA20221026019Gusset · corrodedCENTER FUSE 4, RH GUESSET BTW FRAME 59-61 CORRODED. OMEGA BEAM IS CORRODED. BEAM REPAIRED WITH A DOUBLERSDR JJBA20221017005Lamp · inoperativeAFT CABIN CEILING PANEL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED AFT CABIN CEILING PANEL EMERGENCY LIGHT. OPS CHECK GOODSDR JJBA20221125024Frame · crackedCF 4, FRAME 59 CRACKED BTWEN STR 15L-16L FRAME IS REPAIRED WITH AN EXTENDED SPLICE ON L/H CENTER FUSE 4 FRAME 59, BTW STR 15L-16L.SDR JJBA20221017006Skin · gougedGOUGE ON BAGGAGE DOOR FORWARD OF VENT HANDLE AS MARKED. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER AND FILLER ON BAGGAGE DOOR FWD LOWER EDGE SKIN.SDR JJBA20221013004Lamp · inoperativeLH OVER WING AFT EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR JJBA20221125025Frame · crackedRF 1 FRAME 72, SHARE CLIP BTWN STR 7L-10L CRACKED SHARE CAP FR 72 BTR STR 7L-10L FORMED FOR REPLACEMENT. NEW SHEAR CLIP FABRICATED. SHEAR CLIP FR 72 BTW STR 7L-10L SEPARATED . NEW SHEAR CLIP INSTALLED.SDR JJBA20221010003Light · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT. OPS CHECK FAIL. REPAIRED LIGHT HARNESS. OPS CHECK SATSDR JJBA20221017011Skin · dentedBIRD STRIKE BELOW FO'S WINDSHIELD. PERFORMED BIRD STRIKE INSPECTION. FOUND EVIDENCE OF DAMAGE. PERFORMED DVI OF THE SURROUNDING STRUCTURE OF THE DAMAGE. DENT IS FREE OF CRACKS AND NO FURTHER DAMAGE NOTED. REMOVED PAINT AND STARTED REMOVAL OF FASTENERS ON SKIN SDR JJBA20221007002Dau · inoperativeRUDDER SYSTEM 1/2 INOPERATIVE DURING DECENT IN DOWN WIND. REMOVED AND REPLACED RUDDER PRESSURE SWITCH 1 AND 2. REMOVED AND REPLACED DAU 2. OPS CHECK SAT.SDR JJBA20221007001Carbon Seal · leakingSUPPLEMENTAL (NEW) INFORMATION: REMOVED AND REPLACED #1 PACK HEAT EXCHANGER. OPS AND LEAK CHECK GOOD. REMOVED AND REPLACED HEPA FILTERS 1 AND 2. INSTALLED FLOOR PANELS 251FF AND 251HF. REMOVED AND REPLACED NO.0 CARBON SEAL ASSEMBLY. INSTALLED FAN SPANNER - LOCSDR JJBA20220930045Roller · lack of lubeGROUND CREW NOTICED MCD HANDLE STICKING OUT WHEN DOOR CLOSED AND MFD INDICATIONS OPEN. CLEANED AND LUBRICATED MAIN DOOR ROLLERS. OPEN AND CLOSED DOOR, OPS CHECK SAT. NO INDICATION. NO STICKING HANDLESDR JJBA20220926041Shaft · looseMCD WONT OPEN FROM INSIDE. INSPECTED AND FOUND MCD INTERNAL HANDLE LOOSE IN SHAFT, TIGHTENED HANDLE BOLT. OPS CHECK GOOD, NO ADJUSTMENTS MADE.SDR JJBA20220926040Light · misinstalledRH AFT OVER WING EMERGENCY LIGHT IS INSTALLED UPSIDE DOWN. RE-INSTALLED RH EXTERNAL EMERGENCY LIGHT REFLECTOR.SDR JJBA20220923032Inverter · inoperativeAFT OVERWING EMERGENCY EXIT PLACARD INOPERATIVE. REMOVED AND REPLACED INVERTER #4. OPS CHECK SATSDR JJBA20220923031Battery Pack · inoperativeFWD & MIDDLE AISLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AT BPS1. LIGHTS ONLY MOMENTARILY CAME ON. REMOVED AND REPLACED NEWLY INSTALLED POWER SUPPLY AT BPS1. OPS CHECK GOODSDR JJBA20220923030Battery Pack · inoperativeMCD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED POWER SUPPLY AT BPS1. LIGHTS ONLY MOMENTARILY CAME ON. REMOVED AND REPLACED NEWLY INSTALLED POWER SUPPLY AT BPS1. OPS CHECK GOODSDR JJBA20220923035Frame · crackedCRACK FOUND ON LH FRAME 59 BTW STR 15L-16L IN CF4 FLOOR STRUCTURE AREA. EXTENDED SPLICE REPAIRED ON CENTER FUSE 4 FR BTW STR 15L-16LSDR JJBA20220923033None · noneSTRONG HYDRAULIC SMELL IN COCKPIT/CABIN. RAN ENGINES FOR 30 MINUTES. NO SMELL NOTED. OPERATED PACKS. OPS CHECK GOOD.SDR JJBA20220923039Floor Support · crackedCF2, UNDERFLOOR, LH OMEGA BEAM CRACK SUSPECTED AT FRAME 30 ANND 31. AFTER NDT INSPECTION, 2 CRACKS CONFIRMED ON LH OMEGA BEAM #3 AT FR30 AND FR31. FABRICATED REPAIR PARTS (2). AT CF2, UNDERFLOOR LH OMEGA BEAM AT FR30 AND 31, INSTALLED REPAIR PARTSSDR JJBA20220923037Floor Support · crackedLH OMEGA BEAM CRACK SUSPECTED AT FR 21, 22, AND 23. AFTER NDT INSPECTION, ONLY 2 CRACKS FOUND AT FR21 AND FR23 LH OMEGA BEAM CRACK AT FR21 AND FR 23 REPAIREDSDR JJBA20220923036Floor Support · crackedCF2 UNDERFLOOR LH OMEGA BEAM CRACK SUSPECTED AT FRAME 24-25-26-27-28-29. AFTER NDT INSPECTION, 6 CRACKS CONFIRMED ON LH OMEGA BEAM #2 AT FR 24-25-26-27-28-29, CF2 UNDERFLOOR LH OMEGA BEAM CRACK AT FR 24-25-26-27-28-29 REPAIREDSDR JJBA20220930044Shear Tie · crackedCRACK FOUND ON LH SHEAR CLIP FR 58 BTW STR 15L-16L. CRACK FOUND ON LH SHEAR CLIP AT FR 58 BTW STR 15L-16L. SHEAR CLIP REPLACED AT FR 58 BTW STR 15L-16LSDR JJBA20220930043Shear Tie · crackedCRACK FOUND ON LH SHEAR CLIP AT FR 66 BTW STR 6L-7L IN RF1 AREA. CRACK FOUND ON LH SHEAR CLIP AT FR 66 BTW STR 6L-7L IN RF1 AREA. SHEAR CLIP FABRICATED WITH AN ALTERNATE MATERIAL. LH SIDE AT FR 66 BTW STR 6L-7L FABRICATED SHEAR CLIP INSTALLED.SDR JJBA20220930042Shear Tie · crackedSUSPECTED CRACK FOUND ON LH SHEAR CLIP AT FR 72 BTW STR 7L-10L IN RF1 AREA. SUSPECTED CRACK FOUND ON LH SHEAR CLIP AT FR 72 BTW STR 7L-10L IN RF1 AREASDR JJBA20220923038Floor Support · crackedCF3 LH OMEGA BEAM BTW FR 45-53 FOUND CORRODED AND CRACK SUSPECTED AT FR51. AFTER NDT INSPECTION, 1 CRACK CONFIRMED ON LH BEAM AT FR51. CORROSION ON LH OMEGA BEAM BTW FR 48-49 BLENDED OUT OF LIMITS. CF3 LH OMEA BEAM BTW FR 48-49 REPAIRED AND INSTALLED. CF3 LH SDR JJBA20220921029Inverter · inoperativeGALLEY AND ROW 3CD EMERGENCY LIGHTS NOT ILLUMINATING. REMOVED AND REPLACED #3 INVERTER. OPS CHECK SAT.SDR JJBA20220921026None · failedSUPPLEMENTAL (NEW) INFORMATION: REMOVED AND REPLACED NOSE LANDING GEAR. OPS AND LEAK CHECK SAT.SDR JJBA20220919025None · trippedSMOKE IN COCKPIT BURNING SMELL. INSPECTED THE COCKPIT AND FOUND EICAS DISPLAY CB WAS EXTENDED. REMOVED AND REPLACED EICAS DISPLAY UNIT. RESETED DISPLAY CB. OPS CHECK SAT
Back to Embraer EMB-145XR