N357SW, cancelled Mar 22, 2018
Service difficulty reports · 356
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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 = 'N357SW' AND deregistration_id = 'N357SW-2018-03-22' 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 SWAA097283Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 19R TO STR 20R. REPAIRED FRAME PER SRM.SDR SWAA095941Slide · out of positionDURING SCHEDULED MV1 CHECK, L1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA094911Flap · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND LT WING I/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA094910Door Frame · crackedDURING SCHEDULED 2HC2 CHECK, FOUND LEFT A/C BAY DOOR FRAME CRACKED AT BS 540. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA094449Detector · faultyDECLARED EMERGENCY, APU FIRE INDICATION IN FLIGHT. DISCHARGED THE APU FIRE BOTTLE BUT THE FIRE INDICATION STAYED "ON" ALL THE WAY TO LANDING. REMOVED AND REPLACED M717, M515, M334 APU FIRE DETECTORS.SDR SWAA091852Gasper Fan · faultySULFUR SMELL NOTED ON CLIMBOUT. NO ABNORMAL INDICATIONS OR SMOKE NOTED. ODOR STRONGEST AT ROW 4. FLIGHT ATTENDANT NOTICED SIMILAR ODOR ON DESCENT. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA090402Sign · looseDURING SCHEDULED HC1 CHECK, FOUND LT EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA086077Slide · out of adjustFOUND R2 DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA086076Slide · out of adjustFOUND L2 DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA085133Fire Detector · faultyAT FL 8000 APU FIRE WARNING LIGHT ILLUMINATED AND WARNING SOUNDED, DISCHARGED FIRE BOTTLE AND LIGHT EXTINGUISHED. REMOVED AND REPLACED OVERHEAT DETECTOR PER MM.SDR SWAA084844Battery Pack · inoperativeDURING SCHEDULED MV1 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA083896Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083895Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA083897Terminal · looseDURING SCHEDULED SPV CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 6 DEF. FOUND LOOSE TERMINAL. SECURED TERMINAL PER MM.SDR SWAA083554Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500C, STR 26R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083522Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 23L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083521Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER TEE CHORD CRACKED AT BS 724, LBL 25. REMOVED AND REPLACED TEE CHORD PER SRM.SDR SWAA083520Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA083519Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 11R CRACKED AT BS 355. REPAIRED STRINGER PER SRM.SDR SWAA083518Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 22R CRACKED AT BS 540. REPAIRED STRINGER PER SRM.SDR SWAA083517Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 23R CRACKED AT BS 540. REPAIRED STRINGER PER SRM.SDR SWAA083516Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 540, STR 23R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083515Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083514Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 400, STR 13R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083513Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA083400Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 767, STR 17R. R&R SHEAR TIE PER SRM.SDR SWAA083399Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 13R. R&R STRINGER SPLICE PER SRM.SDR SWAA083398Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER TEE CHORD CRACKED BETWEEN BS 655 AND BS 675, LBL 25. R&R CHORD PER SRM.SDR SWAA083321Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 460, STR 13R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083320Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, STR 13L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083364Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 11 TO LBL 19. REPAIRED FLOORBEAM PER SRM.SDR SWAA083365Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 16 TO RBL 37. REPAIRED FLOORBEAM PER SRM.SDR SWAA083366Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500D, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083367Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 480, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083324Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 420, STR 13L. REPAIRED SHEAR TIE PER SRM.SDR SWAA083368Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 420, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083322Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 440, STR 13R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083326Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 13R. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA083325Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER TEE CHORD CRACKED BETWEEN BS 655 AND BS 675, RBL 25. REMOVED AND REPLACED TEE CHORD PER SRM.SDR SWAA083323Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 420, STR 13R. REPAIRED SHEAR TIE PER SRM.SDR SWAA083212Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 540, STR 18L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA083211Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082852Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 400 TO BS 420, LBL 68. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082851Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 480 TO BS 500, LBL 68. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082850Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 967, RBL 28 TO RBL 42. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA082849Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082848Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082847Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA082807Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 14R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA082806Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 14R CRACKED AT BS 887. REPAIRED STRINGER PER SRM.
Back to N357SW, cancelled Mar 22, 2018