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 SWAA2017090816210Sign · inoperativeRIGHT SIDE AFT LOWER EMERGENCY SIGN LIGHT INOPERATIVE. R & R THE SIGN IAW AMM.SDR SWAA2017083016011Light · brokenRIGHT EMERGENCY EXIT SIGN BROKEN. R & R THE LIGHT ASSEMBLY IAW MM.SDR SWAA2017080915529Slide · out of positionR1 DOOR ESCAPE SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2017060614139Skin · delaminatedRIGHT WING INBOARD AFT FLAP DELAMINATED. R & R THE AFT FLAP PER AMM.SDR SWAA2017052213871Slide · out of adjustR1 DOOR SLIDE OUT OF ADJUST. ADJUSTED THE SLIDE IAW SIP AND MT.SDR SWAA2017052213853Lamp · dimR2 DOOR EMERGENCY EXIT SIGN VERY DIM. REPLACED THE LAMPS IAW AMM.SDR SWAA2017050913640Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE IAW MM.SDR SWAA2016110809481Sensor · faultyAFTER TAKEOFF, LEFT MAIN GEAR UNSAFE INDICATION WITH THE LANDING GEAR HANDLE IN THE UP POSITION, AIR TURNBACK. R & R LEFT MAIN GEAR UPLOCK SENSOR IAW AMM.SDR SWAA2016110109235Slide · unsecureL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT OF CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE PER MT.SDR SWAA2016091907931Cover · looseLEFT EMERGENCY EXIT LENS COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2016081654860Strap · brokenAFT GALLEY FLASHLIGHT SECURITY STRAP BROKEN. R & R STRAP IAW MM.SDR SWAA2016080454539Light · inoperativeAFT GALLEY AREA B LAVATORY EMERGENCY EXIT LIGHT BULBS INOPERATIVE. R & R BULBS IAW AMM.SDR SWAA2016080454538Light · inoperativeFORWARD GALLEY LAVATORY EMERGENCY EXIT LIGHT BULBS INOPERATIVE. R & R BULBS IAW AMM.SDR SWAA2016080454537Light · inoperativeLEFT SIDEWALL PANEL EMERGENCY EXIT LIGHT BULBS INOPERATIVE. R & R BULBS IAW AMM.SDR SWAA2016080254464Actuator · stuckRT WING NR 5 INBD GROUND SPOILER ACTUATOR STUCK. R & R ACTUATOR IAW AMM.SDR SWAA2016071954042Web · crackedWEB CRACKED BETWEEN BS 294.5 - 312, BETWEEN STRINGERS 27L TO 27R. R & R THE WEB IAW SRM AND DWG.SDR SWAA2016080254463Skin · corrodedFUSELAGE SKIN CORRODED AT BS 355, BETWEEN STR 28R TO STR 28L. REPAIRED SKIN IAW EA.SDR SWAA2016071853958Web · crackedFLOOR WEB CRACKED AT BS 262, LBL 35. REPAIRED WEB IAW SRM.SDR SWAA2016072054091Flap Track · crackedRIGHT WING NR 7 FLAP TRACK TAIL CONE CRACKED. REPAIRED FLAP TRACK TAIL CONE IAW SRM.SDR SWAA2016072854313Skin · debondedRIGHT WING AFT T/E FLAP DEBONDED AT LOWER SURFACE. REPAIRED THE TE FLAP SKIN IAW SRM.SDR SWAA2016072254161Skin · crackedRIGHT WING EXTERNAL SKIN INBD FORE FLAP CRACKED ON LOWER SURFACE. REPAIRED SKIN IAW SRM.SDR SWAA2016072954353Keelbeam · corrodedKEELBEAM CORRODED AT STA 727C, STR 27L. REPAIRED KEELBEAM IAW EA.SDR SWAA2016072854310Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 215 - 238. REPAIRED THE WEB IAW EA.SDR SWAA2016072854309Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 215. REPAIRED THE WEB IAW EA.SDR SWAA2016072854308Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 216. REPAIRED THE WEB IAW EA.SDR SWAA2016072754286Web · crackedRIGHT WING REAR SPAR WEB SPLICE CRACKED BETWEEN RSS 211 TO RSS. 238. / REPAIRED SPLICE IAW EA.SDR SWAA2016080254446Skin · crackedRT WING INSPAR UPPER SKIN CRACKED AT WBL 198.60 AND 6.5. REPAIRED THE SKIN IAW EA.SDR SWAA2016072854307Skin · crackedLEFT WING UPPER IN SPAR SKIN CRACKED AT RSS 240.5. REPAIRED THE SKIN IAW EA.SDR SWAA2016072854306Skin · crackedLEFT WING UPPER IN SPAR SKIN CRACKED AT RSS 251. REPAIRED THE SKIN IAW EA.SDR SWAA2016072854305Skin · crackedLEFT WING UPPER IN SPAR SKIN CRACKED AT RSS 255. REPAIRED THE SKIN IAW EA.SDR SWAA2016072854304Skin · crackedLEFT WING UPPER IN SPAR SKIN CRACKED AT RSS 118.5. REPAIRED THE SKIN IAW EA.SDR SWAA2016072854303Skin · crackedLEFT WING UPPER IN SPAR SKIN CRACKED AT WBL 118.5. REPAIRED THE SKIN IAW EA.SDR SWAA2016072754282Skin · crackedLEFT WING TRAILING EDGE UPPER IN SPAR SKIN BETWEEN RSS 239 TO 272, BETWEEN WBL 114 AND 200. REPAIRED THE SKIN IAW EA.SDR SWAA2016072654251Spar · crackedLEFT WING REAR SPAR WEB SPLICE CRACKED BETWEEN RSS 211 TO 238. REPAIRED IAW EA.SDR SWAA2016080854651Skin · crackedRIGHT WING UPPER SKIN CRACKED AT REAR SPAR WBL 183.0. REPAIRED THE SKIN IAW EA.SDR SWAA2016080254405Skin · crackedRIGHT WING IN SPAR UPPER SKIN AT REAR SPAR, CRACKED AT WBL 200. REPAIRED THE RT WING SKIN IAW EA.SDR SWAA2016080254404Skin · crackedRIGHT WING IN SPAR UPPER SKIN, CRACKED AT WBL 187.0. REPAIRED THE RT WING SKIN IAW EA.SDR SWAA2016072954344Skin · crackedRIGHT WING UPPER SKIN CRACKED AT REAR SPAR WBL 181.4. REPAIRED SKIN IAW EA.SDR SWAA2016072954342Skin · crackedRIGHT WING UPPER SKIN CRACKED AT REAR SPAR, WBL 171.0. REPAIRED SKIN IAW EA.SDR SWAA2016080254411Frame · crackedFRAME CRACKED BETWEEN BS 360 - 380, BL 0. REPAIRED THE FRAME IAW EA.SDR SWAA2016072654250Spar · crackedR/H WING REAR SPAR CHORD SPLICE CRACKED BETWEEN RSS 211 TO 222.5. REPAIRED IAW EA.SDR SWAA2016072654249Fitting · crackedRIGHT WING REAR SPAR UPPER CHORD FITTING CRACKED AT RSS. 222.5. R & R THE FITTING IAW EA.SDR SWAA2016072254160Support Angle · crackedAFT CARGO COMPARTMENT SUPPORT ZEE CRACKED BETWEEN BS 727 TO BS 727C, STR 25R. R & R SUPPORT ZEE IAW SRM AND DWG.SDR SWAA2016072254159Fitting · crackedLEFT WING NR 4 GROUND SPOILER ACTUATOR FITTING CLIP CRACKED. R & R CLIP IAW SRM AND DWG.SDR SWAA2016072254158Angle · crackedLEFT WING T/E ANGLE CRACKED AT LEVEL WBL 70.85. R & R ANGLE IAW SRM AND DWG.SDR SWAA2016062753287Fitting · crackedRIGHT WING, REAR WEB SPAR AFT FITTING CRACKED AT RSS 222.5 COMMON TO UPPER CHORD. R & R FITTING IAW SRM.SDR SWAA2016071253718Angle · crackedLEFT WING NR 3 FAIRING INBOARD FLAP OUTBOARD TRACK ANGLE CRACKED AT EXTERNAL SURFACE. R & R THE ANGLE IAW SRM AND DWG.SDR SWAA2016070553476Bracket · crackedLEFT WING NR 3 FAIRING INBOARD FLAP OUTBOARD TRACK BRACKET ASSEMBLY CRACKED. R & R THE BRACKET IAW SRM AND DWG.SDR SWAA2016072254171Angle · crackedRIGHT WING T/E ANGLE CRACKED ON WBL 85. R & R ANGLE IAW SRM AND DWG.SDR SWAA2016063053381Angle · crackedRT WING T/E OTBD SUPPORT C-ANGLE CRACKED ON WBL 83. REPAIRED ANGLE IAW EA.
Back to N646SW, cancelled Nov 20, 2017