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 JJBA20240606001Floor Support · corrodedLH OMEGA BEAM #2 FOUND CORRODED AND 2 CRACK SUSPECTED AT FR 24 AND 25. LH OMEGA BEAM #2 BLENDED WITHIN LIMITS AND RE-PROTECTED. LH OMEGA BEAM #2, CRACK AT FR 24 AND 25 REMOVED AND REPAIRED.SDR JJBA20240916001Light · crackedFOUND RH FLOOR PROXIMITY LIGHT COVER PN SG9632 TO BE CRACKED. REPLACED RH FLOOR PROXIMITY LIGHT COVER.SDR JJBA20240805006Skin · damagedFOUND HOLE THROUGH AIRCRAFT 0.15748 IN. IN DIAMETER 2.5 IN AFT OF FRAME 23, AND 1 IN BELOW STRINGER 3L. REPAIRED OPEN HOLE THROUGH FUSELAGE SKIN 2.5" OFF OF FRAME 23 AND 1" BELOW STR 3LSDR JJBA20240612033Support · crackedRF1, ABOVE FLOOR, BAGGAGE DOOR MECHANISM LOWER SUPPORT BTW FR68-69 AND ON STR 5R FOUND CRACKED. RF1, BTW FR 68-69 AT STR 5R BAGGAGE DOOR MECHANISM SUPPORT REMOVED AND REPLACEDSDR JJBA20240611017Floor Support · crackedLH OMEGA BEAM #5 FOUND CRACKED AT FR 39. LH OMEGA BEAM #5 CRACK AT FR39 REPAIREDSDR JJBA20240610016Support Plate · corrodedRF1, ABOVE FLOOR, LH SUPPORT PLATE AT FR61 FOUND CORRODED AT FLOOR LEVEL. AT RF1, ABOVE FLOOR LH SUPPORT PLATE AT FR61 BLENDED AND FOUND OUT OF LIMIT AND REMOVED FOR REPLACEMENT. AT RF1, ABOVE FLOOR, LH SUPPORT PLATE AT FR61 REPLACEDSDR JJBA20240610011Bracket · crackedRH ENG PYLON PRECOOLER, FWD STRUCTURE BRACKET IS CRACKED. RH ENG PYLON PRECOOLER, FWD STRUCTURE BRACKET REMOVED FOR REPLACEMENT. RH ENG PYLON PRECOOLER FWD STRUCTURE BRACKET REPLACEDSDR JJBA20240603064Support Plate · corrodedRF1, ABOVE FLOOR, RH SUPPORT PLATE AT FR61 FOUND CORRODED AT FLOOR LEVEL. AT RF1, ABOVE FLOOR AT RH FR61, SUPPORT PLATE BLENDED AND FOUND OUT OF LIMIT AND REMOVED FOR REPLACEMENT. AT RF1, ABOVE FLOOR AT RH FR61, SUPPORT PLATE REPLACED.SDR JJBA20240607009Support · corrodedRF1, UNDERFLOOR, RH SILL BTW FR 61-65 FOUND CORRODED. RH SILL BTW FR 61-65 BLENDED AND FOUND OUT OF LIMIT. RH SILL BTW FR 61-65 REMOVED AND INSTALLED.SDR JJBA20240603065Support · corrodedRH SILL BTW FR 59-61 FOUND CORRODED. RH SILL BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. RH SILL BTW FR 59-61 REMOVED AND REPLACED.SDR JJBA20240603063Support · corrodedLH SILL BTW FR 59-61 FOUND CORRODED. LH SILL BTW FR 59-61 BLENDED OUT OF LIMITS AND REMOVED FOR REPLACEMENT. LH SILL BTW FR 59-61 REPLACEDSDR JJBA20240611027Yoke · crackedRH PYLON SPAR II YOKE AFT RIVET HOLE CRACKED. CRACKED HOLE ON RH PYLON SPAR II YOKE AFT RIVET HOLE REPAIREDSDR JJBA20240603060Dau · inoperativeFUEL TRANSFER INOPERATIVE IN FLIGHT. REMOVED AND REPLACED DAU #1. OPS CHECK SAT. PERFORMED A FUEL TRANSFER OPS CHECK. OPS CHECK SAT. NO REPEAT FAULT CODES FOUND. REMOVED AND REPLACED VENTRAL PUMP A. OPS/LEAK CHECK SAT.SDR JJBA20240528059Duct · unsecureSMELL OF SMOKE (BURNING RUBBER) ON CLIMB OUT WITH EXCESSIVE AMOUNTS OF CONDENSATION FROM #1 PACK. FOUND BOTH NACA RAM AIR INLET DUCTS (191GL), NOT SECURED; RH PACK DUCT FROM NACA AIR INLET WAS TORN; REMOVED AND REPLACED DUCT. LH PACK DUCT FROM NACA AIR INLET WSDR JJBA20240528062Shear Tie · crackedCF4, LH SHEAR CLIP ON FR58 BTW STR 15L-16L FOUND CRACKED. CF4 LH SHEAR CLIP ON FR58 BTW STR 15L-16L REPLACED.SDR JJBA20240611024Shroud · crackedRH OUTBD FLAP SHROUD OUTBD HINGE FOUND CRACKED. RH OUTBD FLAP SHROUD OUTBD HINGE REPLACEDSDR JJBA20240611022Attach Angle · crackedLH OMEGA BEAM WING BOX ATTACH ANGLE, OUTBD FOUND CRACKED AT FR47 AND INBD FOUND CORRODED AT FR49. LH OMEGA BEAM WING BOX ATTACH ANGLE, OUTBD BTW FR 47 TO 50 REMOVED AND REPLACEDSDR JJBA20240611021Attach Angle · crackedRH OMEGA BEAM WING BOX ATTACH ANGLE, INBD AND OUTBD ANGLES AT FR 47 FOUND CRACKED. INBD AND OUTBD ANGLES BTW FR 47 TO FR50 ON RH OMEGA BEAM REMOVED AND REPLACEDSDR JJBA20240611019Angle · crackedCENTER FUSELAGE 3, LH UPPER SURFACE OF WING TO FUSELAGE FAIRING STRUCTURE, ANGLE 1, 2, 3 FROM FWD FOUND CRACKED. ANGLE 2 FROM FWD END REMOVED AND REPLACEDSDR JJBA20240611018Angle · crackedCENTER FUSELAGE 3, RH UPPER SURFACE OF WING TO FUSELAGE FAIRING STRUCTURE, ANGLE 2, 4, 7 FROM FWD FOUND CRACKED. ANGLE 4 FROM FWD END REMOVED AND REPLACEDSDR JJBA20240607006Threshold · corrodedON CF1, RH FUSE THRESHOLD SERVICE DOOR BTW FR20-22 CORRODED. ON CF1, BTW FR20-22 RH FUSE THRESHOLD SERVICE DOOR CORROSION BLENDED OUT OF LIMITS. ON CF1, RH FUSE THRESHOLD SERVICE DOOR BTW FR20-22 REMOVED AND REPLACEDSDR JJBA20240603072Bracket · crackedRH SIDE AT FR 46 CLOSING ANGLE BRACKET FOUND CRACKED JUST UNDER FLOOR LEVEL. RH SIDE AT FRAME 46 CLOSING ANGLE BRACKET REPLACEDSDR JJBA20240523057Inverter · inoperativeEMERGENCY EXIT ROW OVERHEAD FWD EMERGENCY EXIT LIGHT FOUND INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT INVERTER #5. OPS CHECK SATSDR JJBA20240523056Inverter · inoperativeRH EMERGENCY EXIT HATCH UPPER LIGHT INOPERATIVE. REMOVED AND REPLACED RH EMERGENCY EXIT HATCH UPPER LIGHT. OPS CHECK FAILED. REMOVED AND REPLACED EMERGENCY LIGHT INVERTER NUMBER 6. OPS CHECK SATSDR JJBA20240611026Rib · crackedLEFT EXTENDED RIB FOUND CRACKED FROM BOTTOM HOLES ON CENTER FUSELAGE UNDER SPAR III. ON LH EXTENDED RIB FROM BOTTOM HOLES ON CENTER FUSELAGE UNDER SPAR III REMOVED AND REPLACEDSDR JJBA20240603067Rib · crackedEXTENDED RIB FOUND CRACKED FROM BOTTOM HOLES ON CENTER FUSELAGE UNDER SPAR III. REMOVED AND REPLACED EXTENDED RIB ON RH CENTER FUSE UNDER SPAR IIISDR JJBA20240522051Skin · crackedRH EXTERNAL FUSELAGE, BTW FRAME 77-80 AND BTW STR 3R-9R, CRACKS (6X) FOUND AROUND FASTENERS. 4 BUSHINGS REPAIRS AND A REPAIR DOUBLER ON RH REAR FUSELAGE II SKIN, BTW FR 77 & 79 AND BTW STR 3R-7RSDR JJBA20240522050Floor Support · crackedCF2, UNDERFLOOR, LH OMEGA BEAM NO 2, 2 CRACKS SUSPECTED AT FR24,25. 2 REPAIR DOUBLERS ON LH CENTER FUSELAGE 1 OMEGA BEAM, ON INBD VERTICAL FLANGE AT FR24 & 25SDR JJBA20240522048Floor Support · crackedCF1, UNDERFLOOR, LH OMEGA BEAM NO 1 INBD SIDE, CRACK SUSPECTED AT FR21, 22, AND 23. CF1, LH OMEGA BEAM NO 1 INBD SIDE, CUTOUT PERFORED AT FR 21, 22, 23. LH OMEGA NO 2 INBD SIDE, FR21, 22, 23 REPAIREDSDR JJBA20240603066Bracket · corrodedL-SHAPE BRACKET FOUND HEAVY CORROSION ON RH WING UNDER INBD FLAP SHROUD. RH WING UNDER INBD FLAP SHROUD L-SHAPE BRACKET BLENDED OUT OF LIMITS. RH WING INBD FLAP L-SHAPE BRACKET REMOVED AND REPLACEDSDR JJBA20240523058Floor Support · corrodedCENTER FUSELAGE 1 - RH OMEGA BEAM UPPER SURFACE - BETWEEN FR18 - FR19 - CORROSION. PROCEEDED TO FABRICATE DOUBLE AND INSTALLED DOUBLER.SDR JJBA20240520027Lamp · inoperativeFWD EMERGENCY CEILING LIGHT INOPERATIVE. REMOVED AND REPLACED CEILING LIGHT BULB. OPS CHECK SAT.SDR JJBA20240610012Floor Support · crackedLH OMEGA BEAM AT FR21 VERTICAL FLANGE INBD CRACKED ON RIVET. LH OMEGA BEAM AT FR21 CRACK REPAIREDSDR JJBA20240516024Door · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN LUBED AND OPS CHECKED PAX DOOR; OPERATION GOODSDR JJBA20240610013Floor Support · corrodedRF1, UNDERFLOOR, RH OMEGA BEAM FOUND CORRODED BTW FR 59-60 AND 60-62 AROUND ANCHOR NUT. RH OMEGA BEAM BTW FR 60-62 BLENDED, FOUND WITHIN LIMITS. REPAIR DOUBLER PERFORMED ON CTR FUSELAGE IV, RH OMEGA BEAM UPPER SURFACE BTW FR 59-60SDR JJBA20240522052Shear Tie · crackedRF1, ABOVE FLOOR, RH SHEAR CLIP AT FR 73 AND BTW STR 8R-10R FOUND CRACKED. SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240520034Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR15 BTW STR 15R-16R. SHEAR CLIP AT FR15, BTW STR 15R-16R REMOVED AND REPLACED WITH NEW PART.SDR JJBA20240520033Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR16 BTW STR 15R-16R. SHEAR CLIP AT FR16 BTW STR 15R-16R REMOVED AND REPLACED WITH NEW PARTSDR JJBA20240611025Tee Angle · bentCARGO DOOR ENTRANCE, LOWER STRUCTURE, T-PROFILE AT FRAME 67 FOUND BENDED. CARGO DOOR ENTRANCE, LOWER STRUCTURE, T-PROFILE AT FR67 REMOVED AND REPLACEDSDR JJBA20240611020Support · corrodedRH SILL #1 FOUND CORRODED. BLENDED OUT OF LIMITS. REMOVED AND REPLACEDSDR JJBA20240528061Support · corrodedRH SILL #2 FOUND CORRODED. ON RH SILL #2, CORROSION BLENDED AND FOUND OUT OF LIMIT. RH SIDE BTW FR 25-35, RH SILL #2 REMOVED FOR REPLACEMENT AND INSTALLEDSDR JJBA20240520042Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT RH FR 24 BTW STR 15R-16R. AT RH FR 24 BTW STR 15R-16R SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240520037Crossbeam · crackedNLG W/WELL CRACK FOUND ON NLG UP-LOCK AFT CROSSBEAM. NLG WHEEL WELL AFT CROSS BEAM REMOVED AND REPLACEDSDR JJBA20240520036Crossbeam · crackedNLG W/WELL CRACK FOUND ON NLG UP-LOCK FWD CROSSBEAM. NLG WHEEL WELL FWD CROSS BEAM REMOVED AND REPLACED.SDR JJBA20240520035Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT RH FR 25 BTW STR 15R-16R. AT RH FR 25 BTW STR 15R-16R SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240611023Beam · corrodedRF1, CARGO ENTRANCE LOWER BEAM BTW FR65-68 FOUND CORRODED. RF1, CARGO ENTRANCE LOWER BEAM BTW FR 65-68 CORROSION OUT OF LIMIT AND BEAM REMOVED AND REPLACEDSDR JJBA20240522054Support · corrodedCORROSION FOUND ON LH SILL #4. BLENDED OUT OF LIMIT. REMOVED AND REPLACED LH SILL #4.SDR JJBA20240522053Floor Support · corrodedCORROSION FOUND ON RH SILL #3. ON FLOOR SILL #3, BLENDED CORROSION AND FOUND OUT OF LIMIT. FLOOR SILL #3 REMOVED AND REPLACEDSDR JJBA20240520041Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR25 BTW RH STR 16R-17R. AT FR25 BTW RH STR 16R-17R SHEAR CLIP REMOVED AND REPLACEDSDR JJBA20240520038Shear Tie · crackedSHEAR CLIP FOUND CRACKED AT FR 24 BTW RH STR 16R-17R. AT FR24 BTW RH STR 16R-17R SHEAR CLIP REMOVED AND REPLACED
Back to Embraer EMB-145XR