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 SWAA097372Battery Pack · inoperativeDURING SCHEDULED SPV CHECK, FOUND OVERHEAD EMERGENCY EXIT BULLNOSE LIGHTS INOP BETWEEN ROW 12 TO ROW 21. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA097371Battery Pack · no testDURING SCHEDULED SPV CHECK, RT FWD EMERGENCY LIGHT BATTERY PACK FAILED CHECK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA097370Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING O/B AFT FLAP T/E DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA096627Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA096010Fitting · looseDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. REMOVED AND REPLACED FITTING PER MM.SDR SWAA095687Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT VERTICAL STAB FITTING LUG FACES AT AFT SPAR CORRODED, STA 1088. REPAIRED FITTING PER SWA EA.SDR SWAA095686Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR UPPER SKIN CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA095656Spar · corrodedDURING SCHEDULED MV1 CHECK, FOUND RT VERTICAL STABILIZER AFT SPAR CORRODED AT STA 209.90. REMOVED AND REPLACED VERTICAL STABILIZER PER MM.SDR SWAA095640Attach Fitting · wornDURING SCHEDULED MV1 CHECK, FOUND RT VERTICAL STABILIZER AFT FAIL SAFE ATTACH LUG WORN. REPAIRED LUG PER SWA EA.SDR SWAA095616Fitting · corrodedDURING SCHEDULED MV1 CHECK, FOUND RT VERTICAL STABILIZER FITTING LUG FACES CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA095362Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER SKIN CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA093203Lens · missingDURING SCHEDULED CV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA092600Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090899Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA090661Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FWD NOSE COMPARTMENT LOWER BILGE CHORD CORRODED AT BS 227, BETWEEN RBL 8 TO LBL 6. REPAIRED CHORD PER EA.SDR SWAA090657Skin · corrodedDURING SCHEDULED BRDG CHECK, FOUND LOWER SKIN CORRODED AT BS 227, BETWEEN RBL 8 TO LBL 6. REPAIRED SKIN PER SWA EA.SDR SWAA090234Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA090008Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 727E, STR 10L. REPAIRED STRINGER PER SRM.SDR SWAA087432Charger · inoperativeDURING SCHEDULED 24Y CHECK, EMERGENCY EXIT LIGHT BATTERY CHARGER INOP. REMOVED AND REPLACED CHARGER PER MM.SDR SWAA087431Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND KEEL BEAM WEB CORRODED AT BS 710, BETWEEN LBL 6 TO RBL R. REPAIRED BEAM PER SRM.SDR SWAA087430Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED AT BETWEEN BS 639 TO BS 667, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087429Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, LBL 17.7. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA087428Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BBL 0. REMOVED AND REPLACED SHEAR TIE PER SRM..SDR SWAA087427Floorbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT STUB FLOORBEAM CORRODED AT BS 639, RBL 70, WL 137. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA087426Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND RT CREASE BEAM WEB CRACKED BETWEEN BS 616 TO BS 639, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087425Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM L ANGLE CRACKED AT BS 727B, LBL 45, WL 206. REPAIRED BEAM PER SRM.SDR SWAA087424Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND LT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA087423Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 352, LBL 50, WL 195. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087422Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 305, WL 238. REPAIRED SKIN PER PAE ER.SDR SWAA087421Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS. 303, WL 234. REPAIRED SKIN PER PAE ER.SDR SWAA087420Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND RT FRAME OUTER CHORD WEB CRACKED AT BS 639, WL 209. REPAIRED WEB PER PAE ER.SDR SWAA087419Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND RT FRAME INNER CHORD WEB CRACKED AT BS. 639, WL 209. REPAIRED WEB PER PAE ER.SDR SWAA087418Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS. 708, RBL 24, WL 202. REPAIRED WEB PER PAE ER.SDR SWAA087417Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BETWEEN BS 712 TO BS 713, BL 0, WL 202. REPAIRED WEB PER PAE ER.SDR SWAA087416Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 706, BL 0, WL 140.5. REPAIRED WEB PER PAE ER.SDR SWAA087415Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS. 303 WL 236. REPAIRED SKIN PER ER.SDR SWAA087414Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 304, WL 235. REPAIRED SKIN PER ER.SDR SWAA087413Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 304, WL 258. REPAIRED SKIN PER ER.SDR SWAA087412Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 303, WL 258. REPAIRED SKIN PER ER.SDR SWAA087411Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO AFT BULKHEAD FRAME CORRODED AT BS 1006, BETWEEN STR 22L TO STR 23L. REPAIRED FRAME PER SRM.SDR SWAA087370Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 2 SLAT T/E WEDGE O/B END LOWER SURFACE DELAMINATED. REMOVED AND REPLACED SLAT PER SRM.SDR SWAA087297Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING O/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA087296Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087256Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500A, LBL 17. REPAIRED FRAME PER SRM.SDR SWAA087233Fastener · looseDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR ESCAPE SLIDE FWD LOWER GIRT BAR HOOK LOOSE. REMOVED AND REPLACED FASTENER PER MM.SDR SWAA087232Fastener · looseDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR ESCAPE SLIDE FWD LOWER GIRT BAR HOOK LOOSE. REMOVED AND REPLACED FASTENER PER MM.SDR SWAA087221Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED SKIN PER MM.SDR SWAA087220Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087202Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BBL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA087164Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, LBL 3. REPAIRED SHEAR TIE PER SRM.
Back to N657SW, cancelled Mar 15, 2018