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 JJBA20220522037None · noneFWD LH EXTERNAL EMERGENCY LIGHT AS CONDENSATION IN THE LENS. REMOVED LENS AND DRIED CONDENSATION. RE-INSTALLED LENS.SDR JJBA20220520039None · noneFRONT SIDE OF EMERGENCY EXIT LIGHT IS INOPERATIVE. RESECURED EMERGENCY EXIT LIGHT CONNECTIONSDR JJBA20220519036None · leakingBRAKE DEGRADED CAUTION MESSAGE ON FINAL APPROACH. ALL WHEEL SPEED SENSORS CHECKED AND FOUND SATISFACTORY. AIRCRAFT TAXIED OUT AND FOUND #2 BRAKES ON MFD HOTTER THAN ALL OTHER WHEELS. AIRCRAFT JACKED AND FOUND #2 BRAKES BINDING. REMOVED AND REPLACED #2 BRAKE ASSDR JJBA20220519034None · noneBRACKET ON RH SIDE OF VENTRAL TANK IS BROKEN. REMOVED AND REPLACED BROKEN BRACKET ON RH SIDE OF VENTRAL TANKSDR JJBA20220519033None · noneUPON REMOVAL OF SHROUD FOUND CORROSION AT FR61 RH PARTITION PANEL. REMOVED AND REPLACED RH DOUBLER FWD PORTITION AT FR61. NO DEFECTS NOTED AT THIS TIMESDR JJBA20220519032None · noneSTIFFENER ON FR65 AT STR 14R-STR15R HAS SIGNS OF CORROSION. REPLACED STIFFENER ON FR65SDR JJBA20220518035None · noneDAMAGE TO LH LOWER COWLING ON THE FWD LEADING EDGE. BLENDED DAMAGE, INVESTIGATED DAMAGE - NO CRACKS NOTED. PERFORMED HFEC ON BLENDED AREA. NO CRACKS NOTED.SDR JJBA20220518031None · noneLH OB LATERAL FLOOR SUPPORT CORROSION FR 24-34 LBL30. REMOVED AND REPLACED LH OB LATERAL FLOOR SUPPORT (SILL) BTW FR24 AND FR30 LBL 30SDR JJBA20220707005None · noneLOOSE RIVET ON R/H FF2 SKIN BTW FRAME 7&8 AND BTW STR 19&20. LOOSE RIVET ON R/H FF 2 SKIN REMOVED. AFTER RIVET REMOVAL, DAMAGE FOUND AND BLENDED OUT OF LIMITS. DAMAGE ON R/H SKIN BTW FM 7&8 AND BTW STR 19&20 REPAIRED WITH A PATCH DOUBLER.SDR JJBA20220515027Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR JJBA20220515026Battery Pack · inoperativeLH FWD WTF FAIRING EMERGENCY LIGHT INOPERATIVE. FOUND MULTIPLE EMERGENCY LIGHTS INOPERATIVE ON THE SAME CIRCUIT. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY. OPS CHECK SATSDR JJBA20220514025None · inoperativeFLAP FAIL WHEN SELECTING FLAPS 9 ON APPROACH. REMOVED AND REPLACED FECU AND FLAP DRIVE UNIT.SDR JJBA20220513030None · noneCORROSION FWD CENTER DOOR GUSSET FR15 LBL28. REMOVED AND REPLACED FWD ENTRY DOOR GUSSET FR15 LBL28SDR JJBA20220513024Battery Pack · inoperativeBOTH FWD WTF EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACKS #1 AND #2. OPS CHECK SAT FOR #1. OPS CHECK FAILED FOR #2. PART BAD FROM STOCK. REMOVED AND REPLACED #2. OPS CHECK SAT.SDR JJBA20220512040None · noneUPPER AFT FUSELAGE EXTERIOR - FUSELAGE SKIN CRACKED STARTING AT 2 EA FASTENER HOELS ON FR75 STGR 2R. REPAIRED CRACK UPPER AFT FUSELAGE EXTERIOR SKIN AT FR75 BETWEEN STGR 2R.SDR JJBA20220512029None · noneSERVICE DOOR SILL LOWER HAS MISSING RIVETS, SIGNS OF CORROSION, FASTENERS ARE MISS BUCKED. REMOVED AND REPLACED SERVICE DOOR SILL LWR.SDR JJBA20220512028None · noneCENTER FLOOR GUSSET CORROSION FR19-24 BL0. CLEANED AND EVALUATED CENTER FLOOR GUSSET CORROSION AT FR19-FR24 BL0. UPON EVALUATION FOUND TO BE 100% OUT OF LIMITS. REMOVED AND REPLACED CENTER FLOOR GUSSET.SDR JJBA20220512023None · inoperativeREAR LH EXTERNAL EMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED REAR LH EXTERNAL EMERGENCY LAMP. OPS CHECK SATSDR JJBA20220510022None · noneRH HATCH DOOR LOWER EXIT IDENTIFIER SIGN INOPERATIVE. REMOVED AND REINSTALLED AFFLICTED LIGHT. OPS CHECK SAT.SDR JJBA20220506021None · noneCENTER FLOOR GUSSET HAS MULTIPLE AREAS OF CORROSION FR 23-25 BL0. REMOVED AND REPLACED CENTER FLOOR GUSSET AT FR 24-29 BL0. NO DEFECTS NOTED AT THIS TIMESDR JJBA20220505019Lamp · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR JJBA20210505018None · noneAT REAR FUSE II EXT, SUSPECTED CRACKS (7X) FOUND ON RH SIDE SKIN BTW FR 77-FR80 AND BTW STR 3R-9R. AFTER INVESTIGATION 7 SUSPECTED CRACKS CONFIRMED. FRAME 77 BTW STR 3R-4R TWO CRACKS TOO CLOSED REPAIRED WITH DOUBLER. (X5) BUSHING LOCALLY FABRICATED )MADE REPAISDR JJBA20220505017None · noneAT REAR FUSE EXT, DAMAGE FOUND ON BELLY SKIN BTW FR73-74 AND BTW STR 19L-19R. RH REAR FUSELAGE #1 SKIN BTW FR72-76 AND BTW STR 16R TO 20L REMOVED AND SPLICED. NEW SKIN SECTION LOCALLY FABRICATED. RH REAR FUSELAGE #1 SKIN BTW FR77 - FR 76 AND BTW STR 16R-20L RESDR JJBA20220504041None · noneMAIN CABIN AFT WET AREA CENTER OMEGA BEAM HAS CORROSION AROUND NUTPLATE HOLE AT FR59-FR60 Y=0. REPAIRED CORROSION AROUND 2 EACH NUTPLATE HOLES BY CUTOUT AND INSTALL OF 2 EA DOUBLERS AT DAMAGED AREA CENTER OMEGA BEAM AT FR59-FR60 AT Y=0SDR JJBA20220504020None · noneLH SEAT TRACK ON FLOOR CORRODED FR 53-57 LBL 18. REMOVED CORROSION FROM LBL 18 SEAT TRACKS FROM FR53-55. SEAT TRACK FROM FR56-57 FOUND TO BE OUT OF LIMITS. PERFORMED ET ON SEAT TRACKS FROM FR53-55 NO CRACKS FOUND. THICKNESS CHECK, ALL MEASUREMENTS ABOVE MIN RESDR JJBA20220504013None · noneRH FLOOR SILL HAS SIGNS OF CORROSION FROM FR68-71. EVALUATED ON RH FLOOR SILL AT FR68-71, FOUND TO BE 100% OUT OF LIMITS. REMOVED RH FLOOR SILL. LOCATED AND DRILLED NEW RH FLOOR SILL. INSTALLED NEW RH FLOOR SILL. ALODINED AND PRIMED HOLES.SDR JJBA20220503016None · noneAT CFII, CORROSION FOUND ON LOWER STR 21R BTW FR50-51 IN U/FLOOR AREA. LOWER STR 21R BTW FR50-51 IN UNDERFLOOR AREA FOUND BADLY CORRODED. LOWER STR 21R BTW FR 50-51 IN UNDERFLOOR AREA REPLACED.SDR JJBA20220503015None · noneCIRCULAR DOUBLER AT FWD BULKHEAD TO BE REMOVED FOR REPAIR MAPPING. DOUBLER AT FWD BULKHEAD REMOVED FOR INVESTIGATION. CIRCULAR DOUBLER AT FWD BULKHEAD REPLACED WITH MADE REPAIR PART, LOCALLY FABRICATED.SDR JJBA20220503007None · noneDURING ACCESS REMOVAL RH AFT CARGO FLOOR SILL FOUND BLEED AIR DUCT BRACKET CRACKED FR73 RH SIDE OF SUPPORT. REMOVED, FABRICATED AND INSTALLED REPLACEMENT BLEED AIR DUCT BRACKET AT RH AFT CARGO FLOOR SILL FR73, RH SIDE.SDR JJBA20220503006None · noneCORROSION ON FLOOR GUSSET FR20 BL0 - RBL 17, REMOVED AND REPLACED BEAMSDR JJBA20220503004None · noneLATERAL FLOOR SILL SUPPORT CORROSION FR24 RBL 32. REMOVED AND REPLACED LATERAL FLOOR SILL SUPPORT FR24, RBL32. NO DEFECTS NOTED AT THIS TIME.SDR JJBA20220502012None · noneREAR FUSELAGE SKIN HAS CORROSION UNDER #2 RAT ANTENNA ON EXTERNAL AND INTERNAL SURFACES. REPAIRED REAR FUSELAGE SKIN UNDER #2 RAT ANTENNA.SDR JJBA20220502003Unknown · unknownRH FLOOR SILL HAS SIGNS OF CORROSION AROUND NUTPLATE HOLES AT FR65 TO FR68. REMOVED AND REPLACED RH FLOOR SILL AT STGR 15 BETWEEN FR65 TO FR68SDR JJBA20220502002Unknown · unknownEMERGENCY DOOR HANDLE ON EMERGENCY EXIT OVER WING RIGHT SIDE REMOVED, WILL NOT ADHERE TO WALL. REINSTALLED EMERGENCY EXIT COVER RS WINGSDR JJBA20220501001None · noneHAD AN ELECTRICAL BURNING SMELL IN THE FLIGHT DECK WHILE FLYING THROUGH HEAVY RAIN WITH BOTH ENGINE IGNITERS ON. SMELL WENT AWAY AFTER LANDING. COMPLIED WITH FIM. GROUND RAN ENGINE 1 AND 2. NO DEFECTS OR SMELL NOTED. COMPLIED WITH WINDSHIELD HEAT CONTROLLER INSDR JJBA20220430005Unknown · out of adjustSTEERING INOPERATIVE DISPLAYED UPON LANDING - OCF FLIGHT. INSPECTED AND FOUND FEED BACK POTENTIOMETER OUT OF ADJUSTMENT, ADJUSTED FEEB BAC POTENTIOMETER. REMOVED AND REPLACED 7 DEG PROX SWITCH. OPS CHECK SAT.SDR JJBA20220429033None · noneRH FLOOR SILL JUST AFT LAV BULKHEAD HAS SIGNS OF CORROSION FR61 TO FR65. REMOVED AND REPLACED RH FLOOR SILL.SDR JJBA20220429032Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED COCKPIT EMERGENCY EXIT LIGHT LAMP. OPS CHECK SATSDR JJBA20220429031None · wrong partINCORRECT EXIT MARKER INSTALLED ON FLOOR PROXIMITY LIGHT ALONGSIDE SEAT 24A. REMOVED AND REPLACED EXIT MARKER. NO DEFECTS NOTED.SDR JJBA20220428030Lamp · flutterSERVICE DOOR EXTERNAL EMERGENCY EXIT LIGHT FLICKERS. REMOVED AND REPLACED SERVICE DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20220427029None · inoperativeFOUND LH LOWER HATCH DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LOWER HATCH DOOR EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20220425028None · noneLAV/CARGO LATERAL FLOOR SUPPORT FR61-66 STR 15R CORROSION. REMOVED AND REPLACED LATERAL FLOOR SUPPORT AT STR15R FROM FR61-66SDR JJBA20220425027None · noneLAV/CARGO PARTITION DOUBLER POSSIBLE CORROSION FR61 STR15L. REMOVED AND REPLACED LAV/CARGO PARTITION DOUBLER FR61 STR 15LSDR JJBA20220422025None · noneHYD 1 LOW QTY "ON EICAS" & HYD FLUID 1 IN AMBER IN FLIGHT. HYD 1 FAIL AFTER LANDINGSDR JJBA20220422026None · noneCABIN LATERAL FLOOR SUPPORT BETWEEN FRAMES 48-52 AT STRINGER 15L HAS SIGNS OF CORROSION. CUT-OUT FLOOR SILL DAMAGE SECTION AT STR 15L BETWEEN FRAME 49+10 -52. FABRICATED NEW SECTION AND INSTALL AT LH FLOOR SILL STR 15L BETWEEN FRAME 49+10-52SDR JJBA20220421024None · unbondedEXIT ROW FWD CEILING EMERGENCY EXIT INDICATION PLACARD DISBONDED FROM LH MOUNTING SCREW. REMOVED AND REPLACED EXIT LOCATING SIGN ASSEMBLY. OPS CHECK SAT.SDR JJBA20220420009None · noneREAR FUSELAGE SKIN HAS CORROSION UNDER #2 RAR ANTENNA ON EXTERNAL AND INTERNAL SURFACES. REPAIRED REAR FUSELAGE SKIN UNDER #2 RAR ANTENNA.SDR JJBA20220419023Lamp · inoperativeEXTERNAL LH REAR EMERGENCY LIGHT LAMP INOPERATIVE. REMOVED AND REPLACED LIGHT BULB. OPS CHECK GOOD.SDR JJBA20220418042None · noneCORROSION ON RH GUSSET BETWEEN FR22-FR23 Y.00. REMOVED AND REPLACED RH GUSSET BETWEEN FR 19 - FR23 Y.00SDR JJBA20220416022None · unknownBRAKE DEGRADE MESSAGE ON EICAS. REMOVED AND REPLACED INBD RH BRAKE CONTROL VALVE. OPS AND LEAK CHECK SAT. PERFORMED TAXI CHECK OF AIRCRAFT. NO DEFECTS NOTED DURING TAXI
Back to Embraer EMB-145XR