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 JJBA20220801035Light · inoperativePHOTOLUMINESCENT STRIP NEAR GALLEY LOOSE. RESECURED PHOTOLUMINESCENT STRIPSDR JJBA20220919017None · noneCORROSION IN SEVERAL LOCATIONS AS MARKED ON RH FLOOR BEAMS BETWEEN FRAME 20 AND FRAME 24 AT Y = +17. REMOVED PREVIOUS REPAIR ON SEAT TRACK RH FLOOR BEAM FRAME 20 AND INSTALLED NEW REPAIR DOUBLERS.SDR JJBA20220808007Skin Panel · corrodedFFI LH EXT SKIN, DENT FOUND AT FR 2 AND BTW STR 15L-17L. DENT ON LH SKIN AT FR FOUND OUT OF LIMITS. FF LH EXT SKIN AT FR 2 AND BTW STR 15L-17L, REPAIR DOUBLER MADE AND INSTALLED.SDR JJBA20220808006Doubler · crackedCORROSION SUSPECTED ON LOWER SKIN UNDER FWD RAD ALT ANTENNA DOUBLER. LOWER SKIN UNDER FWD RAD ALT #2 EXT ANTENNA DOUBLER BLENDED FOR INVESTIGATION (FOUND CORROSION). CUT-OUT C/OUT ON LOWER SKIN UNDER FWD RAD ALT #2. LOWER SKIN BTW FR 64-66 AND BTW STR 20L-20R SDR JJBA20220728030Light · inoperativeEMERGENCY STRIP WALL LIGHTING ROW 1 LOOSE. RESECURED EMERGENCY STRIPSDR JJBA20220801039Rivet · corrodedLH TR MODULE EXTERNAL SKIN SHOW SIGN OF SMOKING RIVET. RIVETS REPLACED AND LH TR MODULE EXTERAL LOWER AFT SKIN REPAIREDSDR JJBA20220728034Panel · missingLEFT SIDE EMERG EXIT PANEL FALLING OFF. RESECURED LEFT EXIT HANDLE COVERSDR JJBA20220728032Sign · missingEXIT MARKER ON THE AFT SIDE OF THE LH EXIT ROW IS MISSING. FOUND EXIT MARKER UNDER CARPET RESECURED EXIT MARKER AND CARPET AS REQUIREDSDR JJBA20220728031Light · inoperativeEXIT SIGN AFT OF RHA ESCAPE HATCH IS NOT SECURED. RESECURRED RH ESCAPE HATCH EXIT MARKING SIGN ASSY FRAME. NO FURTHER DEFECTS NOTED.SDR JJBA20220728033Light · inoperativeEMERGENCY FLOOR STRIP LIGHTING POTENTIALLY IN INCORRECT POSITIONS. REINSTALLED EMERGENCY FLOOR STRIP TO CORRECT LOCATIONSSDR JJBA20220824025None · noneCF2, L/H OMEGA BEAM #2 FOUND CRACKED AT 3 LOCATIONS ON INBD FLANGE. AFTER INVESTIGATION, 5 CRACKS FOUND. BEAM REPAIRED WITH 5 DOUBLERS.SDR JJBA20220728029Galley · inoperativeBURNING SMELL FROM GALLEY IN FLIGHT. NO SMELL AFTER COFFEE MAKERS OFF ON THE GROUND. PERFORMED OPERATIONAL CHECK ON COFFEE MAKERS, COULD NOT FIND BURNING SMELL IN THE GALLEY. R&R BOTH COFFEE MAKERS. OPS CHECK GOOD, BURNING SMELL NOT PRESENT
RH - PN 500-0640SDR JJBA20220801038Floorbeam · crackedCF 1 LH OMEGA BEAM FOUND CRACKED AT FR 22 & 23. 2 REPAIR DOUBLERS ON LH CENTER FUSE 1 OMEGA BEAM, ON INBD FLANGE AT FR 22 & 23SDR JJBA20220801037Bear Strap · crackedCFII, CRACK FOUND ON LH OMEGA BEAM AT FR 24 AND FR 25. 2 REPAIR DOUBLERS ON LH CENTER FUSE 2 OMEGA BEAM, ON INBD FLANGE AT FR 24 & 25SDR JJBA20220725028Door · lack of lubeMAIN CABIN DOOR IS HARD TO OPEN FROM THE INSIDE. PERFORMED OPS CHECK OF MAIN CABIN DOOR. NO DEFECTS NOTEDSDR JJBA20220721027Light · inoperativeMCD EMERGENCY LIGHT INOP. R/R MCD EXTERNAL EMER. LIGHT ASSY. OPS CHECK SATSDR JJBA20220721026Light · inoperativeAFT EXIT SIGN AT EMERGENCY EXIT ROW INOP. R&R EXIT SIGN AT EMERGENCY EXIT ROW. OPS CHECK FAIL. FOUND INVERTER TO BE BAD R&R INVERTER. OPS CHECK SATSDR JJBA20220721025Light · inoperativeLIGHT STRIP ON FLOOR INOP ON ROW 1-3. R&R EMERGENCY LIGHT STRIP BETWEEN ROW 1 - 3SDR JJBA20220721021Bulkhead · crackedAT LH MLG WHEEL WELL, AFT BULKHEAD CRACKED AT 2 PLACES. INNER REINFORCEMENT ANGLE ON LH WING STUB SPAR 3 (WHEEL WELL AFT BULKHEAD) FAIRING ATTACHMENT ANGLE.SDR JJBA20220721024Proximity Switch · failedLANDING GEAR AIR/GROUND SYSTEM FAILURE. EICAS MSG LG AIR/GND FAIL APPEARED AFTER TAKEOFF. LG WOULD NOT RETRACT. HANDLE WOULD NOT MOVE. REMOVED AND REPLACED NOSE GEAR "WOW" PROX SWITCH -PERFORMED OPS CHECK, OPS CHECK GOODSDR JJBA20220721023Light · inoperativeRH EXTERNAL LOWER EMERGENCY LIGHT RETAINER ASSY NOT FLUSH WITH FUSELAGE AND IS MISSING SEALANT. R&R EXTERNAL LOWER EMERGENCY LIGHT ASSEMBLY. OPS CHECK SAT.SDR JJBA20220719016Latch · stickingMCD LATCH STUCK. OPENED AND CLOSED DOOR 15 TIMES AS REQUIRED. NO DEFECTS NOTED AT THIS TIMESDR JJBA20220719015Battery Pack · inoperativeFOUND BOTH OVERWING EMERGENCY LIGHTS INOP. SUSPECT BATTERY #4 IS NOT HOLDING A CHARGE. R&R EMERGENCY LIGHT BATTERY POWER SUPPLY #4SDR JJBA20220919020None · noneCORROSION ON AISLE LH FLOOR OMEGA BEAM STARTING AT FR46, UNDER FLOOR PANEL 251FF. REPAIRED LH FLOOR OMEGA BEAM STARTING AT FR46 UNDER FLOOR PANEL 251FF.SDR JJBA20220919016None · noneCORROSION ON LAV FLOOR OMEGA BEAM AT FR59 Y+0. REPAIRED LAV FLOOR OMEGA BEAM AT FR59-61 Y+0SDR JJBA20220719014Light · inoperativeEXIT MARKING SIGN INOP IN ROW 3CD. R&R EMERGENCY EXIT SIGN IN ROW 3. OPS CHECK SATSDR JJBA20220719013Gear · unlatchedLG AIR /GND FAIL IN FLIGHT. R&R LEFT MLG FORWARD PROX SWITCH & RIGHT MLG AFT PROX SWITCH. PERFORMED GEAR SWINGS WITH BREAK OUT BOXSDR JJBA20220721022Frame · crackedRF1 LH FRAME 68 CRACKED ABOVE FLOOR LEVEL. RF1 LH CRACKED FRAME 68 REPAIRED.SDR JJBA20220719012Panel · misusedRH OVER WING EXTERNAL EMERGENCY LIGHT INSTALLED UPSIDE-DOWN. RE-ORIENTATED RH OVER WING EXT EMERGENCY LIGHT.SDR JJBA20220713011None · noneDURING DECENT, AT APPROX 13000 FT, STRONG FUEL BURNING SMELL PRESENT IN COCKPIT AND FORWARD SECTION OF CABIN. C/W EMB 145 FIM TASK FOR ABNORMAL SMELL AND RR FIM TASK FOR OIL OR FUEL BURNING SMELL C/W RR FIM`S 72-00-00-990-801 & 72-00-00-810-814. NO FAULTS FOUNSDR JJBA20220711009None · noneEMERGENCY LIGHTING STRIP UNATTACHED FROM FLOOR. (FWD RIGHT). RESUCURED EMER LIGHT STRIPSDR JJBA20220711008Lamp · inoperativeLH FORWARD EXTERNAL EMERGENCY LIGHT INOP. R/R LH FORWARD EXTERNAL EMERGENCY LIGHT LAMP. OPS CHECK SATSDR JJBA20220711007Lamp · inoperativeRH FWD WTF EMERGENCY LIGHT INOP. R/R FWD WTF EMERGENCY LIGHT LAMP. OP CHECK SATSDR JJBA20220711010None · noneEMERG EXIT OVERHEAD SIGN NOT PROPERLY CONNECTED (AISLE AFT FACING). RESECURED MERG EXIT SIGN OVERHEAD AT EXIT ROWSDR JJBA20220711006Battery Pack · inoperativeEMERGENCY LIGHT OVER WING ROW 18 INSIDE INOP. REMOVED AND REPLACED #3 EMERGENCY LIGHT BATTERY OPS CHECK SAT.SDR JJBA20220707004None · inoperativeSERVICE DOOR EXTERNAL EMERGENCY LIGHT INOP R/R SERVICE DOOR EXTERNAL EMERGENCY LIGHT ASSY. OPS CHECK SATSDR JJBA20220707003Lamp · inoperativeEMERGENCY LIGHT OVER SEAT 18A INOP. R/R EMERGENCY LIGHT LAMP OVER SEAT 18A. OPS CHECK SAT.SDR JJBA20220706002Lamp · inoperativeEMERGENCY LIGHT AT CELING PANEL 243DLC INOP. R/R EMERGENY LIGHT LAMP AT CELING PANEL 243DLCSDR JJBA20220721020Skin Panel · corrodedCORROSION FOUND ON INTERNAL SKIN AN ANTENNA DOUBLER BTW STR 21L-21R BTW FR 68-69. AFTER CORROSION INVESTIGATION ON SKIN AT ANTENNA LOCATION BTW FR 68-69 AND STR 21L-21R CRACKS FOUND AROUND RIVET HOLE AND REPAIR IS REQUIRED. SKIN AT FR 68-69 BTW STR 21-21R REPASDR JJBA20220721019Skin Panel · dentedVERT STAB LH SKIN DENT BETWEEN SPAR 1 AND SPAR 2 AND BETWEEN RIB ZV 1423 AND RIB ZV 1677. VERT STAB LH SKIN SPAR 1 AND 2 AND BTW RIB ZV1423 AND ZV1677 PAINT STRIPPED. VERT STAB LH SKIN BTW SPAR 1 AND 2 AND BTW RIB ZV 1423 AND ZV 1677. DAMAGE CUTOUT DONE. VERT SDR JJBA20210721018Skin Panel · dentedLIGHTNING STRIKE SUSPECTED UNDER SERVICE DOOR BTW FR 20-21 AND STR 17-18. AFTER INVESTIGATION, NO LIGHTNING STRIKE FOUND. DAMAGE ON SKIN RH SIDE UNDER SERVICE DOOR IS A NICK BLENDED OUT OF LIMITS. DAMAGE REMOVED BY CUTOUT ON RH SKIN BTW FR20-21 AND BTW STR 17-SDR JJBA20220706001Engine · unknownPACK #1 PRODUCED STRONG SMELL OF FUMES IN FLIGHT. TOTAL TIME (HOURS) HAS BEEN CORRECTED TO 44729.3SDR JJBA20220629024None · depletedCEILING EMERGENCY LIGHT AT MAIN WING EMERGENCY EXITS AFT SIDE IS INOPERATIVE. CHARGED EMERGENCY LIGHT BATTERIES BY ARMING THE SYSTEM. OPS CHECK OF CEILING EMERGENCY LIGHT AT AISLE AFT SIDE SATSDR JJBA20220629023Lamp · inoperativeEMERGENCY LIGHT ON STEP TO COCKPIT IS INOP. CHECKED VOLTAGE AT CONNECTOR TO EMERGENCY LIGHT ON COCKPIT STEP AND GOT ZERO VOLTS. REMOVED EMERGENCY BATTERY NO.1 FROM CRADLE AND MEASURED VOLTAGE TO BE 8.01 VOLTS, INSTALLED NO. 1 BATTERY, DISCONNECTED CANNON PLUGSDR JJBA20220629030None · inoperativeEMERGENCY EXIT SIGN ABOVE FA CHAIR INOPERATIVE. REMOVED AND REPLACED EMERGENCY EXIT SIGN. OPS CHECK FAIL. REINSTALLED ORIGINAL EXIT SIGN. REMOVED AND REPLACED INVERTER. OPS CHECK SATSDR JJBA20220629026Battery Pack · inoperativeEMERGENCY LIGHTS AT EMERGENCY EXIT DOOR INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES #3 AND #4. OPS CHECK SAT
#3 - ABS-2013-1A SN 53157 TSN 31901.12 - CSN 23546 - TIME SINCE INSPECTION 30302.01SDR JJBA20220629025Battery Pack · inoperativeFOUND BOTH RH AND LH ESCAPE HATCH EXIT IDENTIFIER SIGN LIGHTS NOT WORKING. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY #3. OPS CHECK SATSDR JJBA20220627022Proximity Switch · unknownLG AIR GND FAIL AS GEAR UP WAS SELECTED DURING CLIMB OUT. DISCONNECTED BOTH LH AND RH MLG WOW PROX SWITCHES. INSPECTED FOR SIGNS OF CORROSION ON SWITCHES AND CANNON PLUGS. NO CORROSION FOUND AT THIS TIME, CLEANED OUT CANNON PLUGS. OPS CHECK ALL 4 SWITCHES. ALLSDR JJBA20220626021None · noneEMERGENCY EXIT SIGN LOOSE 18A. RESECURED 18A EMERGENCY SIGN.SDR JJBA20220624031None · noneAT REAR FUSE II EXT, SUSPECTED CRACKS (9X) FOUND ON RIGHT SIDE SKIN BTW FR 77 - FR 78 AND BTW STR 3R - 9R. REPAIR DOUBLER ON RH REAR FUSE 2 SKIN, ON FR 78 BTW STR 5R-7R. EXTERNAL DETAILED VISUAL INSPECTION, AT REPAIR, INTERVAL OF 30000 FC
Back to Embraer EMB-145XR