N338SW, cancelled Oct 26, 2012
Service difficulty reports · 300
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 = 'N338SW' AND deregistration_id = 'N338SW-2012-10-26' 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 = 'N338SW' AND deregistration_id = 'N338SW-2012-10-26' 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 SWAA041568Skin · crackedDURING SCHEDULED C3 CHECK, FOUND LOWER WING SKIN OUTBOARD NR 1 ENGINE, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041567Lens · missingDURING SCHEDULED C3 CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT LENS AT ROW 20 ABC, MISSING. INSTALLED EMERGENCY EXIT LIGHT LENS PER MM.SDR SWAA041209Fastener · missingL2 DOOR EVAC SLIDE DOOR GIRT BAR HOOK MISSING FASTENER. INSTALLED FASTENER IN R2 DOOR EVAC SLIDE HOOK PER MM.SDR SWAA032702Splice · crackedDURING SPECIAL VISIT FOUND STRINGER SPLICE CRACKED AT BS 908, STRINGER 4R AND 4L. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA032688Skin · crackedCYXX - DURING SPECIAL VISIT FOUND SKIN CRACKED AT BS 787 BELOW STRINGER 13R. REPAIRED SKIN PER ERO. (M)SDR SWAA032687Splice · crackedCYXX - DURING SPECIAL VISIT CRACKED STRINGER SPLICE AT BS 360 STRINGER 4L, 4R AND 14R. REMOVED AND REPLACED STRINGER SPLICE PER SRM. (M)SDR SWAA032686Shear Tie · crackedDURING SPECIAL VISIT FOUND SHEAR TIES CRACKED AT BS 807 STRINGER 14L, BS 767 STRINGER 14L, BS 360 STRINGER 14L. REPAIRED PER SRM. (M)SDR SWAA032685Window Frame · crackedCYXX - DURING SPECIAL VISIT CRACK INDICATION AT WINDOW 12 BS 530. REMOVED AND REPLACED WINDOW FRAME PER MM. (M)SDR SWAA032684Window Frame · crackedCYXX - DURING SPECIAL VISIT, FOUND CRACK INDICATION AT WINDOWS 28 AND 29, BS 777 AND BS 787. REPAIRED CRACK PER ERO. (M)SDR SWAA032663Shear Tie · crackedDURING SPECIAL VISIT FOUND SHEAR TIE CRACKED BETWEEN STR L 13 AND L 14, BS 787. REPAIRED DAMAGE PER SRM.SDR SWAA032304Lens · looseLT OVERWING EMERGENCY EXIT LIGHT COVER LOOSE. SECURED LENS COVER PER MM.SDR SWAA031924Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING UPPER SKIN CRACKED AT WBL 181. REPAIRED SKIN PER SWA EA.SDR SWAA031835Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 714, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA031822Attach Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FWD AND AFT GIRT BAR ATTACHMENT FITTINGS CORRODED. REMOVED AND REPLACED ATTACHMENT FITTINGS PER MM.SDR SWAA031812Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 972, BELOW STR 21L. REPAIRED SKIN PER SRM.SDR SWAA031801Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) BS 727D + 4 AT STR 19R AND BS 944 AT STR 23L. REPAIRED SKIN PER SRM.SDR SWAA031778Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 727A, STR 19L AND STR 25L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA030442Cable · misroutedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022708Slide · looseDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE LOOSE IN CONTAINER. SECURED SLIDE PER MM.SDR SWAA022707Cable · misroutedDURING SCHEDULED CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA020774Frame · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR FWD OUTER FRAME CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA011772Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE FWD ATTACH BRACKET CRACKED. R&R EMERGENCY EVAC SLIDE ATTACH BRACKET PER MM.SDR SWAA011771Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 11R. REPAIRED SKIN PER SRM.SDR SWAA011512Slide · out of adjFWD ENTRY & FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BARS CONTACT DOOR FRAME WHEN DOORS ARE OPENED. REMOVED AND REPLACED EMERGENCY EVAC SLIDES AND CONTAINERS PER MM.SDR SWAA011169Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. R&R EVAC SLIDE ASSY PER MM.SDR SWAA010807Battery · dischargedEMERGENCY FLASHLIGHT INOP IN AFT CABIN. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA010770Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND WINDOW POST CRACKED AT LT SIDE, BETWEEN CAPT''S NR 1 & NR 2 WINDOWS. REPAIRED WINDOW POST PER SRM.SDR SWAA010754Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND 6 BS 178 BULKHEAD WEB CRACKS AT RBL 5.0 TO LBL 7.0, WL 199 TO WL 207. REPAIRED BULKHEAD WEB PER SWA RA.SDR SWAA010753Slide · frayedDURING SCHEDULED 1/4D CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY FRAYED AT INBD EDGES. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010731Slide · frayedDURING SCHEDULED 1/4D CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE GIRT ASSY FRAYED & STRAPS UNGLUED. REMOVED AND REPLACED EVAC SLIDE ASSY PER MM.SDR SWAA010722Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND STR 28L CLIP CRACKED AT BS 867. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA010696Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 178 BULKHEAD SHEAR TIE CRACKED AT FWD FASTENER HOLE, LT SIDE, WL 208. REPAIRED SHEAR TIE ANGLE PER SWA RA.SDR SWAA010437Light · looseEEPLS LOOSE IN FWD SECTION. SECURED EEPLS PER MM.SDR SWAA001910Stiffener · crackedTWO STIFFENERS FOUND CRACKED AT FWD BULKHEAD BS 663, MLG W/W. REMOVED AND REPLACED STIFFENERS PER SRM.SDR SWAA001876Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STIFFENER AT BS 663, LBL 6 & RBL 6. REMOVED AND REPLACED STIFFENERS PER SRM.SDR SWAA001551Cable · misroutedDURING SCHEDULED RON CHECK, FOUND AFT DOOR EVACUATION SLIDE GIRT CABLE ASSY MISROUTED. REPOSITIONED CABLE PER MM.SDR SWAA001145Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR READING LOW. R & R SLIDE ASSY PER MM.SDR SWAA982049Floorbeam · gougedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD, UPPER SURFACE FWD EDGE GOUGED AT BS 986.5, WL 208, LBL 49. REPAIRED PER BOEING SRM.SDR SWAA981987Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED UPPER SURFACE OF WEB AT BS 429, WL 208, RBL 70. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981986Bracket · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED L-BRACKET AT BS 344, STR 12R. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981985Intercostal · dentedDURING SCHEDULED D-CHECK, FOUND DENTED INTERCOSTAL AT BS 428, LBL 45, WL 166. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981984Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT STR 16L, BS 295 FWD OF FWD ENTRY DOORWAY. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981983Skin · gougeDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOORWAY FUSELAGE TORQUE TUBE CAVITY GOUGE ON INSIDE OF SKIN. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981982Skin · dentedDURING SCHEDULED D-CHECK, FOUND TWO DENTS IN FUSELAGE SKIN AT BS 468 AND 474 BETWEEN STRINGER 22 AND 23 LT. REPAIRED PER BOEING SRM.SDR SWAA981981Skin · dentedDURING SCHEDULED D-CHECK, FOUND TWO DENTS IN SKIN AT BS 348 AND 346, WL 200 BETWEEN STRINGERS 17 AND 18 RT. REPAIRED PER BOEING SRM.SDR SWAA981980Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED SKIN AT BS 342, WL 205 BETWEEN STRINGER 17 AND 18 RT. REPAIRED PER BOEING SRM.SDR SWAA981979Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED SKIN AT BS 241, WL 170, LBL 59. REPAIRED PER BOEING SRM.SDR SWAA981976Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 294.5, RBL 47, WL 208 CORRODED ON UPPER FLANGES. REPAIRED PER BOEING SRM.SDR SWAA981975Stabilizer · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR STABILIZER CRACKED AT BS 314, LBL 12, WL 198.5. REPAIRED PER BOEING SRM.SDR SWAA981974Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BETWEEN STR 8R AND STR 9R AT BS 727D AND BS 727B. REPAIRED PER TRAMCO EWO NR 98-0751.
Back to N338SW, cancelled Oct 26, 2012