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 SWAA117131Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 20L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA117130Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 20R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA117129Support Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR FWD GIRT BAR FITTING SUPPORT CORRODED AT BS 312, LBL 55. REPAIRED SUPPORT IAW SRM AND DWG.SDR SWAA117128Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD GALLEY DOOR AFT FRAME CRACKED AT I/B EDGE OF CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA117127Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM AND MM.SDR SWAA117126Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT STRINGER CORRODED BETWEEN BS 967 TO BS 997, STR 25L. REPAIRED STRINGER IAW SRM.SDR SWAA117072Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND BUTT SPLICE STRAP CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE STRAP IAW SRM AND DWG.SDR SWAA117071Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 16R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117070Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117069Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117068Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER MM AND SRM.SDR SWAA117067Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME PER MM AND SRM.SDR SWAA117016Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA116602Tab · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING AILERON TAB O/B END DELAMINATED. REPAIRED TAB IAW SRM AND DWG.SDR SWAA116279Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA114545Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 360+3.5, STR 15R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA114544Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 360+14.25, STR 15R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA114543Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 360+15.75, STR 15R. REMOVED AND REPLACED STRINGER PER EA.SDR SWAA114542Stringer · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CRACKED AT BS 370, STR 15R. REMOVED AND REPLACED STRINGER EPR EA.SDR SWAA114541Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 380+15, STR 15R. REPAIRED SKIN PER EA.SDR SWAA114518Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 360+5, STR 15R. REPAIRED SKIN PER EA.SDR SWAA114517Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 400+10, STR 16R. REPAIRED SKIN PER EA.SDR SWAA114283Skin · crackedDURING SCHEDULED RON CHECK, FOUND RT HORIZONTAL STABILIZER CRACKED BETWEEN STA 105.7 TO STA 180. REPAIRED SKIN IAW EA.SDR SWAA114212Skin · crackedDURING SCHEDULED OTS CHECK FOUND, SKIN CRACKED AT BS 360+15, STR 15L. REPAIRED SKIN PER EA.SDR SWAA113921Skin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 360+5, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA113920ASkin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 360+10, STR 15L. REPAIRED SKIN PER SRM.SDR SWAA113919Skin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 380+10, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA113918ASkin · crackedDURING SCHEDULED MV2 CHECK FOUND, SKIN CRACKED AT BS 400+10, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA112257Strap · crackedDURING SCHEDULED SPV CHECK, FOUND H-STRAP CRACKED AT BS 307, STR 10L. REMOVED AND REPLACED H-STRAP PER ER AND EA.SDR SWAA112256Angle · crackedDURING SCHEDULED SPV CHECK, FOUND ANGLE WEB CRACKED BETWEEN BS 295 TO BS 297, STR 16L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA112241Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA112240Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA107488Lens · brokenR2 DOOR EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA107487Light · inoperativeEMERGENCY EXIT LIGHT "NOT ARMED" KORRY LIGHT INOP. RELAMPED KORRY LIGHT PER MM.SDR SWAA107275Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 15. RELAMPED PER MM.SDR SWAA107274Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 20. REPAIRED PER MM.SDR SWAA107147Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA107146Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING I/B GROUND SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA103920Spindle · crackedDURING SCHEDULED MV1 CHECK, FOUND LT WING T/O FLAP NR 2 CARRIAGE SPINDLE CRACKED. REMOVED AND REPLACED NR 2 SPINDLE PER EA.SDR SWAA103526Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA102901Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 495, STR 15R. REPAIRED SKIN PER ER.SDR SWAA102900Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 791, STR 17L. REPAIRED SKIN PER ER.SDR SWAA102617Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 492B, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA102616Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 791, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA102615Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 482, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA102530Cover · looseLOWER EMERGENCY EXIT SIGN LENS COVER LOOSE. SECURED COVER PER EA.SDR SWAA102381Light · disconnectedDURING SCHEDULED MV2 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RECONNECTED LIGHT ASSY PER MM.SDR SWAA101624Brake Assy · faultyABORTED TAKEOFF, A/C LURCHED LEFT ON T/O ROLL; ENGINE PARAMETERS NORMAL. ABORTED AT 85 KIAS; FELT LIKE TIRE OR BRAKE LOCKED. REMOVED AND REPLACED NR 2 MAIN WHEEL ASSY AND NR 2 MAIN BRAKE ASSY PER MM.SDR SWAA096807Slide · out of adjustDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA096794Spar · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING UPPER SPAR CHORD CRACKED. REPAIRED CHORD PER ER.
Back to N507SW, cancelled Jan 29, 2014