N303SW, cancelled Oct 26, 2017
Service difficulty reports · 391
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 = 'N303SW' AND deregistration_id = 'N303SW-2017-10-26' 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 = 'N303SW' AND deregistration_id = 'N303SW-2017-10-26' 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 SWAA000170Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE EXTERNAL SKIN 2 EACH CRACKS, BS 727+7, STRINGER 20L, AND BS 913, STRINGER 19R.. REPAIRED SKIN PER SRM.SDR SWAA991865Bracket · looseDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS LOOSE. TIGHTENED AND SECURED BRAKETS PER MM.SDR SWAA991657Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 2 EACH FUSELAGE SKIN CRACKS, BS 747 AND BS 727D, AT STRINGER 19L. REPAIRED SKIN PER SRM.SDR SWAA991539Skin · crackedDURING SCHEDULED RON, FOUND 4 EACH CRACKS ON FUSELAGE SKIN, BS 500A +4, AND BS 500C +6, STRINGER 10L. REPAIRED SKIN PER SRM.SDR SWAA991274Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR UPPER CENTER CUT OUT STUB FRAME CRACKED. REPAIRED STUB FRAME PER SWA RA NR 1-353-2133.SDR SWAA990595Angle · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EA CHORDS CRACKED AT LBL AND RLB 28.5, BS 178. REPAIRED PER SRM.SDR SWAA990588Tee · crackedDURING SCHEDULED 1/2D CHECK, FOUND LOWER T-CHORD CRACKED THIRD FROM AFT END, FWD CARGO DOOR. REMOVED DOOR, REPAIRED AND REINSTALLED DOOR PER SRM AND MM.SDR SWAA990559Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND A 2 INCH LONG CRACK ON FUSELAGE OUTER SKIN, BS 272 TO 274 STR 16L. REPAIRED SKIN PER SRM.SDR SWAA990558Keel Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND INTERGRANULAR CORROSION ON KEEL BEAM, RT O/B SIDE BS 545.9. REPAIRED BEAM PER SWA RA NR 1-353-2044.SDR SWAA990557Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND THRU EDDY CURRENT INSPECTION A CRACK ON BEADED WEB AT BS 665, RBL 42 AT CABIN FLOOR. REPAIRED WEB PER SWA RA NR 1-353-2034.SDR SWAA990547Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND THRU EDDY CURRENT INSPECTION, CRACKED UPPER FRAME ON AFT ENTRY DOOR CUTOUT FOR DOOR ASSIST HANDLE. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA990552Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT SERVICE DOOR UPPER FWD FRAME CRACKED AT ASSIST HANDLE. REPAIRED PER SRM.SDR SWAA990546Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BELTFRAME CRACKED AT BS 616 LT SIDE CABIN FLOOR. REPAIRED PER SWA RA NR1-353-2042.SDR SWAA990545Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER 14L CHANNEL CRACKED AT STUB FRAME BS 360. REPAIRED PER SRM.SDR SWAA990536Channel · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED U-CHANNEL AT STR 15L, BS 360. REPAIRED CHANNEL PER SRM.SDR SWAA990533Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 STRINGER CLIPS CRACKED AT BS 663, STR 12R AND 10L, BS 767, STR 13R, AND BS 787, STR 11L. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA990514Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 CRACKS ON EXTERNAL FUSELAGE SKIN BS 787 STR 19L AND ON BS 780 STR 18L. REPAIRED CRACKS PER SRM.SDR SWAA990513Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND A 1.5 INCH VERTICAL CRACK ON EXTERNAL FUSELAGE SKIN, BS 312 STR 19R. REPAIRED PER SRM.SDR SWAA990512Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR FWD, LOWER FRAME CRACKED BELOW UPLATCH. REPAIRED FRAME PER SRM.SDR SWAA990511Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT ENTRY DOOR UPPER HINGE CUTOUT CRACKED AT LOWER CORNER (VERIFIED WITH EDDY CURRENT INSPECTION). REPAIRED SKIN CUT OUT PER SWA RA NR 1-352-0323.SDR SWAA990510Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER T CHORD CRACKED AT BS 663 BL 0. REPAIRED PER SWA RA NR 1-357-0648.SDR SWAA990509Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND THRU EDDY CURRENT INSPECTION A CRACK IN BEADED WEB AT BS 664 LBL 32. REPAIRED PER SWA RA NR 1-353-2033.SDR SWAA990508Bulkhead Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND 5 CRACKS AT BS 178 BULKHEAD WEB BETWEEN LBL 32 AND RBL 5. REPAIRED PER SRM.SDR SWAA990507Bulkhead Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 CRACKS AT BS 178 BULKHEAD WEB BETWEEN LBL 9-RBL 7. REPAIRED PER SRM.SDR SWAA990506Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK ON FLOORBEAM AROUND NET TIE DOWN HOLE, BS 787 RBL 14. REPAIRED PER SRM.SDR SWAA990505Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM AROUND SCREW HOLE, BS 727 RBL 8. REPAIRED PER SRM.SDR SWAA990493Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON STRINGER 25L UPPER FLANGE, BS 868. REPAIRED PER SRM.SDR SWAA990473Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND APPROXIMATE A 2.5 INCH CRACK IN FUSELAGE SKIN ON AFT LOWER CORNER OF FWD SERVICE DOOR CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA990472Chord · crackedDURING SCHEDULED 1/2D CHECK, FOUND T-CHORD CRACKED AT BS 180, RBL 25, WL 207. REPAIRED CHORD PER SRM.SDR SWAA983157Skin · crackedDURING SCHEDULED SP VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 753 ABOVE S20L. REPAIRED PER BOEING SRM.SDR SWAA981394Intercostal · crackedDURING SCHEDULED BC4 CHECK, FOUND CRACKED FWD CARGO INTERCOSTAL. REMOVED AND REPLACED PER BOEING MM.SDR SWA980656Skin · crackedDURING SCHEDULED BC1 CHECK, FOUND R2 DOOR UPPER FUSELAGE HINGE CUT-OUT HAS .250 LONG CRACK IN RADIUS. REPAIRED PER SWA RA NR 1-353-1807.SDR SWAA970948Skin · corrodedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN BLENDED BEYOND LIMITS AT BS 1013 RT, 1 BELOW SKIN LAP. REPAIRED PER BOEING SRM.SDR SWAA970651Skin · crackedDURING SCHEDULED BC2 CHECK, FOUND FUSELAGE SKIN CRACKED 2 PLACES JUST ABOVE UPPER LAP JOINT AT BS 482. REPAIRED PER BOEING SRM.SDR SWAA970100Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 785, ABOVE S20R. REPAIRED PER BOEING SRM.SDR SWAA961325Lamp · inoperativeDURING SCHEDULED BC3 CHECK, FOUND CABIN AFT RED EMERGENCY FLOOR TRACK LIGHT INOP. REPLACED 2 LAMPS PER BOEING M/M.SDR SWAA961324Bulb · failedDURING SCHEDULED BC3 CHECK, FOUND COCKPIT EMERGENCY LIGHTING VERY DIM. RELAMPED PER BOEING M/M.SDR SWAA961323Fuse · failedDURING SCHEDULED BC3 CHECK, FOUND CABIN BULLNOSE EMERGENCY EXIT LIGHTS ABOVE ROWS 22 AND 18 INOP. REPLACED BULB SOCKET AND BATTERY PACK FUSE PER BOEING M/M.SDR SWAA961067Skin · damagedDURING SCHEDULED SC-CHECK, FOUND SKIN DAMAGED AT BS 259.5 UNDER GUSSET FITTING IN UPPER NOSE GEAR AREA. INSTALLED WEB REPAIR PER BOEING SRM.SDR SWAA961063Air Distr · odorNOTED ELECTRICAL ODOR IN MID CABIN AREA. INSPECTED ELECTRICAL WIRING AND NOTED NO DEFECTS PER BOEING M/M.SDR SWAA960175Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800 WL 205. REPAIRED PER BOEING SRM.
Back to N303SW, cancelled Oct 26, 2017