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 JJBA20211227015Not Reported · not reportedCARGO DOOR INNER LOWER SKIN HAS SEVERAL AREAS OF DAMAGE (CHAFING AND GOUGES). REMOVED AND REPLACED CARGO DOOR INNER LOWER SKINSDR JJBA20211227036Pressure Sensor · inoperativeRUDDER 1-2 INOPERATIVE ON SHORT FINAL INTERMITTENT. DAU WAS REPLACED AND SUSPECTED TO BE CAUSE OF MULTIPLE SYSTEM MALFUNCTIONS. AFTER TAKE OFF THE DAU 2A FAIL MESSAGE DISPLAYED AND THE RUDDER SYS 1-2 INOPERATIVE MESSAGE REAPPEARED AFTER EMERGENCY WAS DECLARED.SDR JJBA20211227035None · noneOVERHEAD EMERGENCY EXIT SIGN FALLING OFF. RESECURED EMERGENCY EXIT SIGN.
.SDR JJBA20211223010Not Reported · not reportedLH OVERWING EXIT HATCH HAS CORROSION ON LOWER FRAME UNDER RUBBER STOP. REMOVED AND REPLACED BEAM 4 ON LH OVER WING EXIT HATCHSDR JJBA20211223039None · noneLH OMEGA BEAM FOUND CRACKED AT FR 24 . LH OMEGA BEAM REPLACEDSDR JJBA20211221034None · noneCORROSION AT FR61 BETWEEN STRG 14R AND STR 15R ON PARTITION PANEL. REMOVED AND REPLACED PARTITION SECTION AT FRAME 61 STRINGER 15R-14RSDR JJBA20211221032None · noneFWD WET AREA FLOOR SUPPORT AT FR 23+2 STR 15R CORROSION. REMOVED AND REPLACED 2EA ANGLES.SDR JJBA20211220031None · noneUNDER PASSENGER DOOR SIL AIRCRAFT SKIN CORROSION. REMOVED AND REPLACED PAX DOOR SILL.SDR JJBA20211220029Brake · inoperativeFLAP FAIL ON APPROACH AT FLAP 0. FLAPS SET TO 9 DEGREES AND DISCONNECTED FPDU CONNECTORS P3683 & P3682. AIRCRAFT GOOD FOR FERRY FLIGHT WITH FLAPS 9 DEGREES. INSPECTED LH AND RH VELOCITY SENSOR HARNESS. NO DAMAGE NOTED. VERIFIED FLAP IS NOT TOUCHING FVSC CONNESDR JJBA20211219023None · noneMCD VERY DIFFICULT TO OPEN FROM INTERIOR AND EXTERIOR. PERFORMED OPS CHECK OF MAIN CABIN DOOR. DOOR OPERATES NORMALLY. NO FURTHER DEFECTS NOTED AT THIS TIMESDR JJBA20211217012Not Reported · not reportedCARGO DOOR LOWER OUTER FRAME HAS SEVERAL AREAS OF DAMAGE (CHAFING AND GOUGES). REMOVED AND REPLACED CARGO DOOR LOWER OUTER FRAME PROFILESDR JJBA20211217022None · noneRH OVER WING EXTERNAL EMERGENCY LIGHT IS INSTALLED UPSIDE DOWN. R&R RH OVER WING EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20211216021None · noneLH AND RH OVERWING EXTERNAL EMERGENCY EXIT LIGHTS ARE INSTALLED UPSIDE DOWN. REMOVED AND REINSTALLED EXTERNAL EMERGENCY LIGHTS.SDR JJBA20211216020None · noneEXIT ROW ARROW POINTED WRONG DIRECTION. RR LH LOWER EXIT SIGN ON ROW 18A. OPS CHECK SATSDR JJBA20211214028None · noneVENTRAL TANK FRONTAL FACE LIP TO ATTACH THE PANELS IS BARE METAL. CUTOUT DONE ON VENTRAL TANK FWD FACE LIP AND PART FABRICATED. VENTRAL TANK FRONTAL FACE LIP REPAIREDSDR JJBA20211214027None · noneCORROSION FOUND ON LOWER SKIN UNDER RAD ALT ANTENNA #2 AFT SUPPORT BTW FR 68-69 IN REAR FUSE I AREA. RAD ALT #2 ANTENNA, SUPPORT, SUPPORT ASSEMBLY AND FAIRING REMOVED FOR ACCESS. ANTENNA SUPPORT AND SUPPORT ASSY BLENDED OUT OF LIMITS. AFTER INVESTIGATION SKINSDR JJBA20211214026None · noneDENT FOUND ON RH SKIN BTW FR 25-26 AND BTW STR 13R-12R IN CF II AREA. DENT FOUND ON RH SKIN BTW FR 25-26 AND BTW STR 13R-12R IN CFII AREA. CUT-OUT PERFORMED ON RH SKIN BTW FR 25-26 AND BTW STR 13R-12R SKIN REPAIRED. REPROTECTION COVERED.SDR JJBA20211214025None · noneCORROSION FOUND ON LOWER SKIN BTW FR 20-21 AND BTW STR 21L-21R IN CF1 DOOR STRUCTURE AREA. SKIN AT FR20-21 BTW 21L-21R CORROSION BLENDED FOR ENGINEERING REVIEW. IN CF1 FLOOR STRUCTURE AREA. BTW FR20-21 AND BTW STR 21L-21R, LOWER SKIN REPAIRED WITH DOUBLER AND SDR JJBA20211214024None · noneDENTS FOUND ON LH SKIN BTW FR 19-21 AND BTW STR 11L-12L IN CF I AREA. LH SKIN BTW FR19-21 AND BTW STR 11L-12L IN CF! AREA, PATCH REMOVED FOR INVESTIGATION. 3 DENTS CUT OUT. LH SKIN BTW FR 19-21 AND BTW STR 11L-12L SKIN REPAIREDSDR JJBA20211214019None · noneDAMAGE FOUND ON RH OUTBD OMEGA BEAM AT FR 48 IN FLOOR STRUCTURE CF III AREA. ON RH OUTBD OMEGA BEAM AT FR48 IN FLOOR STRUCTURE CF3 AREA, DAMAGE CUTOUT ON RH OMEGA BEAM AT FR 48 IN FLOOR STRUCTURE REPAIR PERFORMEDSDR JJBA20211214017Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED #3 EMERGENCY BATTERY. OPS CHECK GOOD.SDR JJBA20211213016None · noneBAG BAY CUTOUT TRAILING EDGE GOUGED. BLENDED OUT DAMAGED AREA AND EVALUTATED. FOUND TO BE OUT OF LIMITS. PERFORMED ET AND UT INSPECTION BY BARON NDT, LLCSDR JJBA20211213010None · noneREAR FUSELAGE - SKIN HAS CORROSION UNDER RAR 2 ANTENNA MOUNT PLATE. REPAIRED WITH CUTOUT OF DAMAGE AT REAR FUSELAGE SKIN UNDER RAR #2 ANTENNA AT FR68-69 AND STR 21L-21R AND INSTALLED REPAIR DOUBLER. CORROSION LEVEL IISDR JJBA20211213009Lamp · inoperativeEMERGENCY EXIT LIGHT FORWARD OF WING INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT LIGHT. OPS CHECK SAT.SDR JJBA202112141007Sensor · failedFLAP FAIL WHEN SELECTING 0-9 PRIOR TO LANDING. REMOVED AND REPLACED FLAP VELOCITY SENSOR LH. OPS CHECK GOOD.SDR JJBA20211211008Lamp · inoperativeINOPERATIVE AISLE EMERGENCY LIGHT LAMP LOCATED AT WING EMERGENCY EXIT. REMOVED AND REPLACED AISLE EMERGENCY LIGHT LAMP LOCATED AT WING EMERGENCY EXIT. OPS CHECK PASS.SDR JJBA20211210012None · noneCARGO DOOR - EXT - LWR INNER DOOR ANGLE HAS CORROSION. REMOVED AND REPLACED LOWER INNER CARGO DOOR ANGLE. CORROSION LEVEL IISDR JJBA20211210011None · noneFUSELAGE EXTERIOR TAIL - CRACK .100" LONG IN FUSELAGE SKIN STARTING AT FASTENER HOLE AT FR 75 STRG 2R. REPAIRED TRIMMED OUT IN FUSELAGE SKIN STARTING AT FASTENER HOLE AT FR 75 STRG 2R WITH REPAIR DOUBLER, REPAIR FILLER, AND FORMED REPAIR ANGLE.SDR JJBA20211208015None · noneREMOVE, RE-FABRICATE AND INSTALL DOUBLER AT REAR FUSELAGE SKIN RAR 2 ANTENNA THAT WAS DAMAGED ON INSTALL. REMOVED, FABRICATED AND REINSTALLED REPAIR DOUBLER AT REAR FUSELAGE SKIN RAT 2 ANTENNASDR JJBA20211207006None · noneRH VERTICAL PARTITION LOWER SILL ATTACH POINT HAS SIGNS OF CORROSION AT FASTENER HOLES. ACCOMPLISHED PERMANENT REPAIR. SPLICE DOUBLER FABRICATED. CORROSION LEVEL II.SDR JJBA20211205005None · noneROW 18 EMERGENCY LIGHTS DO NOT COME ON WHEN SWITCH IS ACTIVATED. CHARGED EMERGENCY LIGHT BATTERIES USING AC POWER. OPS CHECK OF EMERGENCY LIGHTS SAT. NO OTHER DEFECTS NOTED.SDR JJBA20211202014None · noneMAIN CABIN OMEGA BEAM AT FR 57-61 Y+0 HAS CORROSION. REMOVED AND REPLACED MAIN CABIN OMEGA BEAM AT FR 57-61 Y+0. CORROSION LEVEL IISDR JJBA20211201002None · noneFWD MOST EMERGENCY LIGHT STRIP UNSECURE. RESECURED FWD EMERGENCY LIGHT STRIPSDR JJBA20211201003Pump · inoperativeE1 HYD PUMP FAIL ON EICAS AFTER ROTATION. REMOVED AND REPLACED E1 HYD PUMP. DURING BLEED FOUND BAD O-RING ON HYD PRESSURE LINE FROM SYS 1 ELE HYD PUMP. REMOVED AND REPLACED O-RING. NO LEAKS NOTED. OPS AND LEAK CHECK SAT.SDR JJBA20211201004None · noneLH OB FLOOR SILL SHOWS SIGNS OF CORROSION BETWEEN FRAMES 42-49. REMOVED AND REPLACED DAMAGE SILL BETWEEN FRAMES 42-49 LH SIDESDR JJBA20211201001Lamp · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EMERGENCY LIGHT BULB. OPS CHECK SATSDR JJBA20211130036Bulb · inoperativeLH EXIT FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH EXIT FWD EMERGENCY LIGHT BULB. OPS CHECK GOODSDR JJBA20211129018None · noneLH OMEGA BEAM FOUND CRACKED AT FR 24, AND FR 25 AND BOTTOM FLANG FOUND CORRODED. REPLACED WITH NEW PART LH OMEGA BEAM BTW FR 23-29SDR JJBA2021110128035Sign · inoperativeFOUND EXIT MARKER SIGN ASSEMBLY INOPERATIVE AT ROW 18A. REMOVED AND REPLACED EXIT MARKER ASSEMBLY LIGHT. OPS CHECK SATSDR JJBA20211127033None · nonePAX DOOR LOWER FWD CORNER BENT. CUTOUT DAMAGE AREA, FABRICATED DOUBLER AND FILLER FROM 2024T3 .080". INSTALLED REPAIR PARTS AT PAX DOOR LOWER FWD CORNER.SDR JJBA20211125047Unknown · unknownRH FWD FUSELAGE I, TWO LIGHTING STRIKES SUSPECTED BTW FR 1A & 2 AND ABOVE STR 13R. DURING LIGHTING STRIKE INVESTIGATION MULTIPLE STRIKE SPOTS BLENDED WITHIN LIMITS, SOME ACCEPTED AS IS AND 2 BLEND OUT FOUN OUT OF LIMITS AND NEED A EXTERNAL DOUBLER REPAIR. FIRSSDR JJBA20211125045Unknown · unknownMULTIPLE DENTS FOUND ON EXTERNAL SKIN OF MAIN DOOR BTW STR 06L AND STR 08L, STR 12L AND STR 15L. MULTIPLE DENTS ON EXT SIGN OF MAIN DOOR BTW STR 06L-08L AND STR 12L-15L STRIPPED FOR INVESTIGATION ON EXT SKIN OF MAIN DOOR BTW STR 06L-08L AND STR 12L-15L DENTS 1SDR JJBA20211125044None · noneCF1, SKIN FOUND WITH EXISTING BLEND BTW FR 20-21 STR 11-12L. CF1, SKIN BTW FR 20-21 AND STR 11-12L FOUND BLENDED OUT OF LIMITS. REPAIR WAS MADE.SDR JJBA20211125042Light · inoperativeEMERGENCY LIGHTS ON LH AND RH WING LADDER FAIRING INOPERATIVE. REMOVED AND REPLACED RH EXTERNAL EMERGENCY LIGHT BULB. REMOVED AND REPLACED LH EXTERNAL EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR JJBA20211124046Unknown · unknownRIVET FOUND ON LEADING EDGE II RH. DENT AT RIVET LOCATION OF LEADING EDGE II RH FOUND OUT OF LIMITS AND NEEDS REPAIR PARTS FOR REPAIR SPLICE AND FILLER FABRICATED. REPAIR SPLICE AND FILLER INSTALLEDSDR JJBA20211124043None · noneCENTER FUSE II, FRAME 25 CRACKED BTW STR 16R-15R. FRAME REPAIREDSDR JJBA20211124041None · noneCRACK FOUND ON LH FRAME 59 BTW STR 15L-16L IN CF IV AREA. FRAME REPAIREDSDR JJBA20211124040Skin · damagedFWD FUSELAGE 1 RH SKIN AT FR 3 BTW STR 01R-13R SEVERAL RIVETS NOT PROPERLY INSTALLED. PAINT STRIPPED ON FWD FUSELAGE I RH, STR 01R-13R FOR INVESTIGATION ON FWD FUSELAGE I RH SKIN AT FR3 BTW STR 01R-13R IMPROPERLY INSTALLED RIVETS REMOVED. RIVETS HOLES FOUND TOSDR JJBA20211124039Doubler · corrodedCORROSION FOUND ON ANTENNA INNER DOUBLER BTW FR 65-66 AND STR 21LH + STR 21RH. REMOVED R. ALT ANTENNA FOR ACCESS, REMOVED INNER AND OTHER DOUBLER FOR INVESTIGATION. AFTER FURTHER INVESTIGATION FOUND OUTER SKIN CRACK OUT OF LIMITS AT R. ALT ANTENNA LOCATION. PESDR JJBA20211123037Mount · corrodedRH VERTICAL PARTITION LOWER SILL ATTACH POINT HAS SIGNS OF CORROSION AT FASTENER HOLES. ACCOMPLISHED BEAM FUSELAGE !, FRAME 61 DOUBLER REPAIR AT RH VERTICAL PARTITION LOWER.
Back to Embraer EMB-145XR