N613SW, cancelled Jan 2, 2019
Service difficulty reports · 268
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 = 'N613SW' AND deregistration_id = 'N613SW-2019-01-02' 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 = 'N613SW' AND deregistration_id = 'N613SW-2019-01-02' 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 SWAA115545Battery Pack · dischargedAFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK IAW MM.SDR SWAA114044Floor Support · corrodedDURING SCHEDULED 16Y CHECK FOUND, AFT CARGO FLOOR SUPPORT BEAM CORRODED AT BS 943, LBL 17. REPAIRED BEAM PER EA.SDR SWAA113997Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, FRAME CORRODED AT BS 807, BETWEEN LBL 5 TO RBL 5. REPAIRED FRAME PER SRM.SDR SWAA113996Keelbeam · corrodedDURING SCHEDULED 16Y CHECK FOUND, KEEL BEAM CORRODED AT BS 807, RBL 7. REPAIRED BEAM PER SRM.SDR SWAA113995Wedge · delaminatedDURING SCHEDULED 16Y CHECK FOUND, LT WING NR 2 SLAT O/B T/E WEDGE DELAMINATED. REPAIRED SLAT EPR SRM.SDR SWAA113900Web · crackedDURING SCHEDULED 16Y CHECK FOUND, CENTER CABIN BEADED WEB CRACKED AT BS 671, RBL 39. REPAIRED WEB PER EA.SDR SWAA113899Web · crackedDURING SCHEDULED 16Y CHECK FOUND, CENTER CABIN BEADED WEB CRACKED AT BS 671, LBL 41. REPAIRED WEB PER EA.SDR SWAA113898Floorbeam · crackedDURING SCHEDULED 16Y CHECK FOUND, LONGITUDINAL FLOORBEAM LOWER CHORD L ANGLE CRACKED AT BS 663.75, RBL 45.50. REPAIRED ANGLE PER EA.SDR SWAA113769Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113768Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113767Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 500A TO BS 500B, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113766Crease Beam · corrodedDURING SCHEDULED 16Y CHECK FOUND, LT CREASE BEAM WEB CORRODED BETWEEN BS 414 TO BS 418, STR 17L. REPAIRED BEAM PER BAC DWG AND EA.SDR SWAA113624Floorbeam · corrodedDURING SCHEDULED 16Y CHECK FOUND, FLOORBEAM CORRODED AT BS 312, BL 0. REPAIRED BEAM PER SRM.SDR SWAA113623Floorbeam · corrodedDURING SCHEDULED 16Y CHECK FOUND, AFT GALLEY FLOOR BEAM FLANGE CORRODED AT BS 986, BETWEEN RBL 36 TO RBL 42. REMOVED AND REPLACED BEAM PER MM.SDR SWAA113622Shear Tie · corrodedDURING SCHEDULED 16Y CHECK FOUND, SHEAR TIE CORRODED AT BS 1006, BL 0. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113621Stringer Clip · crackedDURING SCHEDULED 16Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113620Stringer Clip · crackedDURING SCHEDULED 16Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113619Stringer Clip · crackedDURING SCHEDULED 16Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113368Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD OPC CRADLE SKIN CUTOUT CRACKED AT BS 255, RBL 23. REPAIRED SKIN PER ACO.SDR SWAA107842Strap · brokenDURING SCHEDULED SPV CHECK, FOUND FWD EMERGENCY FLASHLIGHT BREAK-AWAY RETAINER STRAPS BROKEN. REMOVED AND REPLACED STRAPS PER MM.SDR SWAA107841Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107283Sign · brokenLT FWD EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA106062Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA103570Web · crackedRT SIDE WEB NOSE WHEEL WELL BETWEEN ACCESS PANELS CRACKED AT BS 259, WL 174. REPAIRED WEB PER EA.SDR SWAA095338Light · looseLEFT EMERGENCY EXIT BULLNOSE LIGHT LOOSE AT ROW 2. SECURED LIGHT PER MM.SDR SWAA095204Lens · looseDURING SCHEDULED SPV CHECK, FOUND LT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA094753Battery · dischargedAFT FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA094022Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 304.65, WL 258.38. REPAIRED SKIN PER EA.SDR SWAA093986Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA093982Flap · delaminatedDURING SCHEDULED 14Y CHECK, FOUND LT WING I/B FOREFLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA093981Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 304.65, WL 238.18. REPAIRED SKIN PER SRM.SDR SWAA093961Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 304.65, WL 262.38. REPAIRED SKIN PER EA.SDR SWAA093843Frame · crackedDURING SCHEDULED 14YD CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093827Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093759Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093719Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093718Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093717Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA093716Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093715Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA093593Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093370Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR AT UPPER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA092832Isolation Valve · leakingAIR TURNBACK / DECLARED EMERGENCY. LOST "A" SYSTEM HYDRAULICS ON TAKEOFF. REMOVED AND REPLACED MANUAL ISOLATION VALVE FOR NR 2 RUDDER PCU/YAW DAMPER PER MM.SDR SWAA090224Strap · out of positionLT OVERWING EMERGENCY EXIT DOOR STRAP OUT OF POSITION. REPOSITIONED STRAP PER MM.SDR SWAA087129Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA087074Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, RBL 5.7. REPAIRED WEB PER ER.SDR SWAA087073Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178, LBL 5.7. REPAIRED WEB PER ER.SDR SWAA087029Frame · crackedDURING SCHEDULED SPV CHECK, FOUND BS 178 BULKHEAD CHORD CRACKED, LBL 17, WL 218. REPAIRED WEB PER SRM.SDR SWAA087028Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BS 178 BULKHEAD VERTICAL WEB CRACKED, LBL 17, WL 228. REPAIRED WEB PER SRM.SDR SWAA086152Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to N613SW, cancelled Jan 2, 2019