N660SW, cancelled Sep 19, 2016
Service difficulty reports · 531
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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 SWAA2012042603433Skin · crackedSKIN CRACKED BETWEEN BS 971 TO BS 972, STR 21L. REPAIRED SKIN CRACK PER ER AND EA.SDR SWAA2012022401696Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA2012022401695Frame · corrodedFRAME CORRODED AT BS 747, STR 27L. REPAIRED FRAME PER ER.SDR SWAA2012022401694Frame · corrodedFRAME CORRODED AT BS 727C, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA2012022401693Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 747, STR 26R. REMOVED AND REPLACED STR CLIP PER SRM & DWG.SDR SWAA2012022401692Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME SECTION PER SRM.SDR SWAA2012022401691Frame · corrodedFRAME CORRODED AT BS 767 BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA2012022101618Skin · delaminatedRT WING INBD FORE FLAP UPPER SIDE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012022401714Light · inoperativeL1 DOOR EMERGENCY LOWER EXIT LIGHT BULB INOP. REPLACED BULB PER AMM.SDR SWAA2012022401690Light · inoperativeR2 DOOR LOWER EXIT LIGHT BULB INOP. REPLACED LIGHT BULB PER AMM.SDR SWAA2012022401689Light · inoperativeR1 DOOR EMERGENCY LIGHT BULB INOP. REPLACED BULB PER AMM.SDR SWAA2012022201657Skin · crackedSKIN CRACKED AT BS 763.25, STR 19R. REPAIRED PER SRM.SDR SWAA2012021301395Skin · crackedFUSELAGE SKIN CRACKED AT BS 727E+13.5, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA2012021001329Skin · crackedSKIN CRACKED AT BS 749, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA2012021001328Skin · crackedCRACK IN FUSELAGE SKIN AT BS 759.25, STR 18R, .375. REPAIRED SKIN PER SRM.SDR SWAA2012022401688Skin · crackedSKIN CRACKED AT BS 727-6.5, STR 21R. REPAIRED SKIN PER ER & EA.SDR SWAA2012021001327Skin · crackedSKIN CRACKED AT BS 747-5.0, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA2012021001326Skin · crackedSKIN CRACK AT BS 727E+7.0, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA120146Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. RE-INSTALLED SLIDE PER MT.SDR SWAA118083Actuator · malfunctionedWHEN LOWERING GEAR, HAD RED LEFT MAIN GEAR LIGHT AND NO GREEN LIGHT. CYCLED GEAR WITH SAME RESULTS. MANUALLY EXTENDED GEAR AND GREEN ILLUMINATED. REMOVED AND REPLACED LT MLG DOWNLOCK ACTUATOR IAW MM.SDR SWAA117210Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 520+3, STR 8R. REPAIRED SKIN IAW EA.SDR SWAA117209Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 967, LBL 2. REPAIRED SKIN IAW EA.SDR SWAA117208Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 520-2, STR 8R. REPAIRED SKIN IAW EA.SDR SWAA117207Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 967, LBL 2. REPAIRED FRAME IAW EA.SDR SWAA2013021312633Fairing · crackedNR 3 FLAP TRACK FIXED FIXED FAIRING I/B SIDE HAS CRACK MOD. NR 3 FLAP TRACK FAIRING CRACKED ON INBOARD SIDE, REPAIRED IN ACCORDANCE WITH EA 1-A57-0553. REMOVED AND RE-INSTALLED ACCESS PANEL FWD OF NR 3 FLAP TRACK FAIRING IAW IAW SRM 51-40-02.SDR SWAA117034Frame · corrodedDURING SCHEDULED 2HC1 CHECK, FOUND FRAME CORRODED AT BS 967, LBL 2. REPAIRED FRAME PER SRM.SDR SWAA117023Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 520-2, STR 8R. REPAIRED SKIN PER SRM.SDR SWAA117022Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 520+3, STR 8R. REPAIRED SKIN IAW SRM.SDR SWAA113750Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 357, STR 13R. REPAIRED SKIN PER EA.SDR SWAA113641Stringer · corrodedDURING SCHEDULED 26Y CHECK FOUND, STRINGER CORRODED BETWEEN BS 347-357, STR 25R. REPAIRED STRINGER PER SRM.SDR SWAA113640Frame · crackedDURING SCHEDULED 26Y CHECK FOUND, FRAME LOWER INNER CHORD CRACKED AT BS 616, RBL 67. REPAIRED CHORD PER EA.SDR SWAA113572Stringer · corrodedDURING SCHEDULED 26Y CHECK FOUND, STRINGER CORRODED BETWEEN BS 360-380 TO STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA113571Stringer · corrodedDURING SCHEDULED 26Y CHECK FOUND, STRINGER CORRODED BETWEEN BS 350-357 TO STR 22R. REPAIRED STRINGER PER SRM.SDR SWAA113570Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO BAY, CARGO RAIL CORRODED AT STA 847 RBL 14. REPAIRED RAIL PER EA.SDR SWAA113569Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO BAY, CARGO RAIL CORRODED AT STA 727D+5 LBL 12. REPAIRED RAIL PER EA.SDR SWAA113568Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO BAY, CARGO RAIL CORRODED AT STA 772 LBL 3. REPAIRED RAIL PER EA.SDR SWAA113567Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO BAY, CARGO RAIL CORRODED AT STA 859 LBL 12. REPAIRED RAIL PER EA.SDR SWAA113566Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO BAY, CARGO RAIL CORRODED AT STA 859 RBL 3. REPAIRED RAIL PER EA.SDR SWAA113564Cargo Track · corrodedDURING SCHEDULED 26Y CHECK FOUND, AFT CARGO BAY, CARGO RAIL CORRODED AT STA 859 RBL 7.5. REPAIRED RAIL PER EA.SDR SWAA113389Floorbeam · crackedDURING SCHEDULED 26Y CHECK FOUND, CRACK AT RBL 24.8 LONGITUDINAL FLOORBEAM UPPER CHORD BS 727B. REPAIRED CHORD PER ER.SDR SWAA113388Stringer · corrodedDURING SCHEDULED 26Y CHECK FOUND, STRINGER 23 RT BS 347-357 CORRODED. REPAIRED STRINGER IAW SRM.SDR SWAA113387Attach Angle · crackedDURING SCHEDULED 26Y CHECK FOUND, THE STUB BEAM ATTACH ANGLE CRACKED AT BS 639 RBL 45. REPAIRED ANGLE IAW EA.SDR SWAA113713Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 374.5, STR 15R. REPAIRED SKIN PER EA.SDR SWAA113690Stringer Splice · crackedDURING SCHEDULED 26Y CHECK FOUND, STRINGER SPLICE CRACKED AT BS 727, STR 23L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA113689Skin · corrodedDURING SCHEDULED 26Y CHECK FOUND, SKIN CORRODED AT BS 344, BETWEEN STR 26R-27R. REPAIRED SKIN PER EA.SDR SWAA113688Skin · corrodedDURING SCHEDULED 26Y CHECK FOUND, SKIN CORRODED BETWEEN BS 340 TO BS 360, BETWEEN STR 225-27R. REPAIRED SKIN PER EA.SDR SWAA113687Frame · corrodedDURING SCHEDULED 26Y CHECK FOUND, FRAME CORRODED AT BS 380, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME.SDR SWAA113686Skin · crackedDURING SCHEDULED 26Y CHECK FOUND, SKIN CRACKED AT BS 747, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA113685Structure · corrodedDURING SCHEDULED 26Y CHECK FOUND, RT CHORD CRACKED AT BS 616. REPAIRED CHORD PER EA.SDR SWAA113684Frame · corrodedDURING SCHEDULED 26Y CHECK FOUND, FRAME CORRODED AT BS 345, BETWEEN RBL 16 TO RBL 22. REPAIRED FRAME PER SRM.
Back to N660SW, cancelled Sep 19, 2016