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 JJBA20210827058Shear Tie · damagedBAGGAGE DOOR CUTOUT FWD FRAME BOTTOM SECTION HAS CORROSION. CUTOUT DAMAGE SHEAR CLIP SECTION AT BAGGAGE DOOR LOWER FRAME 65, LOCATE AND DRILL NEW SHEAR CLIP. APPLIED ALODINE, PRIMER AND TOP COAT. INSTALLED NEW SHEAR CLIP SECTION.SDR JJBA2021082517055Doubler · corrodedCORROSION ON LOWER REAR FUSE 1, ON ANTENNA DOUBLER FOR FWD RADIO ALTIMETER #2 BTW FR 65-56. SKIN REPAIRED.SDR JJBA2021082017046Frame · crackedFR 59 BTW STR 16-17 FOUND CRACKED. CRACKED SECTION OF FRAME 59, BTW STR 16-17. REMOVED FOR REPAIR. REPAIR PARTS FOR CRACKED FR 59, BTW STR 16-17 LOCALLY FABRICATED. FR 59, BTW STR 16-17 REPAIRED (SPLICED BTW STR 17-18).SDR JJBA20210817043Floor Support · corrodedON CF3:CENTER OMEGA BEAM BTW FR46-53 LOWER FLANGE CORRODED. CF3, CENTER BEAM BLENDED OUT OF LIMITS BTW FR 47 & 48. PERFORMED CUT OUT BTW FR 47 & 48. CF3 CENTER BEAM REPAIRED WITH REPAIR DOUBLER ANGLESDR JJBA20210817039Bracket · damagedBRACKET BEHIND WINDSHIELD CENTER POST AT THE INNER UPPER WEB STRUCTURE HAS SCRATCH MARKS AND CRANKED AT NUT-PLATE HOLE (MARKED)
INSTALLED EWIS PROTECTION AREA IAW EMB145 SWPM 20-21-00, CUT OUT DAMAGE, FABRICATED 2EA DOUBLER FROM 2024T3 .080", APPLIED ALODINE,SDR JJBA20210817038Light · missingPHOTO LUMINESCENT STRIP MISSING SEAT 5A. FOUND AND REPOSITIONED PHOTO ILLUM LIGHT STRIP AS NEEDED REF EMB 145XRMM 33-50-00 .SDR JJBA20210815037Muffler · failedCOULD NOT COOL DOWN CABIN IN FLIGHT. ECS SHOWS 18C BUT FA COMPLAINS IT WAS TOO HOT. R/R #1 RECIRC FAN MUFFLER IAW EMB 145XR MM 21-24-02, OPS CK GOOD IAW EMB 145XR MM 21-51-00SDR JJBA202109012062Support · corrodedSIGNS OF CORROSION NOTED ON THE INTERNAL PORTION OF THE TOILET WASTE VALVE SUPPORT. REMOVED AND REPLACED INTERNAL PORTION OF THE TOILET WASTE VALVE SUPPORT (CUP)SDR JJBA20210811059Floor Support · corrodedCROSS FLOOR U-CHANNEL BETWEEN FRAMES 57 AND 58 AND CENTER FLOOR BEAM AND FLOOR BEAM 18 RIGHT HAS CORROSION IN SEVERAL AREAS. BLENDED AREAS ON CROSS FLOOR U-CHANNEL BETWEEN FR 57-58 ND CENTER FLOOR BEAM AND FLOOR BEAM 18" RIGHT.SDR JJBA20210811036Floor Support · corrodedPOSSIBLE CORROSION FR 22 STR 13R FLOOR SUPPORT. REMOVED CORROSION ON FLOOR SUPPORT AT FRAME 22. UTT OF BLENDED ON FRAME 22 STR 13R FLOOR SUPPORT THICKNESS IS .032". EVALUATED FLOOR SUPPORT ORIGINAL THICKNESS 0.050" OUT OF LIMITS. INST. EWIS. REMOVED FLOOR SUPSDR JJBA2021082011035Skin · corrodedR/H WING LOWER SURFACE LOWER SKIN ACCESS HOLES HAVE SIGNS OF CORROSION ON ALL HOLES LANDS. BLENDED AND REMOVED CORROSION AT R/H WING LWR SURFACE, LWR SKIN ACCESS HOLES AND LANDS, FOUND TO BE WITHIN LIMITS. NDT PERFORMED. NO DISCREPANCIES NOTED AT THIS TIME.SDR JJBA202108131031Door Frame · corrodedBAGGAGE DOOR AFT FRAME LOWER STRUCTURE HAS SURFACE CORROSION AROUND FASTENERS HOLES. REMOVED AND REPLACED LOWER PROFILE L ON BAGGAGE DOORSDR JJBA202108131030Light · missingEMERGENCY FLOOR STRIP AT 1A MISSING. INSTALLED EMERGENCY FLOOR STRIP.SDR JJBA20210811029Battery Pack · inoperativeFOUND EMERGENCY LIGHTS AT EMERGENCY EXIT ROWS INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY #3. OPS CHECK SAT. NO FURTHER DEFECTS NOTED.SDR JJBA20210810044Yoke · crackedFOLLOWING NDT INSPECTION ON TASK 54-50-00-255-803-A00, 2X CRACKS FOUND ON PYLON YOKES UPPER FLANGE 2X HOLES LOCATIONS. OPEN L/H AND R/H PYLON YOKES UPPER FLANGE 1ST OVER SIZE. AFTER NDT INSPECTION (STILL CRACKED) OPEN HOLES 2ND OVER SIZE NO CRACK INDICATION FSDR JJBA20210810041Skin · dentedDENT WITH RIVET PLUGS ON R/H LOWER FWD FUSE 2, BTW FR 11-12 AND BTW STR 20R-21R. PERFORMED CUT-OUT ON R/H LOWER FWD FUSE 2, BTW FR 11-12 AND BTW STR 20R-21R. PREDRILLED DOUBLER RIVETS LAYOUT IN SKIN ON R/H LOWER FWD FUSE 2, BTW FR 11-12 AND BTW STR 20R-21R. FSDR JJBA20210809047Floor Support · corrodedCF1, R/H, BEAM HAT SECTION, BTW FRAMES 18-20, FOUND CORRODED. ON CF1, R/H, BEAM HAT SECTION, BTW FR18-20 BLENDED AND FOUND OUT OF LIMIT. ON CF1, R/H, BEAM HAT SECTION, BTW FR18-20 REPAIREDSDR JJBA20210809045Shear Tie · crackedRF1, AT FR 71 BTW STR 6L-10L, SHEAR CLIP CRACKED. SHEAR CLIP FR 71 BTW STR 6L-10L WAS REMOVED. RF 1, AT FR 71 BTW STR 6L-10L, NEW SHEAR CLIP LOCALLY FABRICATED. REPLACED SHEAR CLIP AT FR 71 BTW STR 6L-10L WITH NEW LOCALLY FABRICATED SHEAR CLIPSDR JJBA20210809040Frame · corrodedRF1, AT FR 65, FRAME UPPER Z SECTION CORRODED AT ANCHOR NUT LOCATIONS RF1, FR65 ON FRAME UPPER Z AT ANCHOR NUT LOCATION, FRAME BLENDED OUT OF LIMIT. RF1, FR65 REPAIREDSDR JJBA2021081308034Support Bracket · crackedTOILET VALVE WASTE SUPPORT BRACKET IS CRACKED. EVALUATED DAMAGE SUPPORT BRACKET AND FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED NEW BRACKETS. TREATED, PRIMED NEW HOLES. INSTALLED NEW BRACKETSDR JJBA20210808026Relay · failedSMOKE IN THE GALLEY AND BEHIND THE F/O SEAT ON SHORT FINAL. FOUND RELAYS K0055, AND K0054 AND THEIR SOCKETS TO BE DAMAGED. ALSO, NOTED DAMAGE TO WIRES GOING TO BOTH SOCKETS. R&R RELAYS K0055 AND K0054 AND THEIR CORRESPONDING SOCKETS. REPAIRED CORRESPONDING WIRSDR JJBA20210806032Cable · looseAILERON CONTROLS LOOSE IN FLIGHT. REMOVED AND REPLACED LT UPPER AILERON CABLE (WING SECTION).SDR JJBA2021090885005Attach Fitting · corrodedLEFT WING AILERON ATTACHMENT LUGS "4" EACH HAVE LIGHT SURFACE CORROSION EXPOSED AND BARE METAL. BLENDED CORROSION 4 EACH LUGS.SDR JJBA202109015060Seat Track · corrodedLH OUTBOARD SEAT TRACK SUPPORT AT FR29-35 HAS CORROSION AT 16EA AREAS. REMOVED AND REPLACED LH OUTBOARD SEAT TRACK SUPPORT AT FR 29-35SDR JJBA2021081305033Floorbeam · corrodedMAIN CABIN, FWD FUSELAGE FLOORBEAM AT FR 20 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM AT FR 20SDR JJBA20210805025Dau · inoperativeDAU #2 WRN MIS CMP. R&R #2 DAU, PERFORMED DAU #2 OPS CHECK. OPS CHECK GOOD.SDR JJBA20210803024Light · unsecureEMERGENCY PATH LIGHTING STRIP NEAR 1A IS DISLODGED. SECURED IN PLACED EMERGENCY PATH LIGHTING STRIP NEAR 1A WITH TAPE.SDR JJBA202108042002Light · unsecureFLOOR PATH LIGHTING LOOSE AROUND GALLEY. RE-SECURED TO FLOOR WITH DOUDLE SIDE CARPET TAPE AS REQUIRED.SDR JJBA20210801001Bulb · inoperativeLH OVER WING EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED LH OVER WING EMERGENCY EXIT LIGHT BULB. OPS CHECK SATSDR JJBA20210730017Doubler · corrodedCORROSION ON LOWER REAR FUSE 1, ON ANTENNA DOUBLER FOR AFT RADIO ALTIMETER #2 BTW FR 68-69. BTW FR 68-69, CORROSION FOUND ON LOWER REAR FUSELAGE 1. SUPPORT ANTENNA AND PLATE ASSEMBLY FOUND OUT OF LIMITS AND NEED TO BE REPLACED. SKIN BLENDED FOUND OUT OF LIMITSSDR JJBA202108030030Lamp · dimMCD EXTERNAL EMERGENCY LIGHT DIM. R&R MCD EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA202108030029Lamp · burned outEMERGENCY LIGHT BELOW SERVICE DOOR INOP R+R LIGHT BULB FOR THE EMERGENCY LIGHT BELOW THE SERVICE DOOR. OPS CHECK SATSDR JJBA202108030028Battery Pack · inoperativeLEFT AND RIGHT OVERWING EMERGENCY LIGHT NOT WORKING. R&R #3 EMERGENCY BATTARY. OPS CHECK SATSDR JJBA20210730027Light · intermittentEMERGENCY LIGHT ON MAIN DOOR IS WORKING INTERMITTENLY. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT ASSY. OPS CHECK GOOD.SDR JJBA202108030026Glowstrip · crackedPHOTOLUMINESCENT STRIP CRACKED AT SEAT 1A. R/R PHOTOLUMINECENT STRIPSDR JJBA20210729004Attach Fitting · corrodedRIGHT WING AILERON ATTACHMENT LUGS "4" EACH HAVE LIGHT SURFACE CORROSION EXPOSED AND BARE METAL. BLENDED CORROSION 4 EACH AREAS ON RIGHT AILERON LUGS UPPER SURFACE.SDR JJBA2021090178072Floor Support · corrodedCORROSION ON CENTER AISLE LH OMEGA BEAM AT FLOOR BOARD MOUNTING SURFACE. REMOVED AND REPLACED CENTER AISLE LH OMEGA BEAM BETWEEN FR 48 AND FR52SDR JJBA2021090178067Doubler · not reportedEXTERNAL SKIN EXISTING DOUBLER REPAIR LEFT WING LEADING EDGE BETWEEN RIB 14 AND RIB 15. REPAIRED LEFT WING LEADING EDGE BETWEEN RIB 14 AND RIB 15SDR JJBA20210728025Battery Pack · unsecureRH EMERGENCY EXIT HATCH LIGHT INOP AT SEAT 18 C/D. SECURED #3 EMER LIGHT BATTERY, OPS CHECKS GOODSDR JJBA20210727028Mount · corrodedAT FRAMES BETWEEN FR 43-44 UNDER LT EMG. EXIT. EMG BATTERY #3 POSSIBLE CORROSION. REMOVED AND REPLACED EMG BATTERY #3 MOUNTING PLATE BRACKET IAW EMB145 SRM 51-40-02SDR JJBA2021080527016Fitting · scoredON NLG, RH BRACE FITTING AND BEARING CAP BOLT INNER HOLE SCORE AND BEARING BLUE SEAL TORN. FOUR BUSHING REPAIRS.SDR JJBA20210727024Battery Pack · inoperative3 EMERGENCY LIGHTS INOPERATIVE AT ROW 18. REMOVED AND REPLACED #3 EMERGENCY BATTERY. OPS CHECK GOOD.SDR JJBA2021090176073Frame · damagedFR22 INNER FLANGE HAS DAMAGE AT S15L. REPAIRED FRAME 22 INNER FLANGE AT S15L.SDR JJBA2021090176070Window Post · crackedCO-PILOTS WINDSHIELD LATERAL POST FRAME HAS CRACK AT UPPER SECTION 4.5 INCHES FROM HORIZONTAL CORNER. REMOVED AND REPLACED CO-PILOTS WINDSHIELD LATERAL POST FRAMESDR JJBA2021090176068Support Beam · crackedPAX DOOR UPPER AFT SUPPORT BEAM CRACKED ON AFT EDGE AS MARKED. REMOVED AND REPLACED PAX DOOR UPPER AFT SUPPORT BEAM.SDR JJBA2021090126061Access Panel · corrodedRIGHT WING FUEL TANK ACCESS OPENING FOR 631 BB HAS CORROSION IN SEVERAL AREAS AROUND RIM. REPAIRED RIGHT WING FUEL TANK ACCESS OPENING.SDR JJBA20210723065Doubler · not reportedEXTERNAL SKIN EXISTING DOUBLER REPAIR BETWEEN FR19 AND FR20 BETWEEN STR 6L AND STR 8L. REPAIRED EXTERNAL SKIN BETWEEN FR19 AND FR20 BETWEEN STR 6L AND STR 8L.SDR JJBA2021008043011Beam · corrodedCARGO DOOR ENTRY, LOWER BEAM CORRODED (LEVEL 3). LOWER BEAM REPLACED.SDR JJBA2021008042012Stringer · corrodedSTR 21 RH CORRODED AROUND FASTENERS BTW FR 50-51 (LEVEL 2). STRINGER REPLACEDSDR JJBA2021080422010Support · corrodedLH SILL #1 FOUND CORRODED. LH SILL #1 CORROSION OUT OF LIMITS AT 2,0" AFT OF FR20 (ANCHOR NUT). LH SILL #1 REPAIRED WITH REPAIR DOUBLER.
Back to Embraer EMB-145XR