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 JJBA20230821007Lamp · inoperativeCEILING EMERGENCY LIGHT ABOVE ROW 3 INOPERATIVE. REMOVED AND REPLACED CEILING EMERGENCY LIGHT BULB ABOVE ROW 3. OPS CHECK GOOD.SDR JJBA20230821009Unknown · unknownEMERGENCY LIGHT STRIP FWD OF 1A MISSING AND ALSO ALONG GALLEY. FOUND MISSING STRIPS AND RESECURED WITH ADHESIVE TAPE. NO DEFECTS NOTED.SDR JJBA20230821006Lamp · inoperativeMCD EMERGENCY LIGHT OUT. REMOVED AND REPLACED BULB. OPS CHECK SAT.SDR JJBA20230818005Coupling · leakingBLEED 2 LEAK ON EICAS DURING CLIMB THROUGH FL13. PERFORMED OPS CHECK OF THE AIR BLEED SYS. OPS CHECK FAILED. PERFORMED LEAKAGE CHECK. R & R SLEEVE ON DUEL TEMP CONTROLLER. R & R BOOT ON HEAT EXCHANGER EXHAUST. CLEANED AIR START ADAPTER CHECK VALVE. OPS CHECK SDR JJBA20230818004Sign · looseCENTRAL CABIN OVERHEAD FWD EMERGENCY LIGHT INOP. FOUND CONNECTOR LOOSE, RECONNECTED. OPS CHECK SATSDR JJBA20230823022Unknown · unknownAT REAR FUSE 1 EXT, BELLY SKIN FOUND CORRODED ON FR 67 AND BTW STR 20L-20R. SKIN REPAIRED WITH A DOUBLER AND INTERNAL STRAP SPLICEDSDR JJBA20230821018Unknown · unknownVERT STAB, RH SKIN DENT AT AFT OF SPAR 41% AND 1 INCH UNDER RIB ZV 2799.0. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230821017Unknown · unknownCRACKS SUSPECTED (10X) ON LH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3L-9L. AFTER NDT INVESTIGATION, 7 CRACKS FOUND, SKIN REPAIRED WITH 1 REPAIR DOUBLER AND 6 BUSHINGS.SDR JJBA20230821016Unknown · unknownCF4, MIDDLE GUSSET IN TOILET AREA BTW FR 59-61 FOUND CORRODED. AFTER GUSSET REMOVAL, OMEGA BEAM FOUND CORRODED. BEAM REPAIRED WITH A DOUBLER.SDR JJBA20230821015Unknown · unknownAT REAR FUSE 1 EXT, RADIO ALT ANTENNA NO 2 AFT LOWER DOUBLER AND BELLY SKIN FOUND CORRODED BTW FR 68-70. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230821014Unknown · unknownCF4, CORROSION FOUND ON CENTER OMEGA BEAM #6 LH FLANGE BTW FRAME 52-59. BEAM REPAIRED WITH A DOUBLERSDR JJBA20230821013Unknown · unknownCF1, CORROSION FOUND ON RH OMEGA BEAM AT FR 18 ON FLOOR STRUCTURE AREA. BEAM REPAIRED WITH A DOUBLERSDR JJBA20230821012Unknown · unknownEXISTING REPAIR TO INVESTIGATE ON LH FWD FUSE 1 SKIN, BTW FR 6-7 AND AT STR 15L, UNDER GPU ACCESS DOOR. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230804003Unknown · unknownEMERGENCY LIGHT LAMP ABOVE SERVICE DOOR INOPERATIVE. PERFORMED OPS CHECK OF THE EMERGENCY LIGHTING SYSTEM. LIGHT OPS CHECK GOOD.SDR JJBA20230804002Charger · inoperativeLH EXTERNAL FWD EMERGENCY LIGHT INOPERATIVE. SWAPPED BPS 1 CRADLE WITH BPS 3 CRADLE AND PROBLEM WAS FIXED. RETURNED TO ORIGINAL CONFIGURATION. SUSPECT BAD BPS 1 CRADLE, P.O.O. REMOVED EMERGENCY LIGHT 1 BATTERY AND CRADLE. INSTALLED NEW EMERGENCY BATTERY PACK. SDR JJBA20230803001Lamp · inoperativeMCD EMERGENCY EXTERNAL LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EMERGENCY LIGHT ASSEMBLY. OPS CHECK GOOD.SDR JJBA20230803026Panel · damagedDURING WALKAROUND FOUND DAMAGE FROM GROUND EQUIPTMENT TO AFT RIGHT SIDE OF WTF FAIRING AND FUSELAGE FURTHER AFT. MAPPED WTF PANEL #198CB FOR RTS REPAIR OR ALLOWABLE DAMAGE REQUEST. NO FURTHER DAMAGE BEHIND PANEL AND NO BLEED LEAKS. NO DAMAGE NOTED AFT OF PANELSDR JJBA20230728025Lamp · inoperativeFOUND RH FWD EXTERNAL EMERGENCY LAMP INOPERATIVE. REMOVED AND REPLACED RH FWD EXTERNAL EMERGENCY LAMP. OPS CHECK SATSDR JJBA20230728024Flap · damagedDAMAGE FROM TAXI LIGHT FALLING OFF TO FUSELAGE AFT OF NOSE GEAR AND ON LEFT I/B FLAP. REMOVED LH INBOARD FLAP. INSTALLED LH INBOARD FLAP. OPS CHECK GOOD. INSTALLED MISSING LOWER TAXI LIGHT. OPS CHECK GOOD. INSPECTED AND MAPPED DAMAGE. NO OTHER DAMAGE NOTED. ISDR JJBA20230724021Control Unit · inoperativeAT 16000 FT PITCH TRIM MAIN AND BACKUP INOPERATIVE. ALSO RUDDER 1 AND 2 INOPERATIVE. REMOVED AND REPLACED HSCU. REMOVED AND REPLACED #2 RUDDER PRESSURE SWITCH. OPS CHECK SAT FOR BOTH. PERFORMED PITOT STATIC TEST. OPS CHECK SAT.SDR JJBA20230724023Unknown · inoperativeEICAS MESSAGE IC BUS FAIL ILLUMINATED AT FL 260. REMOVED AND REPLACED #1 IC-600. OPS CHECK GOOD.SDR JJBA20230721022Unknown · unknown18A FWD EMERGENCY EXIT SIGN FACING THE WRONG DIRECTION. SWAPPED AROUND FLOOR EMERGENCY EXIT SIGNS AND FACED CORRECT WAYSDR JJBA20230721020Flashlight · odorODOR OF BURNING ELECTRICAL UPON "ON" USE OF IGNITION "ON" AT 36000 FT, BOTH IGNITERS TURNED ON. PERFORMED FIM, FOUND FLASHLIGHT ASSEMBLY HAVING SMOKE SMELL. REMOVED AND REPLACED FLASHLIGHT ASSEMBLY. OPS CHECK GOOD. NO DEFECTS NOTED. INSPECTED FUEL MODULE, INSPSDR JJBA20230721019Lamp · inoperativeMCD EMERGENCY LIGHT OUT. REMOVED AND REPLACED MCD EMERGENCY LAMP. OPS CHECK SAT.SDR JJBA20230717018Module · inoperativeEMERGENCY LIGHT WILL NOT EXTINGUISH. REMOVED AND REPLACED ICU PANEL. OPS CHECK SAT.SDR JJBA20230823021Unknown · unknownAT LH TR ASSY, AFT OUTBD SIDE, CORROSION SUSPECTED UNDER SKIN. LH TR ASSY REMOVED AND REPLACED. OPS CHECK SAT.SDR JJBA20230717016Battery Pack · inoperativeFOUND EMERGENCY LIGHTS FOR BATTERY PACK 4 TO BE INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY 4. OPS CHECK SAT.SDR JJBA20230717015Lamp · inoperativeLH OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LH OVERWING EMERGENCY LIGHT BULB. OPS CHECK SATSDR JJBA20230717014Lamp · inoperativeROW 7 AISLE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED ROW 7 AISLE EMERGENCY LIGHT BULB. OPS CHECK SAT.SDR JJBA20230717017Battery Pack · inoperativeEMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED EMERGENCY BATTERY #3. OPS CHECK SAT. NO FURTHER DEFECTS NOTED.SDR JJBA20230717013Seal · leakingABOVE 15,000 FT MCD STARTED VERY LOUD WHISTLE NOISE THAT DIDN’T STOP UNTIL BELOW 10,000 FT. REMOVED AND REPLACED MAIN DOOR FRAME RUBBER SEAL. PRESSURIZED AIRCRAFT. NO LEAKS NOTED COMING FROM MCD.SDR JJBA20230712012Unknown · unknownLOUD WHISTLING COMING FROM MCD ABOVE FL 180 UNTIL DESCENDED BELOW 10000 FT. PERFORMED PRESSURIZATION CHECK. FOUND MULTIPLE LEAKS & MARKED W/TAPE. RESEALED LEAKING AREA. PERFORMED MANUAL PRESSURIZATION PROCEDURE. NO FURTHER LEAKS FROM MCD NOTES AT THIS TIME.SDR JJBA20230712011Unknown · unknownLOUD WHISTLE AND AIR FLOW COMING NEAR CA DV WINDOW IN CRUISE. PRESSURIZATION DIFFICULT TO CONTROL IN AUTO/MAN MODE. PRESSURIZED A/C. OPS CHECK PASSED. INSPECTED CA DV WINDOW AND FOUND MULTIPLE DISCREPANCIES ON FWD SEAL. REMOVED AND PREPPED SURFACE FOR SEAL ANDSDR JJBA20230712009Unknown · unknownMAIN CABIN DOOR EMERGENCY EXIT LIGHT DOES NOT WORK. RESECURED FWD CABIN EMERGENCY DOOR LIGHT CONNECTORS. OPS CHECK GOODSDR JJBA20230710008Unknown · unknownTOP OF MAIN CABIN DOOR IS NOT CLOSED FLUSH AT EXTERIOR. PERFORMED MCD TO FUSELAGE SKIN STEP MEASUREMENTS AND FOUND POINT 12 OUT OF LIMITS BY APPROX. NO OTHER DEFECTS FOUND. COMPLETED GVI OF TOP OF MCD AND MEASURED POINT 12. NO DEFECTS NOTED ALSO, COMPLETED PRESDR JJBA20230710007Control Unit · inoperativeNO BRAKES ON LANDING BRAKE INB INOPERATIVE MESSAGE FLASHED ON EICAS. REMOVED AND REPLACED #2 & 3 BRAKES. REMOVED AND REPLACED BCU. OPS CHECK SAT. BOTH LEFT AND RIGHT INB TIRES BLOWN. REMOVED AND REPLACED #1, 2, 3, AND 4 MLG TIRES. TAXI CHECK SAT.SDR JJBA20230712010Unknown · unknownQTY (1) HOLE BORE IS NICKED, C/TO RH WING SPAR 3/TORQUE BOX #1 ATTACHMENT LOWER POSITION #2. HOLE OVERSIZED.SDR JJBA20230710006Unknown · unknownMAIN CABIN DOOR HARD TO OPEN. LUBED MCD & OPS CHECKED GOODSDR JJBA20230705001Unknown · unknownMAIN CABIN DOOR WON'T OPEN. ADJUSTED MAIN CABIN DOOR TRIM ON UPPER FWD SIDE.SDR JJBA20230703027Lamp · unknownLH OVERWING EMERGANCY LIGHT OUT R+R BULB OPS CHECK SATSDR JJBA20230703026Lamp · noneLH EMERGENCY EXIT OVERHEAD LIGHT INOP R/R LH EMERGENCY EXIT OVERHEAD LIGHT BULB. OPS CHECK SATSDR JJBA20230703022Actuator · leakingFLAP FAIL ON EICAS AFTER FLAPS RETRACTED. RETRACTING THE FLAPS FROM 9 TO 0 AND IMMEDIATELY RECEIVED FAIL AND THE INDICATION DASHED OUT AND KEPT THE AIRCRAFT BELOW 250 KNOTS. CREW REPORTED NO HARD OR OVERWEIGHT LANDING "REPLACED FPDU. REPLACED FECU. PERFORMED ZSDR JJBA20230626021Control Unit · inoperativeSTRONG FUEL SMELL THROUGHOUT CABIN AND FLIGHT DECK ON GROUND AND IN AIR. REMOVED AND REPLACED APU FUEL CONTROL UNIT. OPS CHECK SAT ALSO PACK 1 AND 2 RUNNING NO FUEL SMELL NOTED.SDR JJBA20230626019Acm · overheatedACRID SMELL AND POTENTION SMOKE IN THE COCKPIT NOTICED BY FLIGHT CREW ON DECENT. TROUBLESHOOT ABNORMAL SMELL IN CABIN/COCKPIT. FOUND PACK 1 EXHAUST SMOKEY, AND NOT VERY HOT, ALSO FOUND PACK 1 TO BE VERY LOUD. REMOVED AND REPLACED ACM. OPS CHECK SAT. NO FURTHERSDR JJBA20230626020Stop · inoperativeMAIN CABIN DOOR STUCK IN CLOSED POSITION. REMOVED AND REPLACED DOOR STOPPER ASSEMBLY. OPS CHECK SAT. NO OTHER DEFECTS NOTED AT THIS TIME.SDR JJBA20230628025Unknown · unknownAT REAR FUSE 1 INT, RADIO ALT ANTENNA NO 2 AFT LOWER DOUBLER AND BELLY SKIN FOUND CORRODED BTW FR 68-70. SKIN REPAIRED WITH A DOUBLER.SDR JJBA20230705002Unknown · unknownAT CF IV AREA, CORROSION FOUND ON MIDDLE GUSSET UNDER TOILET AREA BTW FR 59-61. MIDDLE GUSSET REPLACED WITH NEW ONE. FOLLOWING REMOVAL OF GUSSET, OMEGA BEAM FOUND CORRODED. BEAM REPAIRED WITH 2 DOUBLERSSDR JJBA20230628024Unknown · unknownCF1, EXTERNAL SKIN, DENT FOUND BTW FRAME 17-19 AND BELOW STR 11R. SKIN REPAIRED WITH A DOUBLERSDR JJBA20230628023Unknown · unknownCF1, CRACK FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BTW FR 23-24. BEAM REPAIRED WITH A DOUBLER.SDR JJBA20230616011Unknown · unknownWING EMERGENCY EXIT LIGHT INOPERATIVE. OPS CHECKED EMERGENCY EXIT LIGHT GOOD
Back to Embraer EMB-145XR