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 JJBA20230227017Inverter · inoperativeEMERGENCY LIGHT ABOVE FA JUMP SEAT INOPERATIVE, EXIT LIGHT. REMOVED AND REPLACED DC/AC INVERTER. OPS CHECK SAT.SDR JJBA20230227016None · noneDAMAGE TO FUSELAGE UPON TOP XPDR NUT PLATE REMOVAL @ FRAME 22. REMOVED NUT PLATE DOUBLER. INSTALLED NEW NUT PLATE ON DOUBLER. CUT-OUT DAMAGED SECTION AND STARTED FABRICATION OF REPAIR DOUBLER AND FILLER AND BEGAN MATCH DRILLING TO AIRCRAFT. FINISHDED FABRICATISDR JJBA20230227015Lamp · inoperativeAISLE EMERGENCY LIGHTS 3, 4 AND 18CD INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT LAMPS. OPS CHECK SATSDR JJBA20230309012None · noneREPAIR DOUBLER TO REWORK ON CENTER FUSE 4 UPPER SKIN, BTW FR 56-57 AND BTW STR 2L-1R. REPAIR DOUBLER ON CENTER FUSE 4 UPPER SKIN, BTW FR 56-57 AND BTW STR 2L-1RSDR JJBA20230220014None · noneEMERGENCY PATH STRIP NEAR 1A NOT SECURED. CLEAN RESIDUAL TAPE AND DUST. APPLY DOUBLE SIDE TAPE AND RESECURED EMERGENCY LIGHT STRIP IN ROW 1ASDR JJBA20230217013Actuator · inoperativePITCH TRIM MAIN INOPERATIVE EICAS MESSAGE BOTH CAPT AND FO SIDE INOPERATIVE. REMOVED AND REPLACED HORIZONTAL STABILIZER ACTUATOR. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR JJBA20230217012None · noneSMOKE COMING FROM SINK IN THE LAV ELECTRICAL BURNING SMELL. FOUND BOTH POT WATER DRAIN HEATERS WORKING NORMALLY. SUSPECT SINK DRAIN HEATER OR ASSOCIATED WIRING. PULLED AND COLLARED CB E-11. INSPECTED WIRING BEHIND AND UNDER LAV SINK COMPARTMENT AND FOUND SMELLSDR JJBA20230213011Lamp · inoperativeLH EXTERNAL EMERGENCY FWD LIGHT INOPERATIVE. REMOVED AND REPLACED LH EXTERNAL FWD EMERGENCY LIGHT BULB. OPS CHECK SATSDR JJBA20230213010Unknown · unknownEXTERNAL SERVICE DOOR EMERGENCY LIGHT INOPERATIVE. INSTALLED BULB CORRECTLY. OPS CHECK SATSDR JJBA20230208007Not Reported · not reportedEMERGENCY FLOOR LIGHT STRIP DETACHED AT 1A. REATTACHED EMERGENCY FLOOR STRIP LIGHT SEAT 1A.SDR JJBA20230213005Unknown · inoperativeMAIN CABIN DOOR DIFFICULT TO OPEN. REMOVED AND REPLACED NUTPLATE. REMOVED AND REPLACE MCD BOX ASSEMBLY. ADJUSTED MAIN CAIN DOOR FOLDING FLAP. FUNCTIONAL TEST FOR CABIN LEAKAGE SAT. NO FURTHER DEFECTS AT THIS TIME.SDR JJBA20230208006Not Reported · not reportedMAIN CABIN DOOR WONT OPEN. FOUND HANDLE TO NOT BE IN THE FULL OPEN POSITION, FULLY OPERATED HANDLE TO OPEN, DOOR OPERATES AS INTENDED OPENED AND CLOSED DOOR 10 TIMES WITH NO FAULTS.SDR JJBA20230208003Not Reported · not reportedSUPPLEMENTAL (NEW) INFORMATION: REMOVED AND REPLACED MAIN DOOR SEAL FOUND ORIGINAL SEAL TO BE UNEVENLY PLACED AT SEAL TRACK UPTO PRESS LEAK CHECK. OPS/LEAK CHECK GOOD.SDR JJBA20230206004Display · burnedEICAS WENT BANK. LOSS OF ELECTRICAL POWER TO EICAS. REMOVED EICAS DISPLAY UNIT, FOUND BURNING SMELL COMING FROM EICAS DISPLAY UNIT. OPS CHECK DONE, NO FURTHER BURNING SMELL DETECTED.SDR JJBA20230206002Not Reported · not reportedMAIN CABIN DOOR WILL NOT CLOSE. RESECURED LOOSE SCREW CAUSING DOOR TO JAM. OPS CHECK GOODSDR JJBA20230303003None · noneDENTS ON CENTER FUSE I LOWER SKIN, BTW FR 17-19 AND BTW STR 21L-21R. ON CENTER FUSE I, LOWER SKIN, BTW STR 21L-21R DENT FOUND OUT OF LIMIT. ON CENTER FUSE 1, LOWER SKIN BTW FR 17-19 AND BTW STR 21L-21R DENT REPAIRED WITH A DOUBLER. SURFACE REPROTECTION COVEREDSDR JJBA20230208009Not Reported · not reportedCF1, CORROSION FOUND ON RH OMEGA BEAM AT FR 23 ON FLOOR STRUCTURE AREA. CORROSION ON RH OMEGA BEAM AT FR 23 AROUND NUTPLATE BLENDED OUT OF LIMTIS. RH OMEGA BEAM AT FR 23 ON FLOOR STRUCTURE REPAIREDSDR JJBA20230206001Door · damagedRH MLG AUX DOOR HAS COMPOSITE DAMAGE ON STIFFNER. RAR RH MLG AUX DOOR. ALL GAP CHECKS GOOD. GEAR SWINGS PERFORMED. ALL OPS CHECKS SAT.SDR JJBA20230208008Not Reported · not reportedDENT ON LH CENTER FUSE 1 SKIN, BTW FR 22-23 AND BTW STR 12L-13L. ON LH CENTER FUSE 1, DENT BTW FR 22-23 AND BTW STR 12L-13L FOUND OUT OF LIMITS. LH CENTER FUSE, BTW FR 22-23 AND STR 12L-13L EXTERNAL SKIN, DENT REPAIRED WITH A DOUBLER.SDR JJBA20230206026Not Reported · not reportedFUEL SMELL IN CABIN. LEAK FOUND AT LEFT WING INBOARD AFT LOWER CORNER. LEAK CHECK GOOD.SDR JJBA20230130022Lamp · inoperativeFWD MOST CEILING LINING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FORWARD AISLE CEILING EMERGENCY LIGHT BULB. OPS CHECK GOOD.SDR JJBA20230131024Engine · contaminatedSMOKE IN FLIGHT DECK AND FORWARD CABIN AFTER DEPARTURE. FOUND EVIDENCE OF DE-ICE FLUID IN BOTH ENGINES AND COWLING. CLEANED AREA, PERFORMED ENGINE RUNS. OPS CHECK SAT.SDR JJBA20230130023Bulb · dimMAIN DOOR EMERGENCY LIGHT IS DIM AND FLICKERS. REMOVED AND REPLACED MAIN DOOR EMERGENCY LIGHT BULB. OPS CHECK GOODSDR JJBA20230123017Lamp · inoperativeFWD MOST CENTER AISLE CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT BULB AT FWD MOST CEILING LINING EMERGENCY LIGHT. OPS CHECK SAT.SDR JJBA20230123013Windshield · crackedFO W/S SPIDER WEB CRACKED DURING FLIGHT. REMOVED AND REPLACED FO'S WINDSHIELD. OPS CHECK SAT AT THIS TIME.SDR JJBA20230119016Battery Pack · inoperative#1 EMERGENCY LIGHT BATTERY INOPERATIVE. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY. OPS CHECK SATSDR JJBA20230119015Lamp · inoperativeMCD EXTERNAL EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED MCD EXTERNAL EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20230119014Warning Message · false activationE1 HYD LO QTY IN FLIGHT. FOUND HYD SYSTEM #2 AT MAX CAPACITY. GVI OF HYD BAYS, NO LEAKS NOTED. TRANSFERRED FLUID FROM SYS 2 TO 1, RAN BOTH ENGINES. NO LEAKS NOTED AND NO INDICATION OF AIR IN SYSTEM. SERVICED BOTH HYD SYSTEMS. TAXI, STEERING AND BRAKE SYSTEM CHSDR JJBA20230130021Floor Support · corrodedCF 3, LH OMEGA BEAM #6 INBD FLANGE BTWN FRAME 47-53 FOUND CORRODED. CF3, LH OMEGA BEAM #6 INBD FLANGE BLENDED OUT OF LIMITS. CF3, LH OMEGA BEAM TRIM REMOVED FOR ACCESS. AT CF3, LH OMEGA BEAM #6 INBD FLANGE BTW FR 47-53 REPAIR COMPLETE AND OMEGA BEAM TRIM REINSSDR JJBA20230130018Frame · crackedCF 4, FRAME 59, LH FRAME SECTION FOUND CRACKED BTW STR 15L-16L. CF4, FR59, LH FRAME SECTION SPLICE BTW STR 14L-16L REMOVED FOR ACCESS. CF4, FR59, LH FRAME SECTION BTW STR 15L-16L CRACK REMOVED AND FRAME REPAIREDSDR JJBA20230130025Lamp · not seatedEMERGENCY EXIT SIGN INOPERATIVE AT 18A. RESEATED EMERGENCY EXIT LAMP AT 18A. OPS CHECK SAT.SDR JJBA20230130020Skin · damagedFWD FUSELAGE EXT, DAMAGE FOUND ON LH SIDE SKIN BTW FR 9-10 AND BTW STR 13L-15L. FWD FUSELAGE EXT, L SIDE SKIN BTW FR 9-10 AND BTW STR 13L-15L, DAMAGE BLENDED FOUND OUT OF LIMITS. REMAINING THICKNESS 0.053" ON NOMINAL 0.063. FWD FUSELAGE EXT, LH SIDE SKIN BTW FSDR JJBA20230130019Floor Support · crackedCF2, LH OMEGA BEAM #3 CRACKS SUSPECTED FOUND AT FRAME 33-34 ON FLOOR STRUCTURE. AFTER NDT INSPECTION, TWO CRACKS CONFIRMED ON LH OMEGA BEAM #3 AT FR33 AND FR 34 NEED TO BE REPAIRED. CF2, LH OMEGA BEAM CRACK AT FR 33,34 REPAIREDSDR JJBA20230116011Lamp · inoperativeSEAT 18A EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SEAT 18A EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20230116012Light · detachedEMERGENCY FLOOR LIGHTING STRIP CAME OFF SEAT 1A. RESECURED EMERGENCY FLOOR LIGHTING STRIPSDR JJBA20230116010Battery Pack · inoperativeMULTIPLE INTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BPS #3. OPS CHECK OF ALL CORRESPONDING LIGHTS GOODSDR JJBA20230116009Control Panel · smokeSMOKE FROM LEFT CORNER ON OVERHEAD PANEL DURING POWER ON. REMOVED AND REPLACED FUEL CONTROL PANEL. OPS CHECK SAT.SDR JJBA20230109007Pump · inoperativeHYD 2 LOW QTY ON EICAS. REMOVED #2 ENGINE DRIVEN HYD PUMP. REMOVED #2 ENGINE DRIVEN HYD PUMP MAGENTIC CARBON SEAL ASSEMBLY. INSTALLED #2 ENGINE DRIVEN HYD PUMP. INSTALLED #2 ENGINE DRIVEN HYD PUMP MAGNETIC CARBON SEAL. OPS AND LEAK CHECK SAT.SDR JJBA20230109006Engine · contaminatedSMOKE IN COCKPIT ON TAKE OFF DURING CLIMB OUT. FOUND DEICING FLUID IN ENGINE INLETS. CLEANED FLUID AND PERFORMED HIGH POWER RUNS WITH CREW. NO SMOKE OR ABNORMAL SMELL NOTED.SDR JJBA20230106005Charger · inoperativeLH EXTERIOR FORWARD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXTERIOR EMERGENCY LIGHT LAMP. OPS CHECK FAILED. TROUBLESHOT TO #1 EMERGENCY LIGHT BATTERY AND CHARGER ASSEMBLY INOPERATIVE. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY. REMOVED AND REPLSDR JJBA20230106004Battery Pack · inoperativeFOUND RH EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY POWER SUPPLY #2. OPS CHECK SAT AT THIS TIMESDR JJBA20230103003Light · detachedEMERGENCY LIGHTING STRIP ON THE FLOOR BY SEAT 1A IS DETACHED. RESECURED 1A LIGHT STRIP.SDR JJBA20230106001Sleeve · misinstalledSTAB ANTI-ICE EICAS MESSAGE POSTED IN FLIGHT. DURING APPROACH AND ICE CONDITION ANTI-ICE INOPERATIVE MESSAGE APPEARED. CMC MSG "STAB A/I LEAK" AND "STAB A/I VLV FAIL" PRESENT. STARTED PERFORMING INSTALLATION OF LEAK TEST KIT FOR HORIZONTAL STAB VERTICAL DUCTSSDR JJBA20230103002Placard · detachedEMERGENCY EXIT PLACARD ROW 18 SCREWS CAME OFF. RESECURED LT EMERGENCY EXIT PLACARD.SDR JJBA20230109008Floor Support · crackedCF 3, LH OMEGA BEAM, CRACK SUSPECTED AT FRAME LOCATION 36, 37. CRACK (1X) FOUND ONLY AT FR36. NO MORE ACTION AT FRAME 37. LH OMEGA BEAM REPAIRED WITH ANGLE AT FR 36SDR JJBA20230103035Floor Support · crackedCF 2, UNDER FLOOR, LH OMEGA BEAM CRACK SUSPECTED AT FRAME 33-35. LH OMEGA BEAM REPAIRED AT FR 33-35 WITH A DOUBLER AND FILLERSDR JJBA20221230030A/C Pack · odorBAD ODOR COMING FROM PACKS. PERFORMED DECONTAMINATION OF AIR CONDITIONING SYSTEM. NO FURTHER ODORS NOTED.SDR JJBA20221229028Switch · faultedSMOKE AND BURNING SMELL IN COCKPIT. FLAMES VISIBLE BETWEEN #1 FIRE HANDLE AND FUEL PANEL. FLAMES EXTINGUISHED BY THEMSELVES. SMOKE AND ODOR STILL PRESENT. INSPECTED AND FOUND "CROSS FEED" BREAKER POPPED. REMOVED OVHD PANEL AND FOUND CROSS FEED SWITCH BURNT. INSDR JJBA20220103034Bulb · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE AT ROWS 18 AND 22. REMOVED AND INSTALLED LIGHT BULBS AT ROWS 18 AND 22. OPS CHECK GOODSDR JJBA20220103033Light · inoperativeRH EXTERIOR OVERWING EMERGENCY LIGHT IS INOPERATIVE. RH EXTERNAL OVERWIN EMERGENCY LIGHT REMOVED AND REPLACED. OPS CHECK GOOD. NO DEFECTS NOTED AT THIS TIME
Back to Embraer EMB-145XR