N913DE
Service difficulty reports · 185
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 = 'N913DE' AND registry_match = 'registration' 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 = 'N913DE' AND registry_match = 'registration' 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 DALA2017010500127Fastener · shearedTAIL CONE AT LT UPPER LATCH RECEPTACLE HAS SHEARED FASTENERS AT SUPPRT BRACKETS. REPLACED SHEAR FASTENERS PER SRM 51-30, OK FOR SERVICE.SDR DALA2016062004778Door · crackedLEFT LANDING GEAR DOOR FOUND CRACK AFT EDGE AT CURVE. R & R LT MLG DOOR ASSY IAW AMM 32-12, GEAR SWING CKS GOOD.SDR DALA2015122807742Pin · pulledMAINTENANCE FOUND THE L1 DOOR SLIDE PINS PULLED OUT. THE L1 DOOR SLIDE WAS REPLACED.SDR DALA2015100906020Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE OVERHEAD EMERGENCY LIGHTING IN THE FIRST CLASS SECTION OF THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2015070904243Release Cable · frayedTAIL CONE RELEASE CABLE, DAMAGED AND FRAYED AFT OF BS 1485 AT 9 O`CLOCK POSITION. REPLACED THE RELEASE CABLE IAW AMM 53-53-02.SDR DALA2015070704215Cable · damagedCABLE DAMAGED AND FRAYED. REPLACED THE CABLE IAW AMM 53-53-02.SDR DALA2015070404133Skin · damagedVERTICAL STABILIZER L/E SPLICE AT ZFS=52.267, HAVE WORN COUNTER SINKS. FASTENERS ARE PULLED TO DEEP INTO THE SKIN; MARKED, RII: N ENTR 575200 W APPROVAL LEVEL ACCOMPLISHED BY INSPECTED BY FINAL, C/A 01045-08, VERTICAL L/E TO BE INSTALLED ON AMDS WC 5530-01045-SDR DALA2015022201567Door Sill · corrodedAFTER OPENING OF AFT CARGO DOOR SILL, FOUND PREVIOUS REPAIR FILLER WITH CORROSION BETWEEN STA 1156 AND 1210. GAINED ACCESS AT PREVIOUS REPAIR STA 1156 AND 1210 IAW SRM 51-30-5. REMOVED PREVIOUS REPAIR FILLER, SPACER. FABRICATED NEW -9 SPACER AND REINSTALLEDSDR DALA2015022701710Skin · dentedTWO DENTS IN BELLY AT BS 1226 IAW ERA 532852-14, REV ORIGINAL PERMANENT REPAIR ACCOMPLISHED.SDR DALA2014091905117Lamp · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT SEVERAL OF THE OVERHEAD EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED LAMP EACH LIGHT, BUT THE LIGHT ASSEMBLY AT THE RT FORWARD OVERWING EXIT REQUIRED REPLACEMENT. A SATISFACTORY FUNCTIONAL CHECK WAS PERFORMED FOLLOWINSDR DALA2014082904855Pin · missingDURING CHECK, MAINTENANCE FOUND THE TAILCONE TELEFLEX CABLE TEE PIN ATTACH BOLT NUT AND COTTER PIN MISSING. THE BOLT STARTED TO MIGRATE OUT OF POSITION. MAINTENANCE REPLACED THE HARDWARE.SDR DALA14002469013Wire Harness · damagedEMERGENCY LIGHT AT SEAT 34DE INOPERATIVE. REPAIRED DAMAGED SEAT WIRE HARNESS, OPS CHECKED GOOD.SDR DALA14001649013Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 29. BATTERY PACK REPLACED AND OPS NORMAL.SDR DALA13047839013Inlet · contaminatedDURING CLIMBOUT, FLIGHT CREW DETECTED A BURNING ODOR. NO SMOKE NOTED. ODOR DISSAPATED AFTER FIVE MINUTES. FOUND RESIDUAL HYD FLUID NEAR THE APU INLET WITH NO LEAKS FOUND. THE APU INLET WAS CLEANED AND THE DUCT BURNOUT WAS COMPLETED IAW WC 4950-2215. THESDR DALA13012869013Bracket · crackedDURING CHECK, TAILCONE UPPER LT BAYONET BRACKET WAS FOUND CRACKED. REMOVED, FABRICATED, HEAT TREATED, PRIMED AND INSTALLED BRACKET IAW DWG 9911957.SDR DALA13012029013Skin · crackedBS 1418, L2R SKIN CRACKED. REPAIRED IAW ERA 512397-14SDR DALA13011309013Frame · crackedCRACK AT BS 1418, LONGERON L2R WITHIN FRAME BACKUP ANGLE. REPAIR ANGLE PRIMED AND HOLES PICKED UP. OK TO INSTALL ANGLE C/W PRI 512493-14 REV 0.SDR DALA13011299013Skin · crackedSKIN HAS A CRACKED FASTENER HOLE, BS 1418 L2R OTBD OF VERTICAL SKATE ANGLE. PERFORMED HFEC IAW NDT SPM 06-10-01. ALL FASTENERS INSTALLED REPAIR DOUBLER, C/W PRI 512397-14AD REV 0. AWAITING FINAL ER/A.SDR DALA13011179013Bracket · wornDURING SERVICE CHECK, TAILCONE BUNGEE SPRING BRACKET IS WORN. R & R IAW MM.SDR DALA13011209013Skin · crackedDURING SERVICE CHECK, RUDDER SKIN UPPER MID HINGE CUTOUT FOUND CRACKED. REMOVED DAMAGED PLIES AND TAPERED BACK IAW SRM 51-70-01A, PG 189. DAMAGED CONTAINED. OK TO INSTALL REPAIR. PRIMED, PAINTED AND INSTALLED REPAIR IAW SRM 51-70-01A.SDR DALA13010459013Battery Pack · failedDURING SERVICE CHECK, FORWARD OVERWING EMERGENCY EXIT LIGHTS FAILED TEST. R & R BATTERIES IN PACK B5103 IAW MM. OPS CHECKED GOOD.SDR DALA13004599013Lamp · burned outDURING SERVICE CHECK, MX FOUND EMERGENCY EXIT SIGNS AT BOTH FWD OVERWING EXITS INOPERATIVE. RELAMPED BOTH FORWARD OVERWING EMEGENCY EXIT SIGNS. OPS CHECKS GOOD.SDR DALA12008999013Shear Tie · damagedSHEAR TIE AND FRAME BENT AND BUCKLED, STA 275 L29R. REMOVED DAMAGED FORMER AND STRAIGHTENED SHEAR TIE. DAMAGED CONTAINED. TREATED, PRIMED AND INSTALLED REPAIR IAW SRM 53-03, FIG 3. ALL COMPLETED IAW ERA 507489-14, REV O.SDR DALA12008989013Longeron · damagedLONGERON 29R DAMAGED BETWEEN BS 275-256. REMOVED DAMAGE, TREATED, PRIMED AND INSTALLED REPAIR IAW ERA 507489-14, REV O.SDR DALA12008979013Skin · damagedFORWARD FUSELAGE SKIN DAMAGED AT WATER DRAIN HOLE. REPAIRED IAW ERA 507489-14, REV O.SDR DALA1230949013Socket · damagedDURING SERVICE CHECK, MAINTENANCE FOUND EMERGENCY LIGHT OUT AT SEAT 18. REPLACED LAMP SOCKET. OPERATION CHECKED NORMAL.SDR DALA1226559013Cam · wornDURING OPERATION 6908 FUNCTIONAL CHECK OF TAIL CONE RELEASE SYSTEM, MAINTENANCE FOUND TEE PIN 11 WORN WITH BUSHING AND BASE FOR RELEASE CAM WORN. REMOVED AND REPLACED TEE PIN 11 AND CAM ASSEMBLY PER AMM. RII COMPLETED FUNCTIONAL CHECK GOOD.SDR DALA1211269013Skin · damagedDUE PERMANENT REPAIR PER ERA 485618-14 REV B CODE 53-31-10 ACTL 2151. SKIN STA 218 L-30 TO 1-29R JACK PAD FITTING DAMAGE. COMPLY WITH PERMANENT REPAIR ERA 485618-14 REV C.. ACTL 215 SKIIN STA 218 L-30 TO L-29R JACK PAD FITTING DAMAGE.SDR DALA1206959013Battery Pack · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING IN THE VENTRAL STAIRWAY WERE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION.SDR DALA1154489013Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN STA Y=1079 AND LONGERON L=30 ALSO STA Y=1098 BTW L=28LT AND L=29LT. FUSELAGE SKIN WAS REPAIRED IAW MD80 SRM 53-04D FIG 53.SDR DALA1154479013Pan · crackedDURING HMV A CRACK WAS FOUND ON PAN OF MID CARGO COMPARTMENT DOOR AFT EDGE BEHIND SETTLEMENT AREA OF STOP NUMBER 4. C1 DOOR PAN WAS REPAIRED IAW MD80 SRM 52-05D FIG 50.SDR DALA1154469013Pan · crackedDURING HMV A CRACK WAS FOUND ON MID CARGO COMPARTMENT DOOR PAN OUTBOARD EDGE BELOW OF FWD DOOR STOP NR 4. MID C2 DOOR PAN WAS REPAIRED IAW MD80 SRM 52-05D FIG 50.SDR DALA1154389013Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN STA Y=1097-1117 BETWEEN LONGERON 27LT AND L=27RT. FUSELAGE SKIN WAS REPAIRED IAW MD80 SRM 53-04 FIG 53.SDR DALA1154159013Skin · scratchedDURING HMV SCRATCHES ON FUSELAGE SKIN STA Y=1098-1115 BETWEEN LONGERON 18LT AND 20LT, ALSO STA Y=946-1037 BETWEEN LONGERON 18LT AND 17LT. FUSELAGE SKIN WAS REPAIRED IAW MD80 SRM 53-04D FIG 53.SDR DALA1154149013Beam · corrodedDURING HMV CORROSION WAS FOUND ON LOWER BEAM OF MID CARGO COMPARTMENT DOOR JAMB FROM STA Y=636 TO Y=693 BEAM. REPAIRED IAW MD80 SRM 53-05D FIG 123.SDR DALA1154139013Skin · dentedDURING HMV DENTS WERE FOUND ON LT/RT ELEVATOR GEAR TAB UPPER AND LOWER SKIN TAB. REPAIRED IAW MD80 SRM 55-04D PARA 3A.SDR DALA1154099013Skin · corrodedCORROSION ON FUSELAGE SKIN STA Y=742-788 BETWEEN LONGERONS 26LT AND 29LT. ON 17SEP MAINTENANCE REPAIRED FUSELAGE SKIN IAW MD-80 SRM 53-04D FIG 53.SDR DALA1154839013Skin · corrodedCORROSION ON FUSELAGE SKIN STA Y=1079 L=30. DOUBLER REPAIR INSTALLED IAW DC9/MD80 SRM 53-040 FIG 53.SDR DALA1155689013Fitting · bentBENT ON FRAME CLIP STA 237 BETWEEN LONG 18LT-17LT. NEW FORMER WAS INSTALLED IAW DC9/MD80 SRM 51-30-5.SDR DALA1151399013Beam · damagedDURING HMV ELONGATED HOLES WERE FOUND AFTER REMOVING FITTING ON MID CARGO COMPARTMENT DOOR JAMB LOWER BEAM.SDR DALA1151389013Doubler · corrodedSDR DURING HMV CORROSION WAS FOUND ON PREVIOUS REPAIR DOUBLER ON LOWER BEAM IN AFT CARGO COMPARTMENT DOOR JAMB FROM STA Y=1186 TO 1198.SDR DALA1151379013Beam · corrodedDURING HMV CORROSION WAS FOUND ON LOWER BEAM OF AFT CARGO COMPARTMENT DOOR JAMB FROM STA Y=1171 TO Y=1212.SDR DALA1151139013Cusp Web · corrodedDURING HMV CORROSION WAS FOUND ON FORWARD SERVICE DOOR JAMB CUSP ANGLE STA Y=196-218 X=-42 TO X=-60.SDR DALA1151129013Skin · delaminatedSDR DURING HMV DELAMINATION WAS FOUND ON LOWER SKIN OF LT AILERON STA XW=476 TO XW=486 AND AT UPPER SKIN OUTBD EDGE AT STA XW=486.SDR DALA1151119013Tab · dentedSUPP INFO NRC T0220282 DENTS ON LT ELEVATOR CONTROL TAB EDGE WAS REPAIRED IAW SRM 55-04 PARA 3A.SDR DALA1151109013Tab · damagedSUPP INFO NRC T0220281 LIGHTNING STRIKES ON LT ELEVATOR CONTROL TAB TRAILING EDGE WAS REPAIRED IAW SRM 55-04 PARA 3A.SDR DALA1150799013Cusp Web · corrodedDURING HMV CORROSION WAS FOUND ON RT CUSP WEB STA Y=1174-1193, 1193-1212, 1212-1231 AND 1231-1250 BTW X=-54 AND X=-60 AT PAX CABIN (TO 220410). MAINTENANCE REPLACED THE CUSP WEB IAW MD80 SRM 53-20-02D.SDR DALA1150839013Skin · dentedDURING HMV DENTS AND SCRATCHES WERE FOUND ON FUSELAGE SKIN REPAIR DOUBLER STA Y=236 BETWEEN LONG 18LT AND 17LT (TO 220111).SDR DALA1150789013Cusp Web · corrodedDURING HMV CORROSION WAS FOUND ON RT CUSP WEB STA Y= 1098-1117, 1117-1136, 1136-1155 AND 1155-1174 BTW X=-54 AND X=-60 AT PAX CABIN (TO 220409).SDR DALA1154779013Door Frame · damagedHIDDEN DAMAGE ELONGATED HOLES WERE FOUND AFTER REMOVED FITTINGS ON MID CARGO DOOR JAMB LOWER BEAM. DAMAGE REMOVED IAW DC9/MD80 SRM 53-05 FIG 123. REPAIR ACCOMPLISHED IAW DC9/MD80 SRM 51-30-2, 51-30-5 FIG 123.
Back to N913DE