N780SW, cancelled Oct 28, 2024
Service difficulty reports · 318
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 = 'N780SW' AND deregistration_id = 'N780SW-2024-10-28' 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 = 'N780SW' AND deregistration_id = 'N780SW-2024-10-28' 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 SWAA2021112426945Crease Beam · corrodedCORROSION ON CABIN CREASE BEAM BS 713 LBL 69 WL 208. REMOVED 1 FASTENER IN THE CREASE BEAM WEB IAW SRM 51-40-02-0G-0. REMOVED CORROSION ON UPPER SURFACE OF CREASE BEAM WEB. AREA BLENDED IS 1' BY 1' IAW SRM 51-10-02-0G-0. EDDY CURRENT INSPECTED ON BLENDEDSDR SWAA2021112426940Seat Track · corrodedCORROSION ON SEAT TRACK, BS 540 - 559, BS 570 - 589, BS 598 - 639, BS 645, BS 656 - 638, BS 727A - 727B LBL 45, WL208. REMOVED CORROSION AND FOUND OUT OF LIMITS IAW SRM 53-00-52-1A-1, & SRM 51-10-02-0G-0. REMOVED THE SEAT TRACK IAW SRM 51-40-02-0G-0. LSDR SWAA2021112426936Seat Track · corrodedCORROSION ON CABIN SEAT TRACK BS 540 - 559, BS 564 - 592, BS 598 - 683, BS 685 - 709, BS 716 - 727+12, & BS 727A - 727B. LBL 25 WL 208. REMOVED CORROSION, FOUND OUT OF LIMITS IAW SRM 53-00-52-1A-1, & SRM 51-10-02-0G-0. REMOVED THE SEAT TRACK IAW SRM 51-40SDR SWAA2021111926930Seat Track · crackedPASSENGER CABIN SEAT TRACK HAS CRACKED FASTENER BS727B RBL25 WL208. MARKED ; / [01] UPDATED TABLE; [02] CRACK FASTENER IN PASSENGER CABIN SEAT TRACK STA 727B; RBL 25; WL 208 WAS REPLACED ON SEAT TRACK REPLACEMENT ON CARD# TTG8Q006SPNJ; INTERIOR 1564; VERIFIED SDR SWAA2021111926961Frame · crackedL/H STRINGER 8 FRAME CRACKED BS 440 LBL 65 WL 273. ; / [01] UPDATED MEASUREMENTS TABLE.; [02] REPAIRED L/H STRINGER 8 FRAME AT BS 440 LBL 65 WL 273 PER EA 1-A53-12114 R7.; [03] COMPLETE; [04] COMPLETESDR SWAA2021111926960Frame · crackedR/H STRINGER 8 FRAME CRACKED BS 500A RBL 65 WL 273. ; / [01] UPDATED MEASUREMENTS TABLE.; [02] REPAIRED R/H STRINGER 8 FRAME AT BS 500A RBL 65 WL 273 PER EA 1-A53-12114 R7.; [03] COMPLETE; [04] ALL STEPS COMPLETESDR SWAA2021111926963Frame · crackedR/H STRINGER 8 FRAME CRACKED BS 787 RBL 65 WL 273. ; / [01] UPDATED MEASUREMENTS TABLE.; [02] REPAIRED R/H STRINGER 8 FRAME AT BS 787 RBL 65 WL 273 PER EA 1-A53-12114 R7.; [03] COMPLETE; [04] ALL STEPS COMPLETE.SDR SWAA2021111926962Frame · crackedR/H STRINGER 8 FRAME CRACKED BS 827 RBL 65 WL 273. ; / [01] UPDATED MEASUREMENTS TABLE.; [02] REPAIRED R/H STRINGER 8 FRAME AT BS 827 RBL 65 WL 273 PER EA 1-A53-12114 R7.; [03] COMPLETE; [04] ALL STEPS COMPLETE.SDR SWAA2021111926955Support · crackedCRACKED FLOOR SUPPORT BS380-400 BL 0 WL 208. ; / [01] REMOVED CRACKED FLOOR SUPPORT FROM BS380-400 BL 0; IAW B737 SRM 51-40-02-0G-0.; [02] RECEIVE NEW FLOOR SUPPORT ANGLE 143A5410U11 ; LOCATED AND DRILLED IAW B737 SRM 51-40-05-0G-0 AND DWG 143A5400. OK TO INSTSDR SWAA2021111926931Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS390; BS410 - BS428; BS440 - BS460. RBL45 WL208. MARKED ; / [01] UPDATED TABLE; [02] ACCOMPLISHED STEPS 1-3; [03] VERIFIED STEPS 1 - 3 ARE COMPLETE.; [04] APPLIED CHEMICAL CONVERSION COATING ON PASSENGER CABIN SEAT TRACSDR SWAA2021111926932Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS480 - BS487; BS500 - BS500A; BS500A+10; BS500A+17; BS500B+8; BS500B; BS500C; BS500C+8; BS500D; BS520. RBL45 WL208. MARKED ; / [01] UPDATED TABLE; [02] ACCOMPLISHED STEPS 1-10; [03] COMPLETED STEPS 1 - 10.; [04] APPLIEDSDR SWAA2021111926933Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS727B+8 - BS727C; BS727C+7 - BS727D+10; BS727E+5 - BS727E+16; BS747; BS759; BS767; BS778; BS791- BS807; BS725 - BS741; BS751 - BS873. RBL45 WL208. MARKED ; / [01] UPDATED TABLE; [02] ACCOMPLISHED STEPS 1-10; [03] COMPLESDR SWAA2021111926943None · corrodedCORROSION ON PASSENGER CABIN CREASE BEAM BS727C+18 RBL69 WL208. ; / [01] UPDATED TABLE; [02] REMOVED 1 EA FASTENER IN PASSENGER CABIN CREASEBEAM WEB STA 727C+18; RBL 69; WL 208 FOR ACCESS PER SRM 51-40-02-0G-0.; [03] REMOVED CORROSION ON UPPER SURFACE ON CREASSDR SWAA2021111926949Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS380 - BS400; BS410 - BS428; BS440 - BS460; BS461. RBL25 WL208. MARKED ; / [01] UPDATED TABLE; [02] UPDATED STEPS 1-4; [03] COMPLETED STEPS 1-4; [04] COMPLETED STEP 5; [05] COMPLETED STEP 5 AND CHANGED TO PARTIAL; [06] SDR SWAA2021111926954Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS546- BS562; BS578 - BS663; BS670; BS677 - BS692; BS696 - BS725; BS727 - BS727A+10. RBL45 WL208. MARKED ; / [01] UPDATED TABLE; [02] ACCOMPLISHED STEPS 1-6; [03] COMPLETED STEPS 1 - 6.; [04] APPLIED CHEMICAL CONVERSION SDR SWAA2021111926950Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS487; BS500+7; BS500A+17; BS500B - BS500B+8; BS500C+7; BS500D; BS520. RBL25 WL208. MARKED ; / [01] UPDATED TABLE;[25] REPLACED NEW PASSENGER CABIN SEAT TRACK BS 480 - 520 RBL 25 WL 208 PER DWG 143A5310 REV:A AND 143A530SDR SWAA2021111926959None · corrodedCORROSION ON FWD ENTRY DOOR CUTOUT LOWER SURFACE OF UPPER SILL WEB BS 307-312 AND BS 313-316 LBL 36 WL 284. ; / [01] VERIFIED APPLICABILITY OF SRM 53-10-15-0I-1 AND SRM 53-10-15-1A-1; [11] REPAIRED CORROSION ON FWD. ENTRY DOOR CUTOUT UPPER SILL WEB LOWER SURFASDR SWAA2021111926953Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS727B+4 - 727C; BS727C+10 - BS727D; BS727D+10; BS727E+6 - BS753; BS767 - BS778; BS790; BS795; BS810; BS827 - BS841; BS853 - BS873. RBL25 WL208. MARKED ; / [01] UPDATED TABLE; 06] LOCATED AND DRILL NEW SEAT TRACK RBL 25 SDR SWAA2021111926942Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS844; BS857; BS876; BS881; BS887. LBL45 WL208. MARKED ; / [01] UPDATED TABLE; [02] REMOVED CORROSION ON PASSENGER CABIN SEAT TRACK STA 844-887; LBL 45; WL 208. MAX MATERIAL REMOVED WAS .037' .5 BY 4'. OUT OF LIMITS PER SDR SWAA2021111926941Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS727B+3; BS727C+2; BS727D+11; BS727E+4; BS750; BS762; BS783 - BS795; BS811; BS824. LBL45 WL208. MARKED ; / [01] UPDATED TABLE; [02] SEAT TRACK WENT OUT OF LIMITS ON CARD#TTG8Q006SN6D AND WILL BE REPLACED ON CARD# TTG8Q0SDR SWAA2021111926937Seat Track · corrodedCORROSION ON PASSENGER CABIN SEAT TRACK BS727B - BS762; BS776 - BS794; BS807 - BS827; BS840 - BS855; BS873 - BS887. LBL25 WL208. MARKED ; / [01] UPDATED TABLE; [10] INSTALLED NEW SEAT TRACK STA 727B-887; LBL 25; WL 208 PER SRM 51-40-02-0G-0; SRM 51-40-04-0G-0;SDR SWAA2021112426452None · corrodedCORROSION ON B.S. 1016 CHORD BETWEEN STRINGERS 25 LEFT AND 25 RIGHT; W.L. 190. ; / [01] EVALUATED CORROSION ON CHORD SPLICE; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0; [02] VERIFIED CORRECTIVE ACTION ISDR SWAA2021112426445Intercostal · corrodedCORROSION ON SUPPORT INTERCOSTAL AT B.S. 259+3 - 259+8; L.B.L 3 - R.B.L. 3; W.L.207.54. REMOVED CORROSION ON SUPPORT INTERCOSTAL. FOUND TO BE OUT LIMITS ALL IAW SRM 51-10-02-0G-0, AND SRM 53-10-51-1A-1, ALLOWABLE DAMAGE 1 FIG 104 GROUP 2 PAR 4.B (2) (A) DETASDR SWAA2021112426444Beam · corrodedCORROSION ON B.S.270 LATERAL BEAM AT L.B.L 9; L.B.L. 6; L.B.L. 4; R.B.L. 3 AND R.B.L. 9; W.L. 207.54. ; / [01] REMOVED FASTENER ON BS270 RBL9-LBL9 WL208 I.A.W SRM 51-40-02-0G-0; [08] DAMAGE ON BS270 LATERAL BEAM FROM LBL9-RBL9 WL207.5 18'X1' AREA FOUND TO BE OSDR SWAA2021111926214None · corrodedCORROSION ON AFT ENTRY DOOR; EXTERIOR HANDLE ASSY PAN. ; / [01] AED EXTERIOR HANDLE PAN REMOVED AND REPLACED PER SRM 51-40-02-0G-0; REFERENCING BOEING DWG 147A6116. WORK ACCOMPLISHED ON ATS COMPONENTS WORK ORDER RO# P1540486-1.; [02] VERIFIED STEP 1.; [03] VERSDR SWAA2021111926459None · corrodedCORROSION ON AFT SERVICE DOOR EXTERIOR HANDLE ASSY CAM FOLLOWER. ; / [01] UPDATED MEASUREMENT TAB; [02] CORROSION ON AFT SERVICE DOOR EXTERIOR HANDLE ASSY CAM FOLLOWER WAS REPAIRED ON CUSTOMER RO NO P1540381-1 AND JOB# 543578; [03] CORROSION ON AFT SERVICE DOOSDR SWAA2021111926454None · corrodedCORROSION ON AFT SERVICE DOOR EXTERIOR HANDLE ASSY PAN ; / [01] UPDATED MEASUREMENT TAB; [02] UPDATED MEASUREMENT TAB; [03] CORROSION ON AFT SERVICE DOOR EXTERIOR HANDLE ASSY PAN WAS REPAIRED ON CUSTOMER RO NO P1540381-1 AND JOB# 543578; [04] VERIFIED AFT SERVSDR SWAA2021111926450None · out of toleranceAFT CARGO BAY FLOOR SUPPORT RAIL HAS BONUS HOLE AT 767+5 RBL 3 WL156 ; / [01] DAMAGE ON ACB FLOOR SUPPORT RAIL BS 767+5; RBL 3; WL 156 FOUND TO BE OUT OF LIMITS DUE TO 100% MATERIAL LOSS IAW SRM 53-00-53-1A-2; [02] CUT OUT DAMAGE ON ACB FLOOR SUPPORT RAIL BS 7SDR SWAA2021111926451Guide Arm · corrodedCORROSION ON AFT ENTRY DOOR GUIDE ARM; GUIDE TRACK ; / [01] REMOVED AFT ENTRY DOOR GUIDE ARM AND ROLLER PER MM 52-13-21-000-802; [02] REMOVED AFT ENTRY DOOR; UPPER HINGE FITTING; FUSELAGE SIDE PER MM 52-13-41-000-801; [03] UPDATED MEASUREMENTS TAB; [04] CORROSSDR SWAA2021111926449Flange · corrodedCORROSION ON PREVIOUS UPPER FLANGE REPAIR BS 986 AT LBL 42 WL 208 AT NUTPLATE HOLES. ; / [01] REMOVED NUTPLATE BS986 LBL42 WL208 I.A.W SRM 51-40-02-0G-0; [02] NO ALLOWABLE LIMITS FOUND FOR PREVIOUS REPAIR ON SRM. DAMAGED UPPER FLANGE OF BS986 FLOOR BEAM TO BE SDR SWAA2021111926448Flange · corrodedCORROSION ON PREVIOUS UPPER FLANGE REPAIR BS 986 RBL 42 - RBL 35 WL 208 AT NUTPLATE HOLES. ; / [01] REMOVED NUTPLATE BS986 LBL42 WL208 I.A.W SRM 51-40-02-0G-0;21] INSTALLED FLOOR SUPPORT BS986-BS1006 RBL45 WL 208 REMOVED FOR ACCESS ON CORRECTIVE ITEM 6 I.A.W BSDR SWAA2021111925782None · corrodedCORROSION ON AFT ENTRY DOOR; EXTERIOR HANDLE ASSY; CAM FOLLOWER. ; / [01] REMOVED AND REPLACED AED EXTERIOR HANDLE CAM FOLLOWER PER CMM 52-15-16; PG 704; PARAGRAPH 2.D.(5) AND (6).<BR>WORK ACCOMPLISHED ON ATS COMPONENTS WORK ORDER RO# P1540486-1.; [02] VERIFIESDR SWAA2021111925784None · corrodedCORROSION ON AFT SERVICE DOOR; EXTERIOR HANDLE ASSY; CAM. ; / [01] UPDATED MEASUREMENT TAB; [02] CORROSION ON AFT SERVICE DOOR; EXTERIOR HANDLE ASSY; CAM WAS REPAIR ON CUSTOMER RO NO P1540381-1 AND JOB# 543578; [03] VERIFIED AFT SERVICE DOOR WAS REPAIRED ON CUSDR SWAA2021111925773Door · corrodedLAV SERVICE DOOR HAS CORROSION ON LOWER FWD CORNER ON EXTERIOR SIDE OF DOOR ; / [01] EVALUATED CORROSION ON LAV SERVICE DOOR; FOUND 0.030 REMOVED FROM ORIG 0.100 IN 3'X2' AREA; FOUND TO BE OUT OF LIMITS PER SRM 52-40-01-1A-4 USING DIAL DEPTH GAUGE ID NCX000697SDR SWAA2021112425767Web · corrodedSUPPLEMENTAL INFORMATION: FWD CARGO BAY SUB THRESHOLD CORRODED AROUND FASTENER HOLES BS 440+33; 440+33; RBL 29; WL 156 ; / [01] AFTER FURTHER INVESTIGATION; FOUND CORROSION ON SUB THRESHOLD WEB TO BE AT BS 440+33 AND BS 440+39; [02] EVALUATED CORROSION; FOUND SDR SWAA2021112425760Support · corrodedSUPPLEMENTAL INFORMATION: AFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT CORRODED AT FASTENER HOLES BS 727A+14; 727B+10; 727C+14; 727E+2; 727E+6; 727E+10; 727E+14; 727E+18; 747+2; 747+7 ; / [01] FAULT LOCATION INCOMPLETE. FAULT TO BE CORRECTED ON FAULT #TTG8Q006RSDR SWAA2021112425770Support · corrodedFWD CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT CORRODED BS 420+10; 420+13; 440+10; 440+14; 460+6; 460+10; 500+10; 500B+14; 500C+6; RBL 25; WL 156 ; / [01] AFTER FURTHER INVESTIGATION; L/H FLOOR TO SIDEWALL SUPPORT IS LBL 25; NOT RBL 25. EVALUATED CORROSION AT ALLSDR SWAA2021112425769Support · corrodedFWD CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT CORRODED BS 500B+19; 500C+13; 500C+15; RBL 25; WL 156 ; / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND DEEPEST LOCATION TO BE AT BS 500B+19 RBL 25 WL 156; FOUND 0.015 REMOVED FROM ORIG 0.040 IN 1'X1' AREA; FOUND SDR SWAA2021112425768Shield · corrodedFWD CARGO BAY AFT SHIELD CORRODED BS 500+1; 500+6; 500+17; RBL 25; WL 156 ; / [01] EVALUATED CORROSION; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0; [02] VERIFIED CORRECTIVE ACTION ITEM 1.; [03] LOCATED;SDR SWAA2021112425766Support · corrodedR/H FLOOR TO SIDEWALL SUPPORT CORRODED AROUND FASTENER HOLES BS 400+6; 400+10; RBL 25; WL 156 ; / [01] EVALUATED CORROSION AT ALL LOCATIONS; FOUND DEEPEST LOCATION TO BE AT BS 400+6 RBL 25 WL 156; FOUND 0.015 REMOVED FROM ORIG 0.040 IN 1'X1' AREA; FOUND TO BE SDR SWAA2021112425764Support · corrodedAFT CARGO BAY L/H FLOOR TO SIDEWALL SUPPORT CORRODED AROUND FASTENERS HOLES BS 727A+18; 727C+10; 727E+6; 727E+10; 727E+14; 747+4; 747+10; 767+3 - 767+11; 787+7; 787+11; LBL 22; WL 156 ; / [01] EVALUATED CORROSION AT ALL LOCATION; FOUND DEEPEST LOCATION TO BE ASDR SWAA2021112425763Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED BS 727C; S25L - 26L; WL 149. EVALUATED CORROSION; FOUND TO BE OUT OF LIMITS IAW SRM 51-10-02-0G-0. REMOVED SHEAR TIE IAW SRM 51-40-02. LOCATED, DRILLED AND PRIMED NEW SHEAR TIE IAW DWGS 146A3230, 146A1281 AND SRM 51-40-05SDR SWAA2021112425761Support · corrodedAFT CARGO BAY R/H FLOOR TO SIDEWALL SUPPORT CORRODED AT FASTENER HOLES BS 727A+14; 727B+10; 727C+14; 727E+2; 727E+6; 727E+10; 727E+14; 727E+18; 747+2; 747+7 RBL 22; WL 156 ; / [01] EVALUATED CORROSION AT ALL LOCATION; FOUND DEEPEST LOCATION TO BE AT BS 727E+14SDR SWAA2021112425759Shield · corrodedFWD CARGO BAY FWD SHIELD CORRODED AROUND FASTENER HOLES BS 420+9; BS 420+12.5; RBL 25; WL 156 ; / [01] EVALUATED CORROSION; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0; [02] VERIFIED CORRECTIVE ACTION ITSDR SWAA2021112425757Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED BS 847 S26 - 27L, WL 153. EVALUATED CORROSION AND FOUND TO BE OUT OF LIMITS IAW SRM 51-10-02-0G-0. REMOVED ACB SHEAR TIE IAW SRM 51-40-02. LOCATED, DRILLED AND PRIMED IAW DWG 146A3230, 146A1202 AND SRM 51-40-05-0G-0. INSTSDR SWAA2021112425756Shield · corrodedAFT CARGO BAY FWD SHIELD CORRODED AROUND FASTENERS HOLES BS 767+1; 767+3; 767+7; 767+11; 767+15; RBL 22; WL 156 ; / [01] EVALUATED CORROSION; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0; [02] VERIFIED COSDR SWAA2021112425755Stringer Clip · corrodedAFT CARGO BAY STRINGER CLIP CORRODED BS 747, S26R, WL 150. REMOVED THE STRINGER CLIP IAW SRM 51-40-02-0G-0, LOCATED AND DRILLED A NEW STRINGER CLIP IAW 51-40-05-0G-051-40-02-0G-0 AND INSTALLED IAW SRM 51-40-02-0G-0 AND DWG 146A1260.SDR SWAA2021111925758Angle · crackedWATER SERVICE PAN UPPER SURFACE AFT SUPPORT ANGLE CRACKED (BS 907+11; RBL 14) ; / [01] EVALUATED CRACK; FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS IN THE SRM AND REQUIRES REPLACEMENT PER SRM 51-10-02-0G-0; [02] VERIFIED CORRECTIVE ACTION 1; [03] REMOVED WATER SDR SWAA2021111925762Rail · corrodedAFT CARGO BAY RAIL HAS ELONGATED HOLE BS 727+8; LBL 7; WL 156 ; / [01] DAMAGE FOUND ON ACB RAIL BS 727+8; LBL 7; WL 156 FOUND TO BE OUT OF LIMITS DUE TO 100% MATERIAL LOSS IAW SRM 53-00-53-1A-2.; [11] INSTALLED NEW ACB RAIL AND REPAIR CHANNEL BS 727+4-BS 727B+SDR SWAA2021100525765Angle · corrodedAFT CARGO BAY STIFFENER ANGLE CORRODED BS 794, RBL 21; WL 153. EMOVED DAMAGE ON ACB STIFFENER ANGLE BS 794 RBL21 WL 153 IAW SRM 51-10-02. REMOVED DAMAGE IN AN AREA OF 1'X1' ON ACB STIFFENER ANGLE BS 794 RBL 21 WL 153 IAW SRM 51-10-02. FOUND TO BE WITH IN LI
Back to N780SW, cancelled Oct 28, 2024