N620SW, cancelled Nov 15, 2018
Service difficulty reports · 407
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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-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 SWAA095340Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA091719Lug · brokenDURING SCHEDULED MV1 CHECK, FOUND RT WING NR 4 SPOILER O/B ACTUATOR ATTACHMENT LUG BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA086080Cable · arcedFOUND CAPT SLIDING WINDOW ANTI ICE POWER CABLE ARCED. REMOVED AND REPLACED CABLE PER MM.SDR SWAA085708Slide · out of adjustFOUND R2 DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA081300Skin · wornDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN WORN UNDER DORSAL FIN BETWEEN BS 857 TO BS 887. REPAIRED SKIN PER EA.SDR SWAA081160Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 847, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081145Bearing · wornDURING SCHEDULED BRDG CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BEARING PER MM.SDR SWAA081144Bearing · wornDURING SCHEDULED BRDG CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BEARING PER MM.SDR SWAA081117Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081116Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081115Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081061Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081062Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081018Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081023Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380 STR 7L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081022Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081021Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081020Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081019Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080988Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 9R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080987Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080986Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080985Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080984Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080518Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA074079Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA073288Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073287Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073286Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072232Stiffener · crackedDURING SCHEDULED SPV CHECK, FOUND RIGHT W/W VERTICAL STIFFENER CRACKED AT BS 663, RBL 6.15. REPAIRED STIFFENER PER SRM.SDR SWAA064889Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND RIGHT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA060168Cable · misroutedDURING SCHEDULED A1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA053930Battery · inoperativeFWD OUTBOARD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERY PER MM.SDR SWAA053872Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 744A, RBL 26.5. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA053871Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOORBEAM CORRODED AT BS 260, LBL 6 TO RBL 11, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA053856Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 867, RBL 9. REPAIRED SHEAR TIE PER SRM.SDR SWAA053855Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 807, RBL 1. REPAIRED SHEAR TIE PER SRM.SDR SWAA053854Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, RBL 9 TO RBL 11. REPAIRED SHEAR TIE PER SRM.SDR SWAA053853Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 747, RBL 10. REPAIRED SHEAR TIE PER SRM.SDR SWAA053852Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 727E, LBL 5. REPAIRED SHEAR TIE PER SRM.SDR SWAA053851Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 727B, LBL 3. REPAIRED SHEAR TIE PER SRM.SDR SWAA053830Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 17R. REPAIRED FRAME IAW SRM.SDR SWAA053838Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, BETWEEN LBL 41 TO RBL 19. REMOVED AND REPLACED FRAME SECTION IAW SRM.SDR SWAA053837Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, BETWEEN STR 23L TO STR 23R. REMOVED AND REPLACED FRAME SECTION ISW SRM.SDR SWAA053802Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT HORIZONTAL STAB ATTACH FITTING LUG FACES CORRODED. REPAIRED LUG FACES PER SRM.SDR SWAA053801Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 787, LBL 2 TO RBL 7. REPAIRED SHEAR TIE PER SRM.SDR SWAA053800Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED BETWEEN BS 294 TO BS 296, RBL 54.5, WL 209. REPAIRED FRAME PER BFG ER.SDR SWAA053767Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 727B, RBL 1 TO RBL 2. REPAIRED SHEAR TIE PER SRM.SDR SWAA053766Channel · corrodedDURING SCHEDULED D CHECK, FOUND COCKPIT FLOOR Z-CHORD CORRODED AT BS 270, BETWEEN LBL 11 TO RBL 11, WL 208. REMOVED AND REPLACED Z-CHORD PER SRM.SDR SWAA053738Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500A, RBL 1. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to N620SW, cancelled Nov 15, 2018