N698SW, cancelled Sep 18, 2012
Service difficulty reports · 320
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 = 'N698SW' AND deregistration_id = 'N698SW-2012-09-18' 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 = 'N698SW' AND deregistration_id = 'N698SW-2012-09-18' 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 SWAA981306Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 986 LBL 10.5. REPAIRED PER BOEING SRM.SDR SWAA981305Bulkhead · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED FWD SIDE OF BULKHD, RBL 5 WL 201 AND WL 201 LBL 5. REPAIRED PER BOEING SRM.SDR SWAA981304Angle · missingDURING SCHEDULED 1/2 D-CHECK, FOUND ANGLE MISSING AT FWD SERV DOOR POST FWD LOWER CORNER ATTACHED TO Z-ANGLE AT BS 294.5, RBL 56. REPAIRED PER BOEING SRM.SDR SWAA981303Skin · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED SKIN AT BS 178, WL 198, RBL 5. REPAIRED PER BOEING SRM.SDR SWAA981302Intercostal · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED C/L INTERCOSTAL AT SCREW HOLES BS 380 TO 400. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981301Splice · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED SPLICE AT BS 470 TO 480, STR 27L. REPAIRED PER BOEING SRM.SDR SWAA981300Splice · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED SPLICE AT BS 490, STR 27L. REPAIRED PER BOEING SRM.SDR SWAA981299Intercostal · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND C/L INTERCOSTAL HAS CRACKS AT SCREW HOLES BS 927 TO 947. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981298Floorbeam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED FLOORBEAM AT BS 344 PANEL HOLE, LBL 28. REPAIRED PER BOEING SRM.SDR SWAA981288Angle · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED TRANSITION ANGLE AT BS 787 RBL 23. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980439Angle · crackedDURING SCHEDULED C2 CHECK, FOUND PANEL ATTACH ANGLE ON TOP OF PYLON CRACKED, INBD SIDE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980437Angle · crackedDURING SCHEDULED BC2 CHECK, FOUND SHEAR WEB AND ANGLE CRACKED AT BS 520, LBL 24.75. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980435Floorbeam · crackedDURING SCHEDULED C2 CHECK, FOUND FLOORBEAM AT BS 520 CRACKED. REPAIRED PER BOEING SRM.SDR SWAA980434Web · crackedDURING SCHEDULED C2 CHECK, FOUND WEB BETWEEN FLOORBEAMS CRACKED AT BS 520 LBL 24.75 AND BS 520 ALONG LBL 45.50 (CRACK IS 1.5 LONG, LOCATED AT THE UPPER AFT CORNER). REMOVED AND REPLACED PER BOEING SRM.SDR SWA980249B-Nut · leakAFTER PUSH BACK FROM GATE, SMOKE FILLED CABIN AND COCKPIT IMMEDIATELY AFTER TURNING PACKS ON. RETURNED TO GATE, CLEARED CABIN AIR, INSPECTED AND CONTINUED PER MEL. AFTER TAKEOFF, CREW EXPERIENCED SMOKE IN THE CABIN AGAIN AIRCRAFT RETURN TO TUL AND MADE AN SDR SWAA980034Window · not sealedDURING CLIMBOUT, NOTED VERY LARGE AIR LEAK AT CAPT NR 1 WINDOW. AIRCRAFT RETURNED TO LAS AND MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED WINDOW ASSEMBLY PER BOEING M/M.SDR SWAA971083Harness · shortedDURING CLIMBOUT, CREW WAS UNABLE TO CONTROL CABIN PRESSURE USING AUTO AND STANDBY MODES. AIRCRAFT RETURNED TO SLC AND MADE AN UNEVENTFUL LANDING. PERFORMED PRESSURE CONTROL SYSTEM TEST, NO DEFECTS NOTED. FOUND NR 2 ENGINE BLEED CONTROL C/B CONTINUALLY TRIPPSDR SWAA970294Target · failedAFTER TAKEOFF, RT MAIN GEAR RED UNSAFE WARNING LIGHT WOULD NOT EXTINGUISH. CYCLED GEAR, NO HELP. AIRCRAFT RETURNED TO PHX AND MADE AN UNEVENTFUL LANDING. REMOVED AND REPLACED UPLOCK BRACKET AND TARGET ASSEMBLY PER BOEING M/M.SDR SWAA961189Skin · corrodedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CORROSION BULGING BETWEEN FASTENERS AT BS 727 TO 727A AT STRINGER 27R. REPAIRED PER SWA RA 1-353-1544.SDR SWAA961188Skin · corrodedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE LOWER SKIN CORROSION BULGING BETWEEN BS 727 TO 727A, S28L. REPAIRED PER SWA RA 1-353-1465.
Back to N698SW, cancelled Sep 18, 2012