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 JJBA20210429054Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE. R&R #1, #2, AND #4 EMERGENCY LIGHT BATTERIES. OPS CHECK GOOD. #1 PN ABS-2013-1A SN 50056 ; #2 PN ABS-2013-1A SN 54281 ; #4 PN ABS-2013-1A SN 51098.SDR JJBA20210428022Angle · corrodedCORROSION ON 2 EA ANGLES AT PAX DOOR SILL BETWEEN FR 16 - FR 17. REMOVED AND REPLACED 2 EA ANGLES AT PAX DOOR SILL BETWEEN FR 16 - FR 17SDR JJBA20210428058Stringer · bentBLEND FOUND ON STR 20S BTW FR 12A-13. AREA ON STR 20S BTW FR 12A-13 STRIPPED AND ONE RIVET REMOVED FOR INVESTIGATION. DAMAGED AREA REMOVED. SKIN REPAIRED ON STR 20S BTW FR 12A-13SDR JJBA20210428057Stringer · corrodedSTR 18 RH BTW FR 23-24 CORRODED. STR 18 RH BTW FR 23-24 CORROSION BLENDED OUT OF LIMITS BTW FR 23-24, RH STR 18 SOLID RIVETS (X9) REMOVED FOR SHEET METAL ACCESS. STR 18 RH BTW FR 22-24 REPAIRED.SDR JJBA2021008064023Profile · corrodedCORROSION ON PANEL 231 FF SUPPORT PROFILE AT L EDGE BETWEEN FR 18-19. REMOVED AND REPLACED PROFILE FOR PANEL 231FF AT LH EDGE BETWEEN FRAME 18 AND 19SDR JJBA2021080647021Doubler · corrodedCORROSION IN THE CARGO ON CENTER AT SECTION UPPER DOUBLER AT FR 65, 67, AND 68. REMOVED AND REPLACED CENTER HAT SECTION UPPER DOUBLER AT FR 65, 67, AND 68 IN CARGO.SDR JJBA2021080647020Floorbeam · corrodedAFT WET AREA, RH SIDE FLOOR BEAM IS CORRODED AT F59+19" AND Y+3.5". INSTALLED NEW UPPER BEAM CAP IN AFT WET AREA, RH SIDE FLOOR AT FR 59+19" AND Y+3.5".SDR JJBA2021080527014Floorbeam · corrodedAFT WET AREA LH SIDE CROSS MEMBER FLOOR SUPPORT IS CORRODED AT F58+8" AND Y-8". REMOVED AND REPLACED LH FLOOR CROSS MEMBER SUPPORT AT F 58=8 AND Y-8.SDR JJBA20210427041Battery Pack · inoperativeOVERWING EXIT EMERGENCY LIGHT IN CABIN INOPERATIVE. R&R #2 EMERGENCY LIGHT BATTERY POWER SUPPLY. OPS CHECK SAT.SDR JJBA20210425038Controller · faultedSMOKE IN CABIN. PERFORMED GVI OF THE PACK #2 ACM. NO DEFECTS NOTED. DETERMINED THE #2 DIGITAL TEMP CONTROLLER WAS FAULTY. PERFORMED GVI FOR OIL LEAKAGE FROM THE NO 0 CARBON SEAL ON ENGINE #2. NO OIL LEAKS OR DEFECTS NOTED. INSPECTED WATER WASH PORTS ON ENGINE SDR JJBA20210424040Light · inoperativeMAIN DOOR EMERGENCY CEILING LIGHT INOPERATIVE. R&R MAIN DOOR EMERGENCY CEILING LIGHTS. OPS CHECK SAT.SDR JJBA20210423016Fitting · damagedSIGN OF CORROSION IN THE FLOOR FITTINGS IN AFT LAV AND SCREWS DAMAGE. REPLACED FLOOR FITTING AND SCREWS ON AFT LAV FLOOR.SDR JJBA20210423039Light · inoperativeLOWER EMERGENCY LIGHT AT SEAT 18A INOPERATIVE. R&R EXIT ID SIGN. OPS CHECK SAT.SDR JJBA20210420036Skin · crackedLH FUSELAGE FR 75 BTW STR 1-3, SKIN CRACKED. LH FUSE, FR 75 BTW STR 1L-3L SKIN REPAIRED.SDR JJBA20210419035Structure · corrodedREAR FUSELAGE 1, BAGGAGE DOOR, FWD LATERAL L-SH FOUND CORRODED. REAR FUSE BAGGAGE DOOR SURROUND FWD LATERAL L-SH CORROSION BLENDED OUT OF LIMIT. REAR FUSE BAGGAGE DOOR SURROUND FWD LATERAL L-SH REMOVED FOR REPAIR. BAGGAGE DOOR FWD LATERAL L-SHAPE REPAIRED.SDR JJBA20210418053Sealant · missingRH MLG LOWER SIDE ARM LOWER FLANGE BEARING HAS MISSING SEALANT. APPLIED SEALANT TO RT MLG LOWER SIDE ARM FLANGE BEARING.SDR JJBA20210416052Arm · incorrectLH AND RH MLG BOTH GREASE FITTINGS ON LOWER SIDE ARM FACING AFT. REMOVED AND INSTALLED LOWER SIDE ARM IN CORRECT ORIENTATION. PERFORMED GEAR SWINGS. OPS CHECK SAT.SDR JJBA20210416037Skin · corrodedLH EXT FUSE SKIN BTW FR 61 AND JOINING OF SKIN AND BTW STR 20L-19L AT HEATED WATER DRAIN CORROSION. SKIN REPAIRED.SDR JJBA20210416034Frame · dentedFWD FUSELAGE I, DENT FOUND AT FRAME 3 AND BELOW STR 15R. REPAIR DOUBLER ON RH FWD FUSE 1, BTW FR 2-3 AND ON STR 15R PERFORMED AND MISSED DRILLED HOLE IN FRAME REPAIRED.SDR JJBA20210416029Handle · looseROW 18A EXIT PANEL OVER TOP HANDLE LOOSE. RESECURED OVER WING EXIT DOOR OPEN AND CLOSE HANDLE ACCESS PANEL APPLIED NEW VELCRO. NO FURTHER DEFECTS NOTED.SDR JJBA20210415051Sealant · missingREMOVED SEALANT AROUND THE RH AND LH MLG LOWER SIDE STRUT BEARING FLANGE. APPLIED SEALANT AROUND RH AND LH MLG LOWER SIDE STRUT BEARING.SDR JJBA20210414030Armrest · crackedSEAT 23A, 21A, 19A, 10A, 7A, 6A, 3A, 2A AISLE ARMREST SUPPORT STRUCTURE CRACKED. REMOVED AND REPLACED 23A, 21A, 19A, 10A, 7A, 6A, 3A, 2A SEAT ASSEMBLIES.SDR JJBA20210412026Armrest · crackedPAX SEAT 21A AND 2A AISLE ARMREST SUPPORT STRUCTURE CRACKED. RR PAX SEAT 21A AND 2A.SDR JJBA20210411016Charger · inoperativeBOTH LH EXTERNAL EMERGENCY LIGHTS AND RH OVERWING EXTERNAL EMERGENCY LIGHTS INOPERATIVE. R&R EMERGENCY BATTERY CHARGER #4. R&R LH LOWER WING FUSELAGE AND THE RIGHT HAND OVERWING EMERGENCY LIGHTS. OPS CHECK SAT OF ALL EMERGENCY LIGHTS.SDR JJBA20210410025Armrest · crackedFOUND CRACK IN PAX SEAT ARMREST AT 3A, 4A, 5A, 6A, 7A, 9A, 10A. RR PAX SEAT 3A, 4A, 5A, 6A, 7A, 9A, 10A.SDR JJBA20210410024Armrest · crackedFOUND CRACK IN PAX SEAT ARMREST AT 2A, 3A, 4A, 5A, 6A, 7A, 8A, 9A, 10A, 11A, 19A, 20A, 21A, 22A, 23A, AND 24A. REMOVED AND REPLACED SEAT AT 2A, 3A, 4A, 5A, 6A, 7A, 8A, 9A, 10A, 11A, 19A, 20A, 21A, 22A, 23A, AND 24ASDR JJBA20210409023Seat Track · crackedAISLE SIDE FRAME CRACKED ON SEATS 3A AND 22A. RR SINGLE SEATS ASSEMBLY ON ROWS 3A AND 22A. OPS CHECK SAT.SDR JJBA20210409022Armrest · crackedCRACK FOUND IN PAX SEAT ARMREST AT 3A. REMOVED AND REPLACED PAX SEAT AT 3A. NO FURTHER DEFECTS NOTED.SDR JJBA20210409021Armrest · crackedFOUND CRACK IN PAX SEAT ARMREST AT 10A. RR PAX SEAT 10A.SDR JJBA20210409017Strut · dischargedLG AIR/GND FAIL MESSAGE AFTER TAKE OFF GEAR WOLD NOT RETRACT. SERVICED NOSE LANDING GEAR STRUT. PERFORMED OPERATIONAL CHECK OF THE LANDING GEAR EXTENSION AND RETRACTION. OPS CHECK GOOD. PERFORMED MLH PROXIMITY SWITCH CLEARANCE GAP ADJUSTMENT CLEANED MLG PROXIMSDR JJBA20210408020Seat Frame · crackedFOUND CRACK IN PAX SEAT ARMREST AT 3A, 7A, 10A, 19A, AND 23A. RR PAX SEATS. NO DEFECTS NOTED.SDR JJBA20210408019Seat Frame · crackedAISLE SIDE FRAMES CRACKED ON SEAT 3A, 7A, 8A, 10A, 19A, AND 21A. RR SEATS 3A, 7A, 8A, 10A, 19A, AND 21A.SDR JJBA20210407018Armrest · crackedCONFIRMED WITH EDDY CURRENT MACHINE A CRACK INDICATION AT SEAT 8A ARMREST STRUCTURE. R&R PASSENGER SEAT 8A. NO FURTHER DEFECTS NOTED AT THIS TIMESDR JJBA20210407015Control Unit · inoperativePITCH TRIM MAIN INOPERATIVE. R&R HSCU. OPS CHECK SAT. PERFORMED HOR STAB ELECTRICAL/ELECTONIC OPS. NO DEFECTS NOTED. PERFORMED TROUBLESHOOTING, APPEARS TO BE TRANSITORY CONDITION.SDR JJBA20210407014Line · chafedE2 OIL LOW PRESSURE EICAS MASTER WARNING IN FLIGHT. OIL ON COWLINGS AFTER LANDING. FOUND CHAFED OIL LINE CONNECTED TO AGB TO OIL TANK PRESSURE LINE. R&R THE OIL LINE AND PERFORMED ENGINE RUNS. OPS CHECK AND LEAK CHECK SAT AT THIS TIME.SDR JJBA20210406044Seat Track · corrodedRH INBD SEAT TRACK SUPPORT BEAM FROM FRAME 24 TO BETWEEN FRAMES 29-30 HAS SIGNS OF CORROSION AND PAINT DAMAGE THROUGHOUT THE TOP LENGTH (RIVETS). REMOVED CORROSION RH, IB SEAT TRACK SUPPORT BEAM GUSSET FR 24-29, FOUND TO BE OUT OF LIMITS. REMOVED AND INSTALLEDSDR JJBA20210406033Rivet · looseLH RF2 FR 79 X2 RIVETS LOOSE BTW STR 9L-4L. CRACKS (2) REPAIREDSDR JJBA20210406032Rivet · looseLH RF2 FR 77 X3 RIVETS LOOSE BTW STR 10L-4L. CRACKS (3) REPAIRED.SDR JJBA20210405012Seat Frame · crackedAISLE SEAT FRAME CRACKED ON SEATS 2A, 3A, 4A, 10A, 19A, AND 21A. REMOVED AND REPLACED PAX SEATS 2A, 3A, 10A, 19A, 21A, AND 4A.SDR JJBA20210404049Flap Track · wornRH OB FLAP OB FLAP TRACK SHOWS SIGNS OF WEAR IN MULTIPLE AREAS. REMOVED AND REPLACED RH OB FLAP OB FLAP TRACK.SDR JJBA20210404045Seat Track · corrodedRH INBD SEAT TRACK SUPPORT BEAM FROM BETWEEN FRAMES 29-30 TO BETWEEN FRAMES 35-36 HAS SIGNS OF CORROSION AND PANT DAMAGE THROUGHOUT TOP LENGTH (RIVETS). REMOVED CORROSION AT RH IB SEAT TRACK SUPPORT BEAMS FR 30-35. FOUND TO BE OUT OF LIMITS. REMOVED AND INSTALSDR JJBA20210404011Armrest · crackedSEAT 23A, 5A, 4A, 3A, 2A ARMREST STRUCTURE IS CRACKED. REMOVED AND REPLACED SEAT ASSEMBLY 23A, 5A, 4A, 3A, 2ASDR JJBA20210404010Armrest · crackedFOUND CRACK IN PAX SEAT ARMREST AT 6A, 8A, 9A, 10A, 11A, 18A, 19A, 23A, 24A. R&R SEAT ASSEMBLY AT 6A, 8A, 9A, 10A, 11A, 18A, 19A, 23A, 24ASDR JJBA20210404009Armrest · crackedSEAT 23A, 20A, 10A, 9A, 8A, 5A, 4A, 3A ARMREST STRUCTURE IS CRACKED. R&R SEAT ASSEMBLY AT 23A, 20A, 10A, 9A, 8A, 5A, 4A, 3ASDR JJBA20210403008Seat Frame · crackedCRACKED AISLE SIDE FRAMES ON SEATS 8A, 9A, AND 22A. R&R SEATS 8A, 9A, AND 22A.SDR JJBA20210403001Bulb · inoperativeRH LATERAL FAIRING EMERGENCY LIGHT INOPERATIVE. R&R EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR JJBA20210402046Seat Track · corrodedLH INBD SEAT TRACK SUPPORT BEAM FROM BETWEEN FRAMES 29-30 TO BETWEEN FRAMES 35-36 HAS SIGNS OF CORROSION AND PAINT DAMAGE THROUGHOUT THE TOP LENGTH (RIVETS). REMOVED AND REPLACED GUSSET FROM LH IB SEAT TRACK SUPPORT FR 30 @ 35.SDR JJBA20210402043Seat Track · corrodedLH INBD SEAT TRACK SUPPORT BEAM FROM FRAME 24 TO BETWEEN FRAMES 29-30 HAS SIGNS OF CORROSION AND PAINT DAMAGE THROUGHOUT THE TOP LENGTH (RIVETS). REMOVED AND REPLACED GUSSET FROM FR 24 @ 29 ON LH INBD SUPPORT BEAMSDR JJBA20210402042Fitting · corrodedSIGNS OF POSSIBLE CORROSION ON 2 EACH FITTING FOR FILLING AND OVERFLOW LINE AT FLOOR BOARD IN AFT LAV APPROX FRAME STA 60. EWIS INSTALLED. CORROSION ON GUSSET-BEAD HAT FOUND TO BE OUT OF LIMITS. REMOVED RH AFT PRESSURE. REMOVED DAMAGED GUSSET. DRILLED NEW GUSSSDR JJBA20210402007Seat Frame · crackedCRACKED AISLE SIDE FRAMES ON SEATS 4A, 10A, 19A, AND 22A. R&R SEATS 4A, 10A, 19A, AND 22A.
Back to Embraer EMB-145XR