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 SWAA2014030525773Web · crackedWEB CRACKED BETWEEN BS 328 TO BS 344, LBL 47.0. R & R WEB IAW SRM & DRAWING.SDR SWAA2014030525772Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, LBL 47.0. REPAIRED WEB IAW SRM & DRAWING.SDR SWAA2014030525771Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 986.5, LBL 45. REPAIRED BEAM IAW SRM.SDR SWAA2014030525770Support Angle · crackedRT WING TE SUPPORT ANGLE CRACKED AT WBL 204. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030325709Fitting · crackedCLIP CRACKED AT BS 927, STRINGER 11R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014032826596Web · crackedRIGHT NLG WW WEB CRACKED AT STATION 243.7+3.5, WL 169.1. REPAIRED WEB IAW EA.SDR SWAA2014032826595Web · crackedRIGHT NLG WW WEB CRACKED AT STATION 243.7+2.5, WL 169.1. REPAIRED WEB IAW EA.SDR SWAA2014032426356Web · crackedLT NLG WW WEB CRACKED AT BS 259.5, WL 185. REPAIRED WEB IAW SRM.SDR SWAA2014032426334Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, STRINGER 15L. REPAIRED DOME CAP WEB IAW SRM.SDR SWAA2014032026247Web · crackedLEFT NLG WW CRACKED AT BS 243.7 + 3.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014032026246Web · crackedLEFT NLG WW WEB CRACKED AT BS 243.7 + 2.5, WL 169.1. REPAIRED WEB IAW SRM.SDR SWAA2014031726101Support Angle · crackedRT WING SUPPORT ANGLE CRACKED AT WBL 71.24 TE. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031426056Web · crackedFUSELAGE WEB CRACKED AT STATION 695, RBL 62.5, STRINGER 17R. REPAIRED WEB IAW SRM.SDR SWAA2014030725852Angle · crackedLT WING REAR SPAR ANGLE CRACKED AT WBL 70.85. R & R ANGLE IAW SRM.SDR SWAA2014030425738Angle · crackedLT WING NR 3 FLAP TRACK ANGLE CRACKED AT WBL 183.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014030325708Angle · crackedRT WING TE ANGLE CRACKED AT RSS 545. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014032626526Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EO & EA.SDR SWAA2014032426355Skin · crackedRT WING LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2014032426333Pressure Deck · crackedPRESS DECK LOWER SURFACE CRACKED BETWEEN BS 663 TO BS 674, LBL 32 OF LT MLG BAY. REPAIRED WEB IAW EA 1-353-24709.SDR SWAA2014031726098Web · crackedNLG BEAM WEB CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2014030425737Angle · crackedFWD ENTRY DOOR, FWD UPPER CORNER ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024266Actuator · faultyAIR TURN BACK DECLARED EMERGENCY LOST HYD SYSTEM A AT APPROXIMATELY 2000 FT AGL. LOW PRESS HYD ENG A ILLUMINATED & THEN A SYSTEM HYD, QUANTITY WENT TO ZERO. R & R NR 3 FLIGHT SPOILER ACTUATOR IAW MM.SDR SWAA2014010923908Lens · missingAFT RT EMERGENCY EXIT SIGN LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2013100720863Skin · crackedSKIN CRACKED BETWEEN BS 500D+ 15 - BS 500D+ 16 STRINGER 16R. REPAIRED SKIN IAW ER & EA.SDR SWAA2013100720862Skin · crackedSKIN CRACKED BETWEEN BS 972 TO BS 973, STRINGER 21L. REPAIRED SKIN IAW ER & EA.SDR SWAA2013100720861Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 663 LBL 6. REPAIRED STIFFENER IAW EA.SDR SWAA2013100720797Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 727D+12.5 TO BS 727D+14, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2013100720796Skin · crackedFUSELAGE CRACKED BETWEEN BS 790.5 TO BS 791 STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013100220715Stiffener · crackedREAR SPAR VERTICAL STIFFENER CRACKED AT BS 663 RBL 6. REPAIRED STIFFENER IAW EA.SDR SWAA2013091820211Slide · unwanted deployL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY DEPLOYED UPON INITIAL DOOR OPENING. R&R SLIDE IAW MT.SDR SWAA2013032814198Bypass Valve · faultyABORTED TAKEOFF AT APPROX 80KT. A/C GAVE A PRONOUNCED LEFT/RIGHT YAW MOVEMENT; 3-4 SECONDS LATER APPROX.; A/C RECEIVED A MUCH MORE INTENSE LEFT/RIGHT PULL THAT WAS AT OR NEAR LIMIT OF CONTROL. REMOVED AND REPLACED RUDDER STEERING ACTUATOR NOSE STEER BYPASS VSDR SWAA2013030113204Slide · out of adjustAFT SERVICE DOOR OUTER HANDLE DOES NOT AUTO STOW WHEN DOOR SHUT FROM OUTSIDE. ADJUSTED SLIDE PER M/M.SDR SWAA2013030413286Skin · crackedCRACK AT STRINGER 1, BETWEEN BS 446 TO BS 447. REPAIRED SKIN IAW E/A.SDR SWAA2013030413285Skin · crackedCRACK AT STRINGER 1, BETWEEN BS 434 TO BS 437. REPAIRED SKIN IAW E/A.SDR SWAA2013030413284Skin · crackedCRACK AT STRINGER 1, BETWEEN BS 425 TO BS 426. REPAIRED SKIN IAW E/A.SDR SWAA2013030413235Skin · crackedCRACK AT STRINGER 1, BETWEEN STA 443 TO STA 445. REPAIRED SKIN IAW EA.SDR SWAA2012123110982Mount Bracket · wornAFT SERVICE DOOR SLIDE LOOSE. FOUND BOTH FWD & AFT MOUNT BRACKET STANDOFFS WORN. REMOVED AND REPLACED BRACKET ASSY FWD & AFT IAW MM.SDR SWAA2012112009631Skin · crackedFUSELAGE SKIN CRACK AT STA 928+5" STR 24L. REPAIRED FUSELAGE CRACK PER EA 1-A53-7340 AND TSR 201205176.SDR SWAA2012101608559Cover · missingLEFT OVERWING EMERGENCY EXIT SIGN LIGHT COVER MISSING. REMOVED AND REPLACED SIGN ASSY PER MM.SDR SWAA2012100108205Cover · missingR2 DOOR EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED COVER PER MM.SDR SWAA2012082707081Solenoid · failedAIR TURNBACK/DECLARED EMERGENCY -- AFTER TAKEOFF LANDING GEAR WOULD NOT RETRACT, PERFORMED QRH PROCEDURE FOR LANDING GEAR LEVER LOCK SOLENOID FAILURE AND GEAR RETRACTED NORMALLY. REMOVED AND REPLACED LANDING GEAR HANDLE LOCK CYLINDER PER MM.SDR SWAA2012060404606Skin · crackedLEFT WING LEADING EDGE EXTERNAL SKIN CRACKED AT STA 208. REPAIRED SKIN IAW SRM.SDR SWAA2012060504651Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 227.8, RBL 16. REPAIRED WEB IAW EA AND EO.SDR SWAA2012060504650Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 227.8, LBL 16. REPAIRED WEB IAW EA AND EO.SDR SWAA2012060104522Skin · crackedSKIN CRACKED AT BS 727D+10, BETWEEN STR 27R TO STR 27L. REPAIRED SKIN IAW EA AND EO.SDR SWAA2012052904421Angle · crackedANGLE CRACKED AT BS 540, RBL 70.85. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012053104494Channel · crackedCHANNEL CRACKED BETWEEN BS 727D TO BS 727E, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED CHANNEL IAW SRM & DWG.SDR SWAA2012052904420Channel · corrodedCHANNEL CORRODED BETWEEN BS 219.8 TO BS 227.8, BL 0. REMOVED AND REPLACED CHANNEL IAW SRM.SDR SWAA2012060404649Bulkhead · corrodedBULKHEAD LOWER CHORD CORRODED AT BS 227.8, BL 0. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012052404306Flap · delaminatedLEFT WING I/B END OF O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.
Back to N365SW, cancelled May 11, 2016