N672SW, cancelled Dec 22, 2014
Service difficulty reports · 224
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 = 'N672SW' AND deregistration_id = 'N672SW-2014-12-22' 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 = 'N672SW' AND deregistration_id = 'N672SW-2014-12-22' 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 SWAA010505Frame · crackedDURING SCHEDULED D-CHECK, FOUND FWD SVC DOOR CUTOUT FWD UPPER FRAME CRACKED AT UPPER INBD RADIUS, BS 296.5, WL 274. REPAIRED UPPER FRAME PER SRM.SDR SWAA010504Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L & 14L.SDR SWAA010503Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 500D, 2 ABOVE STR 13R. REPAIRED FRAME PER SRM.SDR SWAA010488Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 12 STRINGER CLIPS CRACKED, BS 559-BS 727A, STRINGERS 10L, 5R, 8L, 5L, 4L, 1, 2L, 6R, 7R, 3L & 6L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA010487Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED, BS 500B, STR 9L, BS 500D, STR 5L, BS 520, STRS 5R, 6L & 8L, BS 1121, STR 21L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA010486Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA010476Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED, LBL 4.7, WL 212-213. REPAIRED BULKHEAD PER SRM.SDR SWAA010453Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD WEB CRACKS AT LBL 12 TO LBL 13, WL 218 & RBL 6.7, WL 200 TO WL 201. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA010464Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 15L & 16L. REPAIRED SHEAR TIE PER SRM.SDR SWAA010463Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 380, STR 8L, BS 520, STR 16L, BS 500D, STR 3L, 6L, 7L, 8L, 5R, & 8R, BS 500C, STR 7R, BS 360, STR 5L, BS 360, STR 2L, BS 344, STR 11R, BS 639, STR 8L, BS 597, STR 8R, & BS 663.75, STR 10R. REMOVED AND RESDR SWAA010462Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 1040, BETWEEN STR 2L & 3L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA010433Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT STR 8R, BS 578 & 637, STR 7R, BS 557, STR 8L, BS 616, STR 4R, BS 616, & STR 6L BS 597 & 616. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010454Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STR CLIPS CRACKED AT BS 616, STR 3R, BS 639, STR 4R & BS 706, STR 2L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA010465Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND BOTH FWD ENTRY DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA002452Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA002372Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EXTERNAL FUSELAGE SKIN CRACKS AT BS 727D, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA002339Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EXIT SIGN HAS THREE BULBS INOP. REMOVED AND REPLACED BULBS PER MM.SDR SWAA002337Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR LOWER EMERGENCY LIGHT HAS SEVERAL BULBS INOP. REPLACED BULBS PER MM.SDR SWAA002335Lens · missingDURING SCHEDULED C1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA002338Cover · brokenDURING SCHEDULED C1 CHECK, FOUND EEPLS COVER BROKEN NEAR MID CABIN LOUNGE.SDR SWAA002336Retainer · looseDURING SCHEDULED C1 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR STOWAGE RETAINER HOOKS LOOSE. SECURED HOOKS PER MM.SDR SWAA001957Bottle · dischargedDURING SCHEDULED A2 CHECK, FOUND FWD ENTRY EMERGENCY EVAC SLIDE PRESSURE IND BELOW LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA001513Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA001435Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE EXTERNAL SKIN CRACKED, BS 727D+18, STRINGER 22R. REPAIRED SKIN PER SRM.SDR SWAA001159Light · looseEEPLS TRACK LOOSE AT ROW 8. SECURED TRACK ASSY PER MM.SDR SWAA001038Cable · misroutedAFT ENTRY DOOR EVACUATION SLIDE GIRT BAR RELEASE CABLE OUT OF POSITION. REROUTED CABLE PER MM.SDR SWAA000843Slide · dislodgedDURING SCHEDULED C3 CHECK, FOUND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY OUT OF POSITION. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA000746Slide · dislodgedAFT ENTRY DOOR EVACUATION SLIDE FALLING OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA000445Skin · crackedDURING SCHEDULED SERVICE, FOUND EXTERNAL FUSELAGE SKIN CRACKED, BS 727B, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA000429Skin · crackedDURING WALK-AROUND CHECK, FOUND EXTERNAL FUSELAGE SKIN CRACKED, BS 747, STRINGER 20L. ALSO, FOUND ANOTHER CRACK AT BS 727B, STRINGER 23R. REPAIRED SKIN PER SRM.SDR SWAA000213Lens · missingDURING SCHEDULED C2 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING AT ROW 23. INSTALLED LENS PER MM.SDR SWAA992112Indicator · malfunctionedAIR TURNBACK, T/E FLAP POSITION INDICATION OF FLAPS NOT RETRACTING BETWEEN 2 AND 5 DEGREES. RESET T/E FLAP POSITION INDICATOR C/B, RESEATED T/E FLAP POSITION TRANSMITTER CONNECTOR. OPERATED T/E FLAPS, OPS CK GOOD. LATER DURING RON AT BWI REMOVED AND REPLACESDR SWAA990143Charger · inopDURING SCHEDULED SC CHECK, FOUND LT AND RT OVERWING EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY CHARGER PER BOEING MM.SDR SWAA990031Fan Blabe · damagedDURING CLIMB-OUT FROM SMF WE HIT A FLOCK OF LARGE BIRDS, ONE OR MORE IMPACTED NR 2 ENGINE. THE ENGINE RAN NORMAL AT IDLE POWER, BUT WE HAD AIRFRAME VIBRATION AND A BURN SMELL FROM THE RIGHT PACK. AIRCRAFT DIVERTED INTO OAK AND MADE AN UNEVENTFUL LANDING. PESDR SWAA983004Web · crackedDURING SCHEDULED 1/4D CHECK, FOUND CRACK IN BEADED PRESSURE WEB AT BS 664. REPAIRED PER SWA RA 1-353-1929.SDR SWAA983003Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND 2 ADJACENT CRACKS IN FUSELAGE SKIN AT AFT LOWER CORNER OF FWD SERV DOOR CUTOUT. REPAIRED BOEING SRM.SDR SWAA983002Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND A CRACK INDICATION IN FUSELAGE SKIN EMANATING FROM FASTENER HOLE AT BS 348 BELOW FWD ENTRY DOOR. REPAIRED SWA RA 1-353-193 AND BOEING DRAWING 65C27257.SDR SWAA982989Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND RT WING FIXED L/E CRACKED AT NR 6 SLAT I/B AUX TRACK CUTOUT. REPAIRED PER BOEING SRM.SDR SWAA983005Wire · brokenDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY EXIT LIGHTS INOP AT OVERWING EXITS. REPAIRED BROKEN WIRE AND OP CHECKED PER BOEING M/M.SDR SWAA982943Skin · crackedDURING SCHEDULED 1/4 D CHECK, FOUND A FUSELAGE SKIN CRACK EMANATING FROM A RIVET HOLE AT FWD UPPER CORNER OF AIRSTAIRS CUTOUT. REPAIRED PER SWA RA 1-353-1940.SDR SWAA982889Strap · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED FLOORBEAM STRAP AT BS 770. REMOVED AND REPLACED STRAP PER BOEING SRM.SDR SWAA982888Strap · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION AROUND SCREW HOLES OF STRAP AT BS 860. REMOVED AND REPLACED STRAP PER BOEING SRM.SDR SWAA982887Fastener · crackedDURING SCHEDULED 1/4D CHECK, FOUND 2 HFEC CRACKED INDICATIONS COMING FROM HI-LOK AT WL 234, LBL 11 (FWD SIDE). REPAIRED PER BOEING SRM.SDR SWAA982886Fastener · crackedDURING SCHEDULED 1/4D CHECK, FOUND HFEC CRACKED INDICATIONS COMING FROM HI-LOK AT WL 234, RBL 9 (FWD SIDE). REPAIRED PER BOEING SRM.SDR SWAA982885Angle · crackedDURING SCHEDULED 1/4D CHECK, FOUND SUPPORT ANGLE CRACKED AT BS 540, STR 21. REPAIRED PER BOEING SRM.SDR SWAA982847Angle · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 540, STR 21 SUPPORT ANGLE CRACKED. REPAIRED PER BOEING SRM.SDR SWAA982846Floorbeam · misdrilledDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM ERRANT HOLE AT BS 500, LBL 13. REPAIRED PER BOEING SRM.SDR SWAA982845Floorbeam · damagedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM KNICKED AT BS 503, RBL 9. REPAIRED PER BOEING SRM.SDR SWAA982801Wheel · damagedAFTER LANDING FOUND EVIDENCE LEFT MAIN LANDING GEAR DEPARTED RUNWAY INTO DIRT. PERFORMED INSP PER 05-51-51-2, NO DAMAGE FOUND ON A/C. REMOVED AND REPLACED NR 1 MAIN AND NR 2 MAIN WHEEL ASSY AS PER CAUTION.SDR SWAA971011Slide · deployedWHILE DEPLANING, AFT ENTRY DOOR SLIDE DEPLOYED. REPLACED PER BOEING M/M.
Back to N672SW, cancelled Dec 22, 2014