N34111, cancelled Apr 10, 2024
Service difficulty reports · 92
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N34111' AND deregistration_id = 'N34111-2024-04-10' 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 n_number = 'N34111' AND deregistration_id = 'N34111-2024-04-10' 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 RAIA2020031090001Acm · failedCREW REPORTS BURN/ELECTRICAL SMELL IN CABIN FOR SEVERAL MINUTES IN FLT---C/W FIM TASK 21-20-00 FOUND PACK 2 ACM AND RH SIDEWALLS NOT WORKING, SEE DISCREPANCY BLOCKS 2 AND 3 FOR CORRECTIVE ACTIONS--BLOCK 2- R&R #2 ACM, PERFORMED OPS CHECK AND FOUND NO BURNING SSDR RAIA2020012420001Sensor · inoperativeBLEED #2 OVERTEMP IN FLIGHT. R&R PAC DUCT ORVERTEMP SENSOR. OPS AND LEAK CHECK GOOD.SDR RAIA201907270001Skin · damagedPAX DOOR EXT SKIN DAMAGED AT AFT LOWER VERTICAL EDGE. BLENDED OUT AFFECTED AREA IAW ETD2019-145-102337.SDR RAIA201907240005Angle · corrodedCARGO Z ANGLE SHOWS SIGNS OF CORROSION. R&R CARGO DOOR Z ANGLE.SDR RAIA201907240004Tee Fitting · crackedAFT CARGO DOOR LOWER THRESHOLD T PROFILE AT FRAME 67 UPPER SUPPORT ANGLE IS CRACKED. R&R AFT CARG DOOR LOWER THRESHOLD T PROFILE AT FRME 67 UPPER SUPPORT ANGLE.SDR RAIA201907240003Tee Fitting · crackedAFT CARGO DOOR LOWER THRESHOLD T PROFILE AT FRAME 66 UPPER SUPPORT ANGLE IS CRACKED. R&R AFT CARGO DOOR LOWER THRESHOLD T PROFILE AT FRAME 66 UPPER SUPPORT ANGLE.SDR RAIA201907240002Tee Fitting · bentAFT CARGO DOOR LOWER THRESHOLD T PROFILE AT FRAME 66 IS BENT. R&R AFT CARGO DOOR LOWER THRESHOLD T PROFILE AT FRAME 66.SDR RAIA201907240001Tee Fitting · bentAFT CARGO DOOR LOWER THRESHOLD T PROFILE AT FRAME 67 IS BENT. R&R AFT CARGO DOOR T PROFILE AT FRAME 67.SDR RAIA201907230001Hinge · crackedLT WING O/B FLAP SHROUD O/B HINGE HALF IS CRACKED AT BOTH ENDS. R&R THE LT O/B FLAP LOWER SHROUD O/B HINGE.SDR RAIA2019050810002Clamp · looseWING A/ICE FAIL W/ ICE COND I/ICE INOP. INSPECTED AND FOUND A LEAKING BLEED DUCT JOINT IN THE PYLON. RESECURED CLAMP AND LEAK CHECKED SYSTEM, NO LEAKS NOTED. PERFORMED A/ICE TEST WITH CREW. OPS CHECK GOOD.SDR RAIA201903130001Proximity Sensor · malfunctionedLANDING GEAR AIR/GROUND FAIL. R/R NOSE GROUND PROX SENSORS. OPS CHECK GOOD.SDR RAIA2018091120009Radio Altimeter · corrodedAFT CARGO COMP FWD RADIO ALT AT FRAME 65 HAVE CORROSION BETWEEN CASE AND FUSELAGE SKIN. C/W ETD 2018-145-091731.SDR RAIA2018091120008Radio Altimeter · corrodedAFT CARGO AFT RADIO ALTEMETER AT FRAME 68 HAS 3 BROKEN OFF RIVETS AND SIGN OF CORROSION BETWEEN BASE AND FUSELAGE SKIN. C/W ETD 2018-145-09121.SDR RAIA2018091120007Seat Track · corrodedMAIN CABIN CENTER OMEGA BEAM SEAT TRACK HAVE CORROSION AT FRAME 52. REMOVE AND REPLACED CENTER OMEGA BEAM SEAT TRACK AT FRAME 52.SDR RAIA2018091120006Door Sill · corrodedMAIN CABIN LT FLOOR SILL HAVE CORROSION ON UPPERSURFACE FROM FR 31THRU 35. REMOVED AND REPLACED CABIN LT FLOOR SILL FROM FRAME 31-35 IAW SRM 51-40-02.SDR RAIA2018091120004Door Sill · corrodedMAIN CABIN LT FLOOR SILL HAVE CORROSION ON UPPER SURFACE FROM STA 42 THRU 47. REMOVED AND DRILLED NEW HOLES IN NEW LT FLOOR SILL AT FRAME 42-47 STARTED INSTALLING SILL LT AT FRAME 42 STILL NEEDS FASTENERS FINISHED INSTALLING SILL LT FRAME 42 IAW SRM51-40-02.SDR RAIA2018091120003Door Sill · corrodedRT FLOOR SILL HAVE CORROSION ON UPPER SURFACE BETWEEN STA 56AND 27. REMOVED AND PEPLACED FLOOR SILL BETWEEN STA 56 ADN 57 IAW SRM 51-40-02.SDR RAIA2018091120002Door Sill · corrodedAFT CARGO LT FLOOR SILL AFT OF CARGO DOOR HAVE LIGHT CORROSION AROUND NUTPLATES. INSTALLED NEW SILL FS 68 FS 74.SDR RAIA2018090420001Skin · corrodedREAR FUSELAGE LOWER SKIN CORROSION UNDER FWD AND AFT RADIO ALTIMETER. PERMANENT REPAIR WORK STARTED ON ETD2018-145-091731. WHEN AVAILABLE, DETAILS FOR THIS REPAIR WILL BE EMAILED TO 9-AMC-SDR-PROGMGR@FAA.GOV, WITH SUBJECT 34111 SDR RAIA201808220001.SDR RAIA2018091110004Support · corrodedMAIN CABIN FLOOR STEPUP SUPPORT AT FRAME 23 HAVE CORROSION AT FRAME 23 HAVECORROSION ON FWD FACE BETWEEN CENTER AND RT OMEGA BEAM. REMOVED AND INSTALLED NEW STEP UP SUPPORT AT FRAME 23 IAW SRM 51-40-02.SDR RAIA2018091110002Support · corrodedPASSENGER DOOR LOWER THRSHOLD AFT Z ANGLE NUTPLATE SUPPORT HAVE CORROSION AROUND NUTPLATE HOLES. REMOVED AND REPLACED PASSENGER DOOR LOWER THRESHOLD AFT Z ANGLE NUTPLATE SUPPORT IAW SRM 51-40-02.SDR RAIA2018090410001Skin · chafedREAR FUSELAGE 1 SKIN, CHAFING INSIDE RT PYLON. PERMANENT REPAIR. WORK STARTED ON ETD2018-145-090204. WHEN AVAILABLE, DETAILS FOR THIS REPAIR WILL BE EMAILED TO 9-AMC-SDR-PROGMGR@FAA.GOV, WITH SUBJECT 34111 SDR RAIA201808210001.SDR RAIA2018091190008Frame · crackedCOCKPIT FRAME 10 IS CRACKED BELOW LT DV WINDOW. REMOVED AND REPLACED FRAME 10 BELOW LT DV WINDOW.SDR RAIA2018091190005Fitting · crackedREMOVED CRACKED SHEAR CLIP. LOCATED DRILLED AND INSTALLED NEW SHEAR CLIP AT FRAME 57 LT AT STR 15.SDR RAIA2018091190004Support · crackedRT OMEGA BEAM LOWER LT SUPPORT IS CRACKED AT FRAME 47. REMOVE ANGLE, CUT DOWN ORIGINAL ANGLE IAW SRM 51-40-03 AND SRM-53-22-02. DRILLED UP FWD ANGLE, INSTALLED BOTH ANGLES IAW SRM 53-23-02.SDR RAIA2018091190003Fitting · crackedFRAME 16 RT SHEER CLIP IS CRACKED AT STR 15R. INSTALLED NEW SHEER CLIP AT STR 15 FRAME 16 IAW SRM 51-40-02.SDR RAIA2018091190002Support Bracket · crackedPASSENGER DOOR INTERIOR DOOR HANDLE SUPPORT BRACKET CRACKED. REMOVER AND REPLACED PASSENGER DOOR HANDLE SUPPORT.SDR RAIA201802100002Duct · not reportedBLEED 1 LEAK EICAS WARNING AND INSCRIPTION. DEFERRED BLEED 1 SYSTEM. ON 02/13/18, SWAPPED Y DUCTS OFF OF LT & RT PRSOV OPS TEST GOOD.SDR RAIA201802040002Line · leakingNR 1 BLEED LEAK IN FLIGHT. R & R BLEED LINE UNDER CARGO FLOOR. TEE DUCT FROM NR 2 ENGINE BLEED, GROUND START TO FWD BLEED LINES. LEAK CHECKED AND OPS CHECKED GOOD.SDR RAIA20171223002Duct · leakingBLEED 1 LEAK. SECURED THE LEAK AT DUCT 9, BLEED NR 1. OPS CHECKED WITH NO DEFECT NOTED.SDR RAIA20171221001Oxygen Mask · brokenCAPTAIN`S OXYGEN MASK BROKEN. R & R THE OXYGEN MASK. OPS CHECKED GOOD.SDR RAIA201709280001Boot · leakingBLEED 1 LEAK ON EICAS. SECURED THE BLEED DUCT COUPLING BOOTS, OPS AND LEAK CHECKED GOOD.SDR RAIA201708120001Bulb · inoperativeLEFT AFT WING TO BODY FAIRING EXTERIOR FLOOD LIGHT IS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR RAIA201608240001Outflow Valve · malfunctionedCABIN ALTITUDE CLIMBED IN FLIGHT IN AUTO MANUAL NOT TRIED. INSPECTED OUTFLOW VALVE FITTING & CONNECTORS. INSPECTED FOR FOD CONDUCTED PRESSURIZATION CHECKED IN AUTO & MANUAL. OPS CHECKED GOOD AND NO DEFECTS NOTED.SDR RAIA201602240001Seal · peelingLOUD KNOCKING NOISE ON F/O'S WINDOW. F/O'S HUMP SEAL PEELING.SDR RAIA201512010001Bulb · inoperativeWING TO FUSELAGE FAIRING FWD EMERGENCY FLOOD LIGHT NR 4 INOPERATIVE. R & R WING TO FUSELAGE FAIRING FWD EMERGENCY FLOOD LIGHT BULB NR 4. OPS CHECK GOOD.SDR RAIA201508250002Acm · overheatedCREW REPORTED SMOKE IN CABIN WITH ODOR OF BURNING RUBBER. MAINTENANCE INSPECTED AND FOUND PACK 1 TO BE OVERHEATED AND INOPERATIVE. PACK 2 OPERATES NORMALLY, DEFERRED PACK 1. MAINTENANCE REPLACED NR 1 ACM, OPS CHECK GOOD, CLEARS DEFERRAL.SDR ASOA20141228386Yoke · crackedDURING C-CHECK THE RT ENGINE FORWARD LOWER MOUNT YOKE FITTING WAS FOUND TO BE CRACKED AND VERIFIED WITH EDDY CURRENT. MAINTENANCE R & R THE FITTING IAW EC5450-01124. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20141228385Fitting · wornDURING C-CHECK THE LT AILERON PCA FITTING WAS FOUND TO BE WORN AND WOULD NOT RETAIN THE HAT BUSHINGS. MAINTENANCE R & R THE FITTING IAW EC5760-01044. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20141228384Fitting · gougedDURING C-CHECK, THE RT AILERON PCA FITTING WAS FOUND TO BE GOUGED. MAINTENANCE R & R THE FITTING IAW EC5760-01044, REV A. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20141228383Skin · gougedDURING C-CHECK THE FUSELAGE SKIN AT FRAME 7 AND STRINGER 14L WAS FOUND TO BE GOUGED. MAINTENANCE BLENDED THE DAMAGE AND PERFORMED A DOUBLER REPAIR IAW SRM 53-11-01. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20141228382Trunnion · crackedDURING C-CHECK THE LT MLG FORWARD TRUNNION WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED THE CRACKS BY REAMING THE BOLT HOLES IN THE TRUNNION IAW EC5750-01655. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20141228381Rib · crackedDURING C-CHECK THE RIB BELOW FRAME 10 AND STRINGER 1L - 1R WAS FOUND TO BE CRACKED. MAINTENANCE PERFORMED A REPAIR IAW EC5310-01824. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20141010125Inverter · inoperativeDURING CREW INSPECTION, THE LT EMERGENCY EXIT DOOR SIDEWALL LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE R & R THE NR 4 EMERGENCY LIGHT INVERTER, OPS TESTED WITH NO DEFECTS NOTED, AND THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20140111008HSmoke Detector · false activationTHE CREW REPORTED A CARGO SMOKE MESSAGE ON EICAS. MAINTENANCE INSPECTED THE ACFT AND R & R THE FORWARD CARGO BAY SMOKE DETECTOR, OPS TESTED WITH NO DEFECTS.SDR ASOA20130119057Bushing · migratedDURING C-CHECK RT AILERON INBD AND OTBD HAT BUSHINGS MIGRATED AT OTBD PCA ROD. MX PERFORMED REPAIR ON RT AILERON INBD AND OTBD HAT BUSHINGS IAW AMM 27-10-00-400-801-A. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130119056Bushing · migratedDURING C-CHECK RT SPOILER CENTER INBD HAT BUSHING MIGRATED. MX PERFORMED REPAIR TO RT SPOILER CENTER INBD HAT BUSHING IAW EC5740-01152. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130119055Mount · migratedDURING C-CHECK RT SPEED BRAKE CENTER INBD HAT BUSHING MIGRATED. MX R & R RT SPEED BRAKE CENTER MOUNT IAW EC5740-01288. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130119054Bushing · migratedDURING C-CHECK, LT SPOILER INBD FITTING OTBD HAT BUSHING MIGRATED. MX PERFORMED REPAIR ON LT SPOILER INBD FITTING, OTBD HAT BUSHING IAW EC5740-01152. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20130119053Yoke · crackedDURING C-CHECK, NR 1 ENGINE FWD LOWER MOUNT YOKE FWD EAR HAS VISUAL INDICATION OF CRACK BEYOND STOP DRILL. MX R & R RT 1 ENGINE FWD LOWER MOUNT YOKE FWD EAR IAW EC5450-01028. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.
Back to N34111, cancelled Apr 10, 2024