N671SW, cancelled Jan 3, 2013
Service difficulty reports · 308
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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 = 'N671SW' AND deregistration_id = 'N671SW-2013-01-03' 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 SWAA104152Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104151Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104150Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104149Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104148Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 328, ABOVE L1 DOOR. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA104147Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REMOVED AND REPLACED FRAME PER EA.SDR SWAA104146Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA104113Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA104092Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104091Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104090Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104081Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA104080Bracket · crackedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA104079Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104078Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104031Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA104030Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA103793Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING O/B AFT FLAP T/E DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA102389Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA101316Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 929, STR 24L. REPAIRED SKIN PER EA.SDR SWAA101315Slide · out of adjustDURING SCHEDULED 2HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED SLIDE PER MM.SDR SWAA101314Door Frame · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FWD CARGO DOOR FWD FRAME CRACKED AT RADIUS COMMON WITH FWD MOST LOWER STOP FITTING. REMOVED AND REPLACED DOOR PER MM.SDR SWAA101313Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 932, STR 24L. REPAIRED SKIN PER EA.SDR SWAA100443Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT EMERGENCY EXIT SIDEWALL LIGHT INOP BETWEEN ROW 15 TO ROW 16. RELAMPED PER MM.SDR SWAA100442Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA096634Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA095433Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT NR 1 SLAT UPPER WEDGE SKIN DELAMINATED. REMOVED AND REPLACED NR 1 SLAT PER MM.SDR SWAA095432Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA095342Flap · puncturedDURING SCHEDULED MV4 CHECK, FOUND RT WING I/B AFT FLAP PUNCTURED. REMOVED AND REPLACED AFT FLAP EPR MM.SDR SWAA094933Hydraulic Line · leakingAIR TURNBACK, AFTER TAKEOFF B-HYDRAULIC PUMP LIGHT ILLUMINATED NOTICED "B" QYT MOVING TO 1/4 TURNED OFF BOTH "B" PUMPS RESERVOIR QTY 1/4 AT GATE. REMOVED AND REPLACED STEEL FLEX HOSE AT B-ELECTRIC HYDRAULIC PUMP PER MM.SDR SWAA094656Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND LT CENTER CABIN EMERGENCY BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA094640Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND 1016 AFT PRESSURE BULKHEAD DOME CAP WEB CRACKED AT 12:30 TO 1:00 O'CLOCK POSITION. REMOVED AND REPLACED WEB PER SRM.SDR SWAA094639Skin · puncturedDURING SCHEDULED SPV CHECK, FOUND LT WING L/E NR 1 SLAT SKIN PUNCTURED. REPAIRED SKIN PER SRM.SDR SWAA094434Cover · looseDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT DOOR LENS COVER LOOSE. SECURED COVER PER MM.SDR SWAA090902Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA090901Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA090900Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA087076Slide · out of adjustR2 EMERGENCY EVAC DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA084158Pressure Panel · crackedDURING SCHEDULED 20Y CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 663, LBL 39. REPAIRED WEB PER EA.SDR SWAA084157Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD SERVICE DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA084196Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA084122Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA084001Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD ENTRY DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA084065Sign · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CABIN EMERGENCY EXIT SIGN CRACKED. R&R EXIT SIGN PER MM.SDR SWAA083824Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 847 TO BS 867, LBL 70. REPAIRED WEB PER SRM AND BOEING DRAWING.SDR SWAA083872Bearing · wornDURING SCHEDULED 20Y CHECK, RT ELEVATOR FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT HORN BEARING PER MM.SDR SWAA083796Housing · brokenDURING SCHEDULED 20Y CHECK, FOUND AFT GALLEY EMERGENCY EXIT LIGHT HOUSING BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA083593Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 827 AND BS 847, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA083592Light · brokenDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA083531Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N671SW, cancelled Jan 3, 2013