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 JJBA20230920021Battery Pack · inoperativeEMERGENCY LIGHT BATTERIES DEAD. REMOVED AND REPLACED #1 AND #2 EMERGENCY BATTERY, RECHARGED #3 AND #4 EMERGENCY BATTERIES WITH 28V ESS DC BUSS AND OPS CHECKED. OPS CHECK SAT.
POSITION 1: PN: ABS-2013-1A SN 51991 TSN 4196.26 CSN 3717SDR JJBA20230920022Control Panel · unknownFWD FA INTERPHONE EMERGENCY LIGHT SLIGHTLY ILLUMINATED. SLAVED IN NEW ATTENDANT HANDSET. NO FIX. REINSTALLED ORIGINAL HANDSET BACK. SWAPPED FORWARD AND AFT HANDSETS, NO FIX. SLAVED IN AN ICU PANEL, NO FIX. ORIGINAL PLACED BACK IN. SLAVED IN A PA AMPLIFIER, NO SDR JJBA20230920020Unknown · unknownFA FLASHLIGHT CHARGES INTERMITTENTLYSDR JJBA20230919017Lamp · inoperativeLH EXTERIOR FWD EMERGENCY LIGHT IS OUT. REMOVED AND REPLACED LH EXTERIOR FWD EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20230919018Unknown · unknownEMERGENCY EXIT SIGN ABOVE GALLEY FALLING OFF. RESECURED EMERGENCY EXIT SIGN.SDR JJBA20230927045Unknown · unknownCOCKPIT HORIZONTAL OVERHEAD PANEL FOUND CRACKED AROUND HANDLE. 2 REPAIR DOUBLERS ON LH & RH FWD FUSE 2 WINDOW FLIGHT COMPARTMENT OVERHEAD PANEL HORIZONTAL RIBSDR JJBA20230920037Unknown · unknownRF1, CARGO DOOR SURROUND STRUCTURE AFT L-SHAPE AT FR 68 FOUND CORRODED. SPLICE ON LH REAR DUSE 1 FRAME 68, ON SHEAR CLIP BTW STR 15L-16LSDR JJBA20230920035Unknown · unknownREPAIR TO BE PERFORMED ON REAR FUSELAGE II FRAME 79. REPAIR DOUBLER ON REAR FUSE 2 FRAME 79, AT RUDDER CONTROL CABLESDR JJBA20230920033Unknown · unknownCF4, RH OMEGA BEAM ON FLOOR STRUCTURE FOUND CORRODED (2 PLACES) BTW FR 59-60 AND BTW FR 60-61. 2 REPAIR DOUBLERS ON RH CENTER FUSE 4 OMEGA BEAM, ON UPPER SURFACE. REPAIR #1: AFT FR 59. REPAIR #2: FWD FR61SDR JJBA20230920032Unknown · unknownCF4, LH OMEGA BEAM ON FLOOR STRUCTURE FOUND CORRODED AROUND NUTPLATE BTW FR 59-60. REPAIR DOUBLER ON LH CENTER FUSE 4 OMEGA BEAM, ON UPPER SURFACE BTW FR 59-60SDR JJBA20230920031Unknown · unknownCF4, MIDDLE OMEGA BEAM ON FLOOR STRUCTURE FOUND CRACKED (2 PLACES) BTW FR 59-60 AND BTW FR 60-61. 2 REPAIR DOUBLERS ON CENTER FUSE 4 CENTER OMEGA BEAM, ON UPPER SURFACE. REPAIR #1: BTW FR 59-60, REPAIR #2: FWD OF FR 61SDR JJBA20230920030Unknown · unknownRF1, CARGO DOOR SURROUND STRUCTURE FWD L-SHAPE AT FR 65 FOUND CORRODED. SPLICE ON LH REAR FUSE 1 FRAME 65, ON SHEAR CLIP BTW STR 15L-16LSDR JJBA20230920025Unknown · unknownCF1, CRACKS (3X) FOUND ON LH OMEGA BEAM #1 FLOOR STRUCTURE BTW FR 18-24. OMEGA BEAM REPLACEDSDR JJBA20230920038Unknown · unknownEXISTING REPAIR TO BE INVESTIGATE ON LH CTR FUSELAGE I SKIN, AT FR 23 AND BTW STR 12L-14L. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230920036Unknown · unknown2X NUT PLATES DAMAGED ON LH SIDE OF FORE RUDDER ASSEMBLY. SKIN REPAIRED WITH A SPLICE.SDR JJBA20230920034Unknown · unknownCF2 EXT, DENT FOUND ON LOWER BELLY SKIN BTW FR 27-28 AND BTW STR 21L-21R. REPAIRED WITH A DOUBLER.SDR JJBA20230920029Unknown · unknownCRACKS SUSPECTED (19X) ON RH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3R-9R. AFTER NDT INSPECTION, 13 CRACKS FOUND. SKIN REPAIRED WITH A DOUBLER AND 11 BUSHINGSSDR JJBA20230920028Unknown · unknownDAMAGE FOUND ON EXISTING DOUBLER REPAIR BTW FR 20-21 AND BTW STR 13L-14L. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230920027Unknown · unknownCF2, RH FRAME 25 FOUND CRACKED BTW STR 15R-16R. FRAME REPAIRED WITH AN EXTENDED SPLICESDR JJBA20230920026Unknown · unknownCF2, CRACKS (3X) FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BTW FR 23-30. OMEGA BEAM REPLACEDSDR JJBA20230913006Unknown · unknownEMERGENCY EXIT CAPT SIDE OVER WING OPEN MESSAGE. RE SEATED EMERGENCY EXIT DOOR.SDR JJBA20230911005Pin · inoperativeCABIN EMERGENCY LIGHT ON FA HANDSETS WILL NOT TURN OFF. REMOVED AND REPLACED PIN 30&29 ON FA INTER-PHONE. OPS CHECK GOODSDR JJBA20230911004Unknown · unknownRT EMERGENCY EXIT DOOR SHOWING OPEN. CLEANED MICRO SWITCH. OPS CHECK SAT.SDR JJBA20230911003Lamp · inoperative18CD PSU EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED 18CD OVERWING EMERGENCY LIGHT BULB. OPS CHECK GOOD.SDR JJBA20230920023Unknown · unknownRF1, LOWER BEAM OF CARGO DOOR SURROUND STRUCTURE BTW FR 65-68 FOUND CORRODED. LOWER BEAM REPLACEDSDR JJBA20230920024Unknown · unknownRF1, CRACK FOUND ON LOWER ANGLE AT FR 66 STR 17L-18L. LOWER ANGLE REPLACEDSDR JJBA20230913016Unknown · unknownRF1, RH FR 65 REINFORCEMENT FRAME DOUBLER AT FLOOR LEVEL BTW STR 15R-16R FOUND CORRODED. REINFORCEMENT ANGLE REPLACEDSDR JJBA20230913015Unknown · unknownAT RF1, FRAME 66, LH SIDE SHEAR CLIP BTW STR 7L-9L FOUND CRACKED. SHEAR CLIP REPLACEDSDR JJBA20230913014Unknown · unknownAT RF1, FRAME 72, LH SHEAR CLIP U/FLOOR BTW STR 17L-18L FOUND CRACKED. SHEAR CLIP REPLACEDSDR JJBA20230913013Unknown · unknownAT RF1, FRAME 72, LH SHEAR CLIP U/FLOOR BTW STR 16L-17L FOUND CRACKED. SHEAR CLIP REPLACEDSDR JJBA20230913011Unknown · unknownCF2, FRAME 28, LH SHEAR CLIP FOUND CRACKED BTW STR 15L-16L. SHEAR CLIP REPLACEDSDR JJBA20230913010Unknown · unknownCF2, FRAME 26, LH SHEAR CLIP FOUND CRACKED BTW STR 15L-16L. SHEAR CLIP REPLACEDSDR JJBA20230913009Unknown · unknownCF2, FRAME 27 RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. SHEAR CLIP REPLACEDSDR JJBA20230913008Unknown · unknownCF2, FRAME 26, RH SHEAR SLIP FOUND CRACKED BTW STR 15R-16R. SHEAR CLIP REPLACEDSDR JJBA20230913007Unknown · unknownCF2, FRAME 24, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. SHEAR CLIP REPLACEDSDR JJBA20230908001Unknown · unknownMAIN CABIN DOOR HARD TO OPEN. LUBED MAIN DOOR. OPS CHECK SAT.SDR JJBA20230919019Battery Pack · inoperative#2 EMERGENCY LIGHT BATTERY IS DEAD AND WILL NOT CHARGE FROM A/C. REMOVED AND REPLACED EMERGENCY POWER SUPPLY BATTERY PACK. OPS CHECK GOODSDR JJBA20230830028Pump · inoperativeHYD 1 LOW QUANTITY EICAS MESSAGE AFTER LANDING GEAR DEPLOYMENT. FLUID QTY READING IN YELLOW. REMOVED AND REPLACED RH MLG MANEUVERING ACTUATOR HOSES AND LH EDP. BLED AND SERVICED HYDRAULIC SYSTEM 1. OPS CHECK SAT. PERFORMED MULTIPLE LANDING GEAR SWINGS. OPS CHESDR JJBA20230907027Unknown · unknownLH WING FFS 4 CASING ALUMINUM FERRULE CORRODED. LH WING FFS#4 REPLACED FOR A NEW ONESDR JJBA20230908002Unknown · unknownLH WING FFS5 CASING ALUMINUM FERRULE CORRODED AND FFS 1 INNER SHAFT BENDED AND RH WING FFS 1 CASING ALUMINUM FERRULE CORRODED. LH WING FFS 5 REPLACED AND TESTED SERVICEABLESDR JJBA20230825025Unknown · unknownRF1, CARGO DOOR SURROUND STRUCTURE AFT L-SHAPE AT FR 68 FOUND CORRODED. SHEAR CLIP REPAIRED WITH A SPLICESDR JJBA20230825026Unknown · unknownMAIN CABIN DOOR DIFFICULT TO OPEN. PERFORMED MAIN DOOR TEST. OPS CHECK SATSDR JJBA20230825024Unknown · unknownRF1, CARGO DOOR SURROUND STRUCTURE FWD L-SHAPE AT FR 65 FOUND CORRODED. SHEAR CLIP REPAIRED WITH A SPLICESDR JJBA20230825020Control Unit · inoperativePTIM MAIN INOPERATIVE, BACKUP PITCH TRIM INOPERATIVE EICAS DISPLAYED IMMEDIATELY AFTER T/O. R & R HORZ STAB CTL UNIT. REMOVED HAS UPPER BOLTS. C/W MOVEMENT OF STAB UP/DOWN, NO DEFECTS NOTED. NO DAMAGE OF CORROSION NOTED ON PIVOT BEARING. REINSTALLED HAS UPPERSDR JJBA20230823019Battery Pack · inoperativeEMERGENCY LIGHT BATTERIES DEAD. REMOVED AND REPLACED #2, #3 AND #4 EMERGENCY LIGHT BATTERIES. OPS CHECK SAT. PERFORMED OPS CHECK OF EMERGENCY LIGHTING SYSTEM. OPS CHECK SAT.SDR JJBA20230913012Unknown · unknownCF4, FRAME 59, RH SHEAR CLIP FOUND CORRODED BTW STR 20R-21R. SHEAR CLIP REPLACEDSDR JJBA20230823023Unknown · unknownRF1 LH CRACK FOUND ON FRAME SECTION FR 68, UNDER CARGO DOOR AFT RAIL. Z FRAME REPAIRED WITH A SPLICE.SDR JJBA20230821011Unknown · unknownMAIN CABIN DOOR DIFFICULT TO OPEN. LUBRICATED MAIN CABIN DOOR. OPS CHECK GOOD.SDR JJBA20230821010Unknown · unknownLT SIDE EMERGENCY EXIT SIGN DOES NOT LIGHT UP. PERFORMED EMERGENCY LIGHTS FUNCTIONAL CHECK AND FOUND ALL LIGHTS AND SIGNS ARE OPERATIONALSDR JJBA20230821008Battery Pack · inoperativeMULTIPLE EMERGENCY EXIT SIGNS DO NOT ILLUMINATE. REMOVED AND REPLACED #4 EMERGENCY BATTERY. OPS CHECK SAT.
Back to Embraer EMB-145XR