N365SW, cancelled May 11, 2016
Service difficulty reports · 325
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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 SWAA071136Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA070654Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064990Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA064985Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA064130Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING INBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA064129Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA064128Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 735E, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA064041Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA063429Battery · faultyDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR SLIDE EMERGENCY LIGHTS ILLUMINATED WITH SWITCH IN OFF POSITION. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA062998Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT EXTERIOR LIGHT INOP AT RT AFT FUSELAGE. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA061354Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER SLICE PER SRM AND EA.SDR SWAA053499Lens · brokenRIGHT OVERWING LOWER EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA052133Lens · looseFWD EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA051632Battery · dischargedDURING SCHEDULED RON CHECK, FOUND EMERGENCY BULLNOSE LIGHT INOP AT ROW 15 DEF. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA051282Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050131Attach Fitting · brokenDURING SCHEDULED 1/4D CHECK, FOUND RT WING NR 5 SPOILER UPPER LUG AT OUTBOARD ACTUATOR BROKEN. REMOVED AND REPLACED RT WING NR 5 SPOILER PER MM.SDR SWAA050110Shear Tie · crackedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE, AFT CARGO COMPARTMENT BS 807, STRINGER 25L, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA050109Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 378, LBL 2.80, CRACKED. REPAIRED SKIN ER EA.SDR SWAA050108Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 727E + 13, STRINGER 23L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050106Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED T/E AFT FLAP PER MM.SDR SWAA050105Skin · delaminatedDURING SCHEDULED 1/4D CHECK, FOUND RT WING INBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA050075Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR FRAME NR 3 AFT DOOR STOP CASTING CUTOUT CRACKED. REPAIRED DOOR FRAME PER TR T1-152-003.SDR SWAA050069Bracket · crackedDURING SCHEDULED 1/4D CHECK, FOUND SUPPORT BRACKETS AT BS 616, LBL 64 AND RBL 64, CRACKED. REPAIRED BRACKETS PER SRM T1-153-018.SDR SWAA050021Slide · out of adjustL1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR EVAC SLIDE PER MM.SDR SWAA043002Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSEMBLY PER MM.SDR SWAA042674Fire Detector · false indicationAT FL 350 FWD/AFT/BTL1/BTL2/BELL/WARNING MASTER CAUTION ILLUMINATED. THEN ALL EXTINGUISHED 10 SECONDS LATER, NO OTHER INDICATIONS. NO BOTTLES DISCHARGED. INSPECTED FWD AND AFT CARGO COMPARTMENTS, BAGGAGE CHECKED, NO ABNORMAL INDICATIONS. CARGO FIRE DETECTOSDR SWAA042141Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND LT WING NR 2 L/E SLAT DELAMINATED. REMOVED AND REPLACED NR 2 L/E SLAT PER MM.SDR SWAA042123Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 747, STRINGER 24L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041445Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 524, STRINGER 10R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040715Battery · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND EMERGENCY EXIT LIGHTS INOP AT ROWS 10 ABC, 8 DEF AND LT OVERWING. RECHARGED BATTERIES PER MM.SDR SWAA040093Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBOARD T/E, AFT FLAP DELAMINATED. REMOVED AND REPLACED LT WING AFT FLAP PER MM.SDR SWAA032473Actuator · faultyDURING INITIAL MLG RETRACTION, RT MLG RED LIGHT IND WOULD NOT EXTINGUISH, CYCLED GEAR ANG LIGHT REMAINED. REMOVED AND REPLACED RT MLG UPLOCK ACTUATOR PER MM.SDR SWAA022868Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA022361Blade · shingledAIR TURNBACK AFTER TAKEOFF, NR 2 ENGINE NOISE WAS NOTICED ALONG WITH ENGINE VIBRATION METER FLUCTUATIONS. FOUND (4 EA) BLADES SHINGLED NR 38, NR 1, NR 2 AND NR 3. UNSHINGLED BLADES PER MM.SDR SWAA021564Skin · crackedDURING SCHEDULED D CHECK, FOUND RT HORIZ STAB SKIN CRACKED ON LOWER SURFACE AT STAB STA 125. REPAIRED SKIN PER BFG ER.SDR SWAA021538Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (2 EA) BETWEEN STR'S 7R AND 8R, AT BS 360 AND 480. REPAIRED FRAMES PER SRM.SDR SWAA021515Rib · crackedDURING SCHEDULED D CHECK, FOUND RT HORIZ STABILIZER RIB CRACKED AT STAB STA 120.3. REMOVED AND REPLACED RT HORIZ STAB LOWER RIB CHORD.SDR SWAA021514Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 955.5, WL 206 AND RBL 54. REPAIRED FRAME PER SRM.SDR SWAA021508Crease Beam · corrodedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CORRODED AT BS 360, STR 17R AND WL 208. REPAIRED CREASE BEAM PER SRM.SDR SWAA021503Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR UPPER HINGE CUT OUT. REPAIRED SKIN PER SRM.SDR SWAA021478Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT BS 360, STR 5L AND BS 887, STR 4L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA021477Shear Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L AND 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA021450Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, ABOVE STR 25R. REPAIRED FRAME PER SRM.SDR SWAA021449Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT WINDOW BELT CUTOUT ON RT WINDOW NR 10. REPAIRED SKIN PER SWA SI.SDR SWAA021408Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA020831Bushing · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BUSHINGS PER MMSDR SWAA020830Bushing · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ALL ELEVATOR TAB HINGE BUSHINGS.SDR SWAA020796Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020645Cover · missingEEPLS COVER MISSING AT MID CABIN. INSTALLED COVER PER MM.SDR SWAA020156Wire · disconnectedDURING SCHEDULED SERVICE CHECK, FOUND EEPLS AT MID CABIN INOP. RECONNECTED WIRES PER MM.
Back to N365SW, cancelled May 11, 2016