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 JJBA20231019033Unknown · unknownCF4, LH FRAME 59 IN LAVATORY AREA BTW STR 15L-16L FOUND CRACKED. EXTENDED SPLICE REPAIR ON LH CENTER FUSE 4 FRAME 59, BTW STR 14L-16LSDR JJBA20231019029Unknown · unknownCF3, CRACKS (2X) FOUND ON LH OMEGA BEAM #4 FLOOR STRUCTURE BTW FR 35-39. AFTER NDT INSPECTION, CRACK FOUND AT FR 36 & 37. BEAM REPAIRED WITH 2 DOUBLERSDR JJBA20231018021Unknown · unknownSURFACE CORROSION AROUND SCREW HOLES OF MAIN DOOR LOWER BEAM LINING ATTACHMENT. BEAM REPAIRED WITH 2 DOUBLERSSDR JJBA20231019036Unknown · unknownCF1 EXT, DENT FOUND ON MAIN DOOR SKIN LOWER OF STR 15L AFT CORNER EDGE. DENT REDRESSEDSDR JJBA20231019034Unknown · unknownCRACKS SUSPECTED (13X) ON LH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3L-9L. AFTER NDT INSPECTION, 11 CRACKS FOUND. SKIN REPAIRED WITH 11 BUSHINGSSDR JJBA20231019031Unknown · unknownCRACKS SUSPECTED (8X) ON RH SKIN AROUND FASTENERS BTW FR 77-80 BTW STR 3R-9R. SKIN REPAIRED WITH 16 BUSHINGS AND 1 REPAIR DOUBLERSDR JJBA20231018025Unknown · unknownRF1 EXT, CRACK FOUND BY NDT INSPECTION ON RH TOP SKIN AT FR 75 BTW STR 1R-3R. SKIN REPAIRED WITH A DOUBLERSDR JJBA20231018024Unknown · unknownVERT STAB LH SKIN DENT BETWEEN SPAR 2 AND AUX SPAR 41% AND BETWEEN RIB ZV 915 AND RIB ZV 1169. SKIN REPAIRED WITH A DOUBLERSDR JJBA20231018019Unknown · unknownRF1, LH FR68 BOTTOM FRAME 68 SECTION FOUND CRACKED LOWER HOLDER BRACKET. Z FRAME REPAIRED WITH A SPLICE.SDR JJBA20231018018Unknown · unknownCF1, CRACKS (4X) FOUND ON LH OMEGA BEAM #1 FLOOR STRUCTURE BTW FR 18-24. AFTER NDT INSPECTION, 3 CRACKS AND 2 CORROSION SPOT FOUND. BEAM REPAIRED WITH 5 DOUBLERSSDR JJBA20231018016Unknown · unknownNLG W/WELL, MISDRILLED DONE ON TOP SHELF ASSEMBLY DURING REPLACEMENT PROCESS. PLATE REPAIRED WITH 2 DOUBLERSSDR JJBA20231018015Unknown · unknownNLG W/WELL, CRACK FOUND ON NLG UP-LOCK AFT CROSS BEAM. NLG W/WELL ON NLG UP-LOCK REMOVED AND REPLACED AFT CROSS BEAM.SDR JJBA20231016013Battery Pack · inoperativeFOUND LH FORWARD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY AND OPS CHECK. OPS CHECK FAIL. FOUND EMERGENCY LIGHT BPS ONE CHARGER AND BATTERY BURNT. REMOVED AND REPLACED #1 EMERGENCY LIGHT BATTERY. OPS CHECK SAT.SDR JJBA20231019032Unknown · unknownRF1, CARGO DOOR SURROUND STRUCTURE AFT L-SHAPE AT FR 68 FOUND CORRODED. SHEAR CLIP REPAIRED WITH A SPLICE. CORROSION LEVEL 1.SDR JJBA20231019030Unknown · unknownRF1, CARGO DOOR SURROUND STRUCTURE FWD L-SHAPE AT FR 65 FOUND CORRODED. SHEAR CLIP REPAIRED WITH A SPLICE. CORROSION LEVEL 1SDR JJBA20231030047Unknown · unknownRF1, LOWER BEAM OF CARGO DOOR SURROUND STRUCTURE BTW FR 65-68 FOUND CORRODED. LOWER BEAM CARGO DOOR SURROUND REPLACEDSDR JJBA20231030045Unknown · unknownAT RF1, CRACK FOUND ON LH SHEAR CLIP AT FR 73 BTW STR 16L-17L. LH SHEAR CLIP AT FR 73 BTW STR 16L-17L REPLACEDSDR JJBA20231030044Unknown · unknownAT RF1, CRACK FOUND ON LH SHEAR CLIP AT FR 71 BTW STR 17L-18L. AT RF1, LH SHEAR CLIP AT FR71 BTW STR 17L-18L REPLACED.SDR JJBA20231018023Unknown · unknownRH MLG, FWD BEARING CAP TRACK CORRODED. REPAIRED RH MLG, FWD BEARING CAP TRACKSDR JJBA20231018020Unknown · unknownLH MLG, FWD BEARING CAP TRACK CORRODED. REPAIRED LH MLG, FWD BEARING CAP TRACKSDR JJBA20231018017Unknown · unknownAT CF4 EXT, CORROSION FOUND ON TOILET WASTE CUP BTW FR 60-61 AND BTW STR 18R-20R. WASTE DRAIN VALVE REMOVED. TOILET DRAIN CABLE REMOVED. RINSE NIPPLE REMOVED. TOILET WASTE CUP BTW FR60-61 STR 18R-20R BLENDED AND FOUND OUT OF LIMITS. AT CF4, TOILET WASTE CUP BTSDR JJBA20231016014Unknown · unknownCF2, CRACKS (6X) FOUND ON LH OMEGA BEAM #2 FLOOR STRUCTURE BTW FR 23-30. REPLACED.SDR JJBA20231019038Unknown · unknownCF3, LH CLOSING ANGLE BTW FRAME 46-50 FOUND CORRODED. BLENDS ARE TEMPORARILY ACCEPTEDSDR JJBA20231019037Unknown · unknownAT F.F. LH SKIN FOUND DAMAGED FWD OF FR 2 AND STR 15L. SKIN REPAIRED WITH A DOUBLER.SDR JJBA20231019035Unknown · unknownCF3, RH CLOSING ANGLE BTW FRAME 46-50 FOUND CORRODED. BLENDS ARE TEMPORARILY ACCEPTEDSDR JJBA20231019027Unknown · unknownCF4, LH OMEGA BEAM FOUND CORRODED ON FLOOR STRUCTURE AROUND NUTPLATE BTW FR 60-61. BEAM REPAIRED WITH A DOUBLERSDR JJBA20231011012Unknown · unknownOVERWING PASSENGER EXIT SIGN FALLING DOWN (CENTER). RESECURED EXIT SIGN. OPS CHECK SAT.SDR JJBA20231019028Unknown · unknownAT FF COCKPIT CRACK FOUND AT LH OVERHEAD HANDLE. RIB REPAIRED WITH A DOUBLER.SDR JJBA20231018026Unknown · unknownCF2, CRACK FOUND ON CENTER OMEGA BEAM #2 LH FLANGE AT FRAME 33 ON FLOOR STRUCTURE AREA. BEAM REPAIRED WITH A DOUBLER.SDR JJBA20231018022Unknown · unknownCF2, CRACK FOUND ON CENTER OMEGA BEAM #2 LH FLANGE AT FRAME 31 ON FLOOR STRUCTURE AREA. BEAM REPAIRED WITH A DOUBLERSDR JJBA20231009002Lamp · inoperativePAX CABIN SEATS 18CD HAVE INOP OVERHEAD PSU EMERGENCY LIGHT. REMOVED AND REPLACED RH OVERWING EMERGENCY LIGHT BULB. OPS CHECK GOOD.SDR JJBA20231011011Unknown · unknownRF1 T-ANGLE AT FRAME 65 TO LOWER BEAM OF CARGO DOOR SURROUND STRUCTURE CORRODED. RF1, T-ANGLE AT FRAME 65 TO LOWER BEAM OF CARGO DOOR SURROUND STRUCTURE REPLACEDSDR JJBA20231011010Unknown · unknownCF2, CRACKS (4X) FOUND ON LH OMEGA BEAM #3 FLOOR STRUCTURE BTW FR 29-36. CF2, LH OMEGA BEAM #3 FLOOR STRUCTURE BTW FR 29-36 REPLACEDSDR JJBA20231011009Unknown · unknownRF1, FRAME 65, LH SHEAR CLIP U/FLOOR BTW STR 18L-19L CRACKED. AT RF1, FRAME 65, LH SIDE SHEAR CLIP BTW STR 18L-19L REPLACEDSDR JJBA20231011008Unknown · unknownAT RF1, FRAME 68, LH SIDE SHEAR CLIP BTW STR 6L-9L FOUND CRACKED. AR RF1, FRAME 68, LH SIDE SHEAR CLIP BTW STR 6L-9L REPLACED.SDR JJBA20231011007Unknown · unknownAT RF1, FRAME 72, LH SHEAR CLIP U/FLOOR BTW STR 17L-18L FOUND CRACKED. RF1, FRAME 72, LH SHEAR CLIP BTW STR 17L-16L REPLACEDSDR JJBA20231011006Unknown · unknownCF2, FRAME 24, RH SHEAR CLIP FOUND CRACKED BTW STR 16R-17R. REPLACED SHEAR CLIPSDR JJBA20231011005Unknown · unknownCF2, FRAME 24, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. REPLACED SHEAR CLIPSDR JJBA20231011004Unknown · unknownCF2, FRAME 25, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. REPLACED SHEAR CLIPSDR JJBA20231010003Unknown · unknownCF2, FRAME 27, RH SHEAR CLIP FOUND CRACKED BTW STR 15R-16R. REPLACED SHEAR CLIPSDR JJBA20231004001Access Panel · damagedE1 2 ACCESS PANELS OPEN UPON LANDING. PERFORMED GVI OF E1. NO DEFECTS FOUND. INSPECTED E1 COWLING (INTERNALLY AND EXTERNALLY) AND SURROUNDING AREA. FOUND THE AIR START VALVE ACCESS PANEL AND THE OIL SERVICE PANEL WERE LEFT OPEN IN FLIGHT. NO DAMAGE WAS OBSERVESDR JJBA20231002048Battery Pack · unknownFOUND LH AND RH OVERWING EMERGENCY LIGHTS TO DIM & SHUT OFF AFTER BEING SWITCHED ON. REMOVED AND REPLACED NUMBER 4 EMERGENCY LIGHT BATTERY. LIGHT OPS CHECK GOOD.SDR JJBA20230929046Unknown · unknownMCD STUCK OPEN. FOUND MCD LINING CATCHING. RESECURED DOOR LINING. OPS CHECK SAT. NO DEFECTS NOTEDSDR JJBA20230927044Light · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED SERVICE DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK FAIL. REMOVED AND REPLACED SERVICE DOOR EXTERNAL EMERGENCY LIGHT ASSEMBLY. OPS CHECK GOOD.SDR JJBA20230929047Lamp · inoperativeRH WING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH WING EMERGENCY LIGHT. OPS CHECK SATSDR JJBA20230925041Unknown · unknownBURNING SMELL IN CABIN ON APPROACH BETWEEN ROWS 5-18. INSPECTED ACM, NO DEFECTS NOTED. PERFORMED GROUND HIGH POWER ENGINE RUNS AND PERFORMED FIM. NO DEFECTS NOTEDSDR JJBA20230921042Battery Pack · inoperativeFOUND FWD CABIN EMERGENCY LIGHT TOP AND BOTTOM ENTRY WAY AND ABOVE FLIGHT ATT SEAT OUT. REMOVED AND REPLACED #1 EMERGENCY BATTERY. OPS CHECK SAT. NO DEFECTS NOTED AT THIS TIMESDR JJBA20230921043Unknown · unknownCORROSION FOUND ON MIDDLE ALLEY CROSSBEAM AT FR 20 ON FLOOR STRUCTURE. CF1 MIDDLE ALLEY AT FR 20 ON FLOOR STRUCTURE AREA, CROSSBEAM REMOVED FOR INVESTIGATION. CF1 AT FR 20 ON FLOOR STRUCTURE AREA, CROSSBEAM BLENDED OUT OF LIMITS. ALTERNATE MATERIAL NEEDED FOR SDR JJBA20230920040Unknown · unknownDURING MIDDLE GUSSET REMOVAL, CORROSION FOUND ON MIDDLE OMEGA BEAM BTW FR 23-24 ON CF1 FLOOR STRUCTURE AREA. MIDDLE OMEGA BEAM BTW FR 23-24 ON CF1 FLOOR STRUCTURE AREA REPLACEDSDR JJBA20230920039Unknown · unknownAT RF1, MINOR CORROSION FOUND ON MIDDLE FWD RIB CARGO DOOR SURROUND STRUCTURE AT FR 65 IN FLOOR STRUCTURE AREA. AT RF1, CARGO DOOR STRUCTURE AT FR 65 IN FLOOR STRUCTURE AREA, MIDDLE FWD RIB REPLACED
Back to Embraer EMB-145XR