N384SW, cancelled Aug 3, 2018
Service difficulty reports · 368
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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 SWAA102819Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3R. R&R CLIP PER SI AND BAC DWG.SDR SWAA102818Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 11L. R&R CLIP PER SRM AND BAC DWG.SDR SWAA102779Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8R. R&R CLIP PER SI.SDR SWAA102704Slat · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RT WING NR 5 SLAT AT I/B EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA102451Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND SUPPORT ANGLE CRACKED AT BS 986.5, STR 3L. REPAIRED ANGLE PER BAC DWG AND SRM.SDR SWAA102450Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102379Slat · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RT WING NR 4 SLAT I/B EDGE DELAMINATED. REPAIRED NR 4 SLAT PER SRM.SDR SWAA101574Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 737C, STR 4R. REPAIRED SKIN PER EA.SDR SWAA101573Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 528, STR 4L. REPAIRED SKIN PER EA.SDR SWAA101306Sign · missingEMERGENCY EXIT SIGN MISSING. RE-INSTALLED SIGN PER MM.SDR SWAA101276Fitting · looseDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD GIRT FITTING LOOSE. SECURED FITTING PER SRM.SDR SWAA101275Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA100267Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FLIGHT DECK WINDOW POST SKIN CRACKED BETWEEN R1 TO R2 WINDOW UPPER CORNER. REPAIRED SKIN PER SRM.SDR SWAA100270Wedge · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 2 SLAT PER SRM.SDR SWAA100269Light · looseDURING SCHEDULED HC2 CHECK, FOUND RT EEPLS LOOSE AT ROW 1. REMOVED AND REPLACED EEPL PER MM.SDR SWAA100268Lens · looseDURING SCHEDULED HC2 CHECK, FOUND LT EMERGENCY EXIT SIGN LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA097994Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA096951Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 510B, STR 1L. REPAIRED SKIN PER SWA EA.SDR SWAA096686Gasper Fan · faultyDIVERSION, FLIGHT ATTENDANT CALLED COCKPIT TO REPORT "ELECTRICAL BURNING - ACRID SMELL" IN CABIN. NO SMOKE NOTED. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA096509Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 755, STR 4R. REPAIRED SKIN PER EA.SDR SWAA096508Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 736B, STR 4R. REPAIRED SKIN PER EA.SDR SWAA096507Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 431, STR 1L. REPAIRED SKIN PER EA.SDR SWAA095636Cap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT HORIZONTAL STABILIZER END CAP DELAMINATED. REMOVED AND REPLACED END CAP PER MM.SDR SWAA094242Floorbeam · crackedDURING SCHEDULED HC1 CHECK, FOUND E&E COMPT FLOORBEAM CRACKED AT BS 328, RBL 50.5. REPAIRED BEAM PER SRM.SDR SWAA087328Lens · missingDURING SCHEDULED HC2 CHECK, FOUND FWD CABIN OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA087366Light · looseDURING SCHEDULED MV2 CHECK, FOUND EEPLS STRIP LOOSE AT ROW 20. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA087235Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA087227Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA087198Lens · missingDURING SCHEDULED 14Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA087179Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087178Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087177Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087176Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087175Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087174Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087173Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087172Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087161Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087160Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087159Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087158Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087157Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087156Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA083703Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME SHEAR TIE CORRODED AT BS 380, LBL 5. REPAIRED SHEAR TIE PER SRM.SDR SWAA083702Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 380, LBL 0. REPAIRED SKIN PER EA & ACO.SDR SWAA080014Cover · brokenRIGHT OVERWING EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED COVER PER MM.SDR SWAA076225Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING INBOARD T/E AFT FLAP DELAMINATED AT LOWER SURFACE. REMOVED AND REPLACED FLAP PER MM.SDR SWAA074473Sign · looseLEFT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED EXIT SIGN PER MM.SDR SWAA074430Lens · looseLEFT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER SWA EA.SDR SWAA072933Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.
Back to N384SW, cancelled Aug 3, 2018