N646SW, cancelled Nov 20, 2017
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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 = 'N646SW' AND deregistration_id = 'N646SW-2017-11-20' 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 SWAA2014061629080Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, LBL 5. REPAIRED WEB IAW SRM.SDR SWAA2014061629079Fitting · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE CLIP CRACKED BETWEEN BS 348.2 TO 351.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014061629078Strap · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE STRAP CRACKED AT BS 351.2, STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014070729668Skin · crackedR2 DOOR SKIN CUT OUT CRACKED AT FWD LOWER CORNER FROM FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014070229588Skin · crackedFUSELAGE SKIN CRACKED AT STATION 947.5+14, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014062529392Web · crackedCENTER WING BOX LONGITUDINAL BEAM WEB CRACKED AT BS 709, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014061228981Floorbeam · crackedFLOORBEAM CRACKED AT BS 328, LBL 35. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014061228980Floorbeam · crackedFLOORBEAM CRACKED AT BS 328, LBL 28. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2014061128940Strap · crackedUPPER SURFACE STRAP CRACKED AT BS 312, LBL 45.6. R & R STRAP IAW SRM & DWG.SDR SWAA2014070329620Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 650, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014070229592Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT STATION 664+9, LBL 24.50+17. REPAIRED WEB IAW EA.SDR SWAA2014070229591Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT STATION 664+9, LBL 24.50+15. REPAIRED WEB IAW EA.SDR SWAA2014061929206Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664+2, RBL 24.50+17. REPAIRED WEB IAW SRM.SDR SWAA2014061929205Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664+2, RBL 24.50+14. REPAIRED WEB IAW SRM.SDR SWAA2014061629077Angle · crackedNUMBER 2 PYLON LOWER SUPPORT STRUCTURE OF ACCESS PANEL 5858R ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014070129564Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 671, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014070129563Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 667, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2014070129546Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A RT. REPAIRED FRAME IAW EA.SDR SWAA2014070129545Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A LT. REPAIRED FRAME IAW EA.SDR SWAA2014062629411Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A RT SIDE. REPAIRED FRAME IAW EA.SDR SWAA2014062629410Frame · crackedFUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A LT SIDE. REPAIRED FRAME IAW EA.SDR SWAA2014062529391Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014062529390Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014062529387Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014052128195Skin · crackedDURING CROWN SKIN CRACKED AT BS 446, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2014032526495Coalescer Bag · dirtyAIR TURN BACK ON CLIMB OUT, OIL BURNING SMELL FOG & MIST AT ROW 8 & AFT. R & R WATER SEPARATOR BAGS IAW MM & MT.SDR SWAA2014032426472Fitting · crackedFORWARD CARGO DOOR LOWER AFT CORNER ANGLE FITTING CRACKED ATTACHED TO THE SUPPORT TEE AT DOOR BS 34.25, 7 INCHES ABOVE LOWER FRAME. R & R DOOR IAW AMM.SDR SWAA2014031225982Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STRINGER 10L. R & R CLIP IAW SRM & EA.SDR SWAA2014031225981Skin · crackedSKIN CRACKED AT BS 727A+10, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2014031225979Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727B, STRINGER 10L. R & R CLIP IAW SRM & EA.SDR SWAA2014022425493Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014021725218Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014012724538Engine · failedINFLIGHT SHUTDOWN, AIR TURN BACK, DECLARED EMERGENCY. ON CLIMB OUT PASSING APPROXIMATELY 18,000 FT NR 1 ENG FAILED. NO OVERHEAT, NO FIRE BOTH N1 & N2 CONTINUED TO ROTATE. R & R NR 1 ENG IAW MT.SDR SWAA2014012424517Lens · looseRT OVERWING OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2013110521967Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE GAUGE PRESSURE LOW. R & R SLIDE IAW MT.SDR SWAA2013110521913Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B +6, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013080518815Lock Plate · dirtyR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIFFICULT TO REMOVE. CLEANED DEBRIS FROM LOCK PLATE IAW MM.SDR SWAA2013073018671Skin · crackedL1 DOOR SKIN CRACKED AT UPPER AFT CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2013062517523Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW AMM.SDR SWAA2013062017449Pump · malfunctionedUPON INITIATING DESCENT NR 2 ENGINE COMPRESSOR STALLED. R & R MAIN ENGINE FUEL CONTROL & FUEL PUMP IAW M/M.SDR SWAA2013060716889Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2013051716133Battery · dischargedMID CABIN OVERHEAD EMERGENCY EXIT SIGN LIGHT INOP. R & R BATTERY IAW AMM.SDR SWAA2013051716155Charger · inoperativeMID CABIN OVERHEAD EMERGENCY EXIT SIGN LIGHT INOP. R & R CHARGER BASE IAW AMM.SDR SWAA2013050715677Girt Bar · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED GIRT BAR PER M/M.SDR SWAA2013012111613Glowstrip · looseFLOOR STRIP (EMERGENCY EVAC GLOW STRIP) ROWS 5-7 CAPT SIDE LOOSE. REMOVED AND REPLACED PHOTO LUMINENCE STRIPS ROW 5-7. OPS CHECKS OK PER AMM.SDR SWAA2012090407261Lens · brokenFORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY IAW MM.SDR SWAA2012071605858Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW AMM.SDR SWAA2012070205436Adc · faultyAIR TURNBACK, ON CLIMBOUT NR 1 AUTOPILOT DISCONNECTED, N1 BUGS DECREASED TO 0. BOTH FMCS LOST ALL DATA. NO TEMP INFO. GROUND PROX INOP LIGHT ILLUMINATED. FOUND DADC-1 & TAT PROBE FAULTY. REMOVED AND REPLACED DADC NR 1 COMPUTER AND TAT PROBE PER MM.SDR SWAA2012062605332Light · inoperativeLEFT BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 10. REMOVED AND REPLACED LAMP IAW AMM.SDR SWAA2012062005112Lens · crackedRIGHT SIDEWALL EMERGENCY EXIT LENS CRACKED. REMOVED AND REPLACED LENS IAW MM.
Back to N646SW, cancelled Nov 20, 2017