N348SW, cancelled Jul 16, 2012
Service difficulty reports · 282
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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 SWAA002550Lens · missingEEPLS LENS MISSING AT MID CABIN. R&R LENS PER MM.SDR SWAA001590Battery Pack · inoperativeDURING SCHEDULED A1 CHECK, FOUND EEPLS FWD SECTION INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA000989Slide · dischargedDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA000559Smoke · detectedAIR TURNBACK -- SMOKE INSIDE COCKPIT AND FWD SIDE OF MAIN CABIN. INSPECTED ACFT A/C SYSTEM, E&E COMPT, BORESCOPED NR 1 ENGINE HPC. NO DISCREPANCIES NOTED R&R LT AIR CYCLE MACHINE PER MM.SDR SWAA000056Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED, RT SIDE OF THE GROUND A/C CONNECT CUT OUT, BS 520. REPAIRED SKIN PER SRM.SDR SWAA991893Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY/SERVICE AND AFT ENTRY DOOR EVACUATION SLIDE GIRT ASSY'S EXTENDING OUT OF LIMITS. ADJUSTED SLIDE ASSY'S PER MM.SDR SWAA991645Keel Beam · crackedDURING SCHEDULED BC2 CHECK, FOUND FUSELAGE KEEL BEAM LOWER PANEL CRACKED AT MLG WHEEL WELL. REPAIRED PER TRM AND SB 737-53-1104.SDR SWAA991644Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE BOTTLE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA991184Web · crackedDURING SCHEDULED A1 CHECK, FOUND BEADED PRESS WEB CRACKED, BS 663, LBL 33. REPAIRED WEB PER SWA RA NR1-353-2117.SDR SWAA990723Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 787, BETWEEN STRINGERS 8R-9R. REPAIRED FRAME PER SRM.SDR SWAA990706Keel Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT KEEL BEAM RT SIDE BS 713 TO 720. REPAIRED BEAM PER ER N99-5203A.SDR SWAA990692Skin · crackedDURING SCHEDULED D-CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED 1 INCH FWD OF REAR SPAR CENTER LINE AT STA 125 (CRACK IS APPROX 1 INCH LONG). REPAIRED SKIN PER ER 99-5225.SDR SWAA990661Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BS 360, STRINGER 15R. REPAIRED FRAME PER SRM.SDR SWAA990653Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 4L SPLICE CRACKED AT BS 908. REPAIRED SPLICE PER SRM.SDR SWAA990652Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAMES AT BS 400, 440 BETWEEN STRINGERS 8L-9L AND AT BS 380, 400, BETWEEN STRINGERS 8R-9R. REPAIRED PER SRM AND ER NR 99-5198.SDR SWAA990651Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BS 616 WL 201 LBL 65. REPAIRED FRAME PER SRM AND ER NR 99-5197.SDR SWAA990650Frame · crackedDURING SCHEDULED D-CHECK, FOUND 5 CRACKS AT FRAMES BS 827, 867 BETWEEN STRINGERS 8L-9L AND BS 727B, 747 AND 867, BETWEEN STRINGERS 8R-9R. REPAIRED PER SRM AND ER 99-5198.SDR SWAA990637Plate · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT FWD ENTRY DOOR GIRT BAR MOUNTING PLATES. REMOVED AND REPLACED PLATES PER SRM.SDR SWAA990636Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND BULKHEAD WEB BS 178 CRACKED IN 5 PLACES, RBL 6 TO LBL 11. REPAIRED WEB PER SRM.SDR SWAA990635Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 19L CRACKED AT BS 500D. REPAIRED STRINGER PER SRM.SDR SWAA990634Clips · crackedDURING SCHEDULED D-CHECK, FOUND 2 STRINGER CLIPS CRACKED AT BS 500D, STRINGERS 19L AND 19R. REPAIRED CLIPS PER SRM.SDR SWAA990317Skin · crackedDURING SCHEDULED SC CHECK, FOUND 2 INCH CRACK BELOW STRINGER 22L, BETWEEN BS 727C AND D. REPAIRED PER BOEING SRM.SDR SWAA983013Battery · dischargedDURING SCHEDULED SC CHECK, FOUND EMERGENCY FLASHLIGHT AT FWD GALLEY BATTERY LOW. REPLACED PER BOEING M/M.SDR SWAA982979Floorbeam · corrodedDURING SCHEDULED RON, FOUND COCKPIT FLOORBEAM CORROSION. REPAIRED PER BOEING SRM.SDR SWAA982541Battery Pack · dischargedDURING SCHEDULED WALKAROUND CHECK, FOUND 1X AFT EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT UPPER FLASHLIGHT BATTERY PER BOEING MM.SDR SWAA981836Intercostal · crackedDURING SCHEDULED C2 CHECK, FOUND CARGO DOOR LATCH BRACKET INTERCOSTAL CRACKED. REPAIRED PER BOEING SRM.SDR SWAA981050Intercostal · crackedDURING SCHEDULED C1 CHECK, FOUND CRACKED INTERCOSTAL FOR DOOR UPLATCH HOOK. REMOVED AND REPLACED PER BOEING SRM.SDR SWA980659Skin · gougedDURING SCHEDULED TERMINAL CHECK, FOUND GOUGED BELOW FWD ENTRY DOOR. REPAIRED PER BOEING SRM.SDR SWA980658Fuselage · crackedDURING SCHEDULED RON CHECK, FOUND CRACKED FUSELAGE AT BS 980 STR 21 ABOUT 2 LONG HFEC. REPAIRED PER BOEING SRM.SDR SWA980657Skin · gougedDURING SCHEDULED RON CHECK, FOUND GOUGE BELOW L-1 DOOR. REPAIRED PER BOEING SRM.SDR SWAA980280Panel · crackedDURING SCHEDULED C4 CHECK, FOUND LEFT WING UPPER SURFACE TRAILING EDGE PANEL HAS TWO CRACKS. REPAIRED PER BOEING SRM.SDR SWAA970316Battery · dischargedDURING SCHEDULED RON, FOUND FLOOR TRACK LIGHTS AT AFT CABIN AREA INOP. REPLACED BATTERY PER BOEING M/M.
Back to N348SW, cancelled Jul 16, 2012