N657SW, cancelled Mar 15, 2018
Service difficulty reports · 446
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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-15' 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 = 'N657SW' AND deregistration_id = 'N657SW-2018-03-15' 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 SWAA087040Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 727B, STR 18R. REPAIRED FRAME PER SRM.SDR SWAA086992Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086991Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086990Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA086989Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA086879Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086866Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 927, STR 21R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086865Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER SWA EA.SDR SWAA086864Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA083870Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083906Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081894Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 829, RBL 13. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081892Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 792, RBL 13. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081893Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 849, RBL 13. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081840Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 829, RBL 13. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081839Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 849, RBL 13. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081808Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 792, RBL 13. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080581Flap Track · wornDURING SCHEDULED BRDG CHECK, FOUND RIGHT WING NR 7 T/E AFT FLAP TRACK WORN. REMOVED AND REPLACED FLAP TRACK PER MM.SDR SWAA080569Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA080568Slat · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING NR 3 L/E SLAT CRACKED AT INBOARD END. REMOVED AND REPLACED SLAT PER MM.SDR SWAA080537Lamp · inoperativeDURING SCHEDULED 22Y CHECK, FOUND EEPLS INOP AT ROW 18 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080519Bulkhead · corrodedDURING SCHEDULED 22Y CHECK, FOUND MLG BULKHEAD CORRODED AT BS 663.75, LBL 2 TO LBL 4. REPAIRED BULKHEAD PER SRM.SDR SWAA080443Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 344, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA080305Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 427, LBL 1.2. REPAIRED SKIN PER EA.SDR SWAA080306Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080242Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 12L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA076172Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074595Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA074315Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074304Cylinder · failedLEFT MLG NR 1 AXLE INNER CYLINDER DAMAGED DUE TO NR 1 WHEEL BEARING FAILURE. REMOVED AND REPLACED INNER CYLINDER PER MM.SDR SWAA074268Drag Brace · corrodedDURING SCHEDULED SERVICE CHECK, FOUND LEFT MLG LOWER DRAG BRACE BUSHING AND TEE FITTING CORRODED. REMOVED AND REPLACED DRAG BRACE PER MM.SDR SWAA071398Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA070661Fitting · brokenDURING SCHEDULED C2 CHECK, FOUND LT WING NR 4 SPOILER OUTBOARD FITTING BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA070660Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP DELAMINATED OUTBOARD T/E END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA064988Shear Tie · crackedDURING SCHEDULED MV1 CHECK, FOUND SHEAR TIE CRACKED AT BS 380, STR 16L. REPAIRED SHEAR TIE PER SRM.SDR SWAA064742Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA064459Socket · dirtyDURING SCHEDULED MV1 CHECK, FOUND BULLNOSE EMERGENCY LIGHT INOP AT 13 ABC. CLEANED LIGHT SOCKET. OPS CK GOOD.SDR SWAA062610Bolt · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT INBOARD ELEVATOR TAB HINGE BOLT PER MM.SDR SWAA061660Slide · out of adjustR1 DOOR EMERGENCY EXIT EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA060334Indicator · false indicationWITH MLG HANDLE IN DOWN POSITION-3 RED & 3 GREEN INDICATOR LIGHTS ILLUMINATED. RECYCLED GEAR HANDLE, ALL INDICATIONS RETURNED TO NORMAL. CHECKED OPERATION OF MLG HANDLE & SWITCH. INSPECTED MLG ASSY, ALL INDICATIONS NORMAL.SDR SWAA052986Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING NR 4 L/E SLAT T/E INBD LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA052955Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING NR 3 L/E SLAT T/E LOWER SKIN CRACKED. REMOVED AND REPLACED NR 3 SLAT PER MM.SDR SWAA052880Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND STR SPLICE CRACKED AT BS 359, STR 14L. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA052867Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 344, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA052866Splice · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER SPLICE CRACKED AT BS 359, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA052865Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 312, STR 6R. REPAIRED FRAME PER SRM.SDR SWAA052848Keelbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND KEELBEAM CORRODED AT BS 727, LBL 7. REPAIRED KEELBEAM PER SWA EA & SRM.SDR SWAA052837Post · crackedDURING SCHEDULED 1/2D CHECK, FOUND L1 COCKPIT WINDOW POST CRACKED AT UPPER OUTBOARD CORNER. REPAIRED WINDOW POST PER SRM.SDR SWAA052836Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 957, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA052791Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.
Back to N657SW, cancelled Mar 15, 2018