N507SW, cancelled Jan 29, 2014
Service difficulty reports · 338
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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 SWAA050607Skin · wornDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN, UPPER LOBE, WORN BETWEEN BS 870 & BS 887, RT SIDE & BETWEEN BS 878 & BS 880, LT SIDE. REPAIRED SKIN PER SRM.SDR SWAA050579Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EA CRACKS AT NR 3 LONGITUDINAL FLOOR SUPPORT AT BS 665, BS 662.5, & BS 669. REPAIRED BEAM PER SWA EA.SDR SWAA050578Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND 3 EA CRACKS AT NR 2 LONGITUDINAL FLOOR SUPPORT AT BS 656, BS 665, & BS 669. REPAIRED BEAM PER SWA EA.SDR SWAA050554Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED STRINGER CLIP AT BS 663, STR 10L AND STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050553Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON L1 DOOR EVAC SLIDE, AFT GIRT BAR FITTING AT BS 344. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA050552Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON SHEAR TIE AT BS 787, BETWEEN STR 26R & 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA050527Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND BOTH LT & RT WING LOWER T-CHORDS CRACKED AT WBL 135.5, BETWEEN STR 2 & 3. REPAIRED T-CHORDS PER SWA EA.SDR SWAA050525Shear Web · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT SHEAR WEB, BS 956, RBL 21. REMOVED AND REPLACED SHEAR WEB ANGLE PER SRM.SDR SWAA050524Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON CREASE BEAM Z-ANGLE, RT SIDE, BETWEEN BS 927 AND BS 1006. REMOVED AND REPLACED RT CREASE BEAM Z-ANGLE PER SRM.SDR SWAA050523Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED FRAME AT LT FWD LOWER CORNER EMERGENCY EXIT AT BS 616. REPAIRED FRAME PER TYPICAL REPAIR MANUAL.SDR SWAA050372Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT FWD LT CORNER OF AIR CONDITIONER CUTOUT, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050371Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT AFT ENTRY DOOR UPPER HINGE CUTOUT, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA050272Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING NR 4 L/E SLAT DELAMINATED. REMOVED AND REPLACED NR 4 L/E SLAT PER MM.SDR SWAA043703Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 930, STRINGER 24L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043271Cover · looseEEPLS STRIP COVER FROM ROW 17 DEF TO ROW 19 DEF, LOOSE. REMOVED AND REPLACED EEPLS STRIP COVER PER MM.SDR SWAA043078Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 971, STRINGER 21L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA042908Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 877, STRINGER 24R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041030Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN BEHIND LT WING TO BODY FAIRING AT BS 767, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA032803Slide · out of adjustR2 DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF POSITION. READJUSTED SLIDE ASSY PER MM.SDR SWAA031991Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767 + 3, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA031323Battery · dischargedDURING SCHEDULED RON, FOUND RT FWD CABIN OVERHEAD BIN EMERGENCY EXIT BULL NOSE LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA031189Light · wornDURING SCHEDULED C3 CHECK, FOUND EEPLS PHOTOLUMINSCENT STRIP WORN AND CHIPPED IN SEVERAL AREAS. REMOVED AND REPLACED WORN AREAS OF EEPLS STRIP.SDR SWAA022639Track · debondedDURING SCHEDULED C1 CHECK, FOUND SEVERAL PHOTO LUMINESCENT FLOOR STRIPS DEBONDED. REMOVED AND REPLACED STRIPS PER MM.SDR SWAA021981Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED ON CAPT'S NR 1 WINDOW UPPER OTBD POST. REPAIRED SKIN PER SRM.SDR SWAA021965Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA021952Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND BEADED WEB CRACKED AT BS 663, LBL 33 AND LBL 39. REPAIRED BEADED WEB PER SWA EA.SDR SWAA021918Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, STR 17R AT FWD SVC DOOR AFT LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA021893Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND OVERHEAD BIN BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW NR 13 DEF. SECURED LENS PER MM.SDR SWAA021886Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND NR 1 L/E SLAT LOWER SKIN CRACKED AT AFT FASTENERS NEAR OTBD END. REPAIRED SKIN PER SRM.SDR SWAA021482Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021017Tab · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA020534Slide · unserviceableFWD ENTRY DOOR EVACUATION SLIDE PRESS IND OUT OF LIMIT. REMOVED AND REPLACED EVACUATION SLIDE ASSY PER MM.SDR SWAA020109Cover · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS COVER CRACKED AT ROW NR 21. REMOVED AND REPLACED COVER PER MM.SDR SWAA012813Flap · delaminatedDURING WALK AROUND INSPECTION, FOUND # 1 T/E FLAP DELAMINATED 1 1/2 INCHES FROM AFT T/E. REPAIRED FLAP PER SRM..SDR SWAA011825Cover · looseEEPLS COVER LOOSE AT ROW 21. SECURED EEPLS COVER PER MM.SDR SWAA011428Skin · crackedDURING WALKAROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA011015Flap · delaminatedDURING SCHEDULED C3 CHECK, FOUND LT WING OUTBD T/E AFT FLAP DISBONDED AT INBD END. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA001859Light · inoperativeEEPLS TRACK INOP AT MID CABIN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA001760Light · damagedEEPLS WIRES WERE DAMAGED AT ROW 9. REPAIRED EEPLS PER MM.SDR SWAA001416Cover · missingEEPLS MISSING TRACK COVER AT ROW 9. INSTALLED TRACK COVER PER MM.SDR SWAA000593Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 986.5 UPPER SURFACE OF FLOORBEAM CORRODED, LBL 10 TO LBL 44. REPAIRED FLOORBEAM PER ER 00-245P2 AND SRM.SDR SWAA000584Mount · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION DAMAGE IN VERTICAL STABILIZER RT FWD MOUNT LUG BORE. REPAIRED LUG PER ER 00-0278.SDR SWAA000532Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CORRODED AND CRACKED, BS 856, JUST BELOW STRINGER 18R. REPAIRED SKIN PER SRM AND ER NR 00-0289.SDR SWAA000459Frame · crackedDURING SCHEDULED D CHECK, FOUND BS 178 BULKHEAD RT AND LT SIDE CHORDS CRACKED, WL 208. REPAIRED CHORD SECTIONS PER SRM.SDR SWAA000421Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EVACUATION SLIDE GIRT BAR FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER SRM.SDR SWAA000420Splice · crackedDURING SCHEDULED D-CHECK, FOUND 2 STRINGER SPLICES CRACKED, BS 907, STRINGERS 4R AND 4L. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA000384Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BY ULTRASONIC INSP BS 178 BULKHEAD CRACKED, WL 209-213, LBL 5-LBL 6. REPAIRED BULKHEAD PER SRM.SDR SWAA000383Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 360, BETWEEN STRINGERS 13L-14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA000375Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 12 STRINGER CLIPS CRACKED, STRINGER 11L, BS 706, BS 597, STRINGER 4L, BS 663, BS 616, BS 578, BS 847, STRINGER 5R, BS 727C, STRINGER 5L, BS 578, STRINGER 11R, BS 707, STRINGER 7L, BS 727C, BS 727A, AND STRINGER 8L, BS 727A. REMSDR SWAA000207Guide Arm · out of adjustAIR TURNBACK, LOUD PRESSURIZATION LEAK AROUND FWD ENTRY DOOR. ADJUSTED FWD ENTRY DOOR UPPER GUIDE ARM PER MM.
Back to N507SW, cancelled Jan 29, 2014