N347SW, cancelled Jan 4, 2018
Service difficulty reports · 305
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 = 'N347SW' AND deregistration_id = 'N347SW-2018-01-04' 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 = 'N347SW' AND deregistration_id = 'N347SW-2018-01-04' 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 SWAA2013021312613Light · inoperativeOVERHEAD BIN 2E EMERGENCY LIGHT INOP. RELAMPED OVERHEAD BIN 2E EMERGENCY LIGHT. OP CHECK GOOD PER AMM.SDR SWAA2013020712346Shutoff Valve · faultyCLIMBING THROUGH FL250 CABIN ALTITUDE WARNING HORN SOUNDED. CABIN ALTITUDE INDICATED 10,000+ AND CLIMBING. ALL SYSTEM SWITCHES WERE IN THE NORMAL POSITIONS (PACKS IN AUTO). DESCENT STARTED AT THE SAME TIME AS THE OUTFLOW VALVE WAS FULLY CLOSED USING THE MASDR SWAA2013013012141Charger · inoperativeBOTH AFT GALLEY DOORS (ENTRANCE/SERVICE) LOWER (SMALL) EMERGENCY/LIGHTS INOP. REMOVED & REPLACED BATTERY CHARGER & BATTERY ASSY PER AMM. OPS NORMAL.SDR SWAA2013012511885Relay · faultyDIVERSION/DECLARED EMERGENCY -- CAPT MACH/A/S INDICATOR CAPT F/D COMPUTER, CAPT ALTIMETER, CAPT RADAR ALTIMETER, WX RADAR, PWS BOTH FMC, YAW DAMPER, NR 1 COM RADIO AND TRANSFER BUS FAILED WHEN NR 2 ENGINE WAS SHUT DOWN. REMOVED AND REPLACED RELAY PER MM.SDR SWAA2012122610828Skin · crackedFUSELAGE SKIN CRACK EMITTING FROM UNDER STR 4R LAP MOD AT STA 908. REPAIRED DAMAGE PER EA 1-353-21296.SDR SWAA2012112609755Battery · dischargedEMERGENCY LIGHTS INOP AT OUTSIDE AFT SERVICE DOOR AND OVERHEAD LIGHT AT AFT ENTRY DOOR. REMOVED AND REPLACED BATTERY AT M1134 EMERGENCY LIGHT CHARGING MODULE OPS CHECK GOOD PER MM.SDR SWAA2012112609754Lens · looseROW 6 ABC STORAGE BIN EMERGENCY EXIT LENS UNSECURED. OK TO CONTINUE PER MEL 33-15-01 SP#1 TRACKING#77654. SECURED LENS OPS CHECK GOOD PER MM CL#77749.SDR SWAA2012102308696Spoiler · brokenLEFT WING GROUND SPOILER OUTBOARD ACTUATOR ATTACH POINT BROKEN. REMOVED AND REPLACED NR 4 GROUND SPOILER PER AMM.SDR SWAA2012100908332Skin · crackedFUSELAGE SKIN CRACKED AT STA 513, BELOW STR 8L. REPAIRED SKIN PER EA.SDR SWAA2012090607391Skin · delaminatedLEFT WING NR 1 GROUND SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED NR 1 SPOILER PER MM.SDR SWAA2012083107210Skin · crackedSKIN CRACKED AT BS 440 + 4, STR 1. REPAIRED SKIN PER EA.SDR SWAA2012020901267Keelbeam · corrodedRT KEEL BEAM LOWER CHORD STA 673 TO 727 CORRODED ON LOWER SURFACE. REPAIRED CHORD IAW EA.SDR SWAA201201197Keelbeam · corrodedLEFT KEEL BEAM LOWER CHORD BS 673 TO 727 CORRODED. REPAIRED CHORD IAW EA.SDR SWAA120475Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT BULBS INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA120474Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT BULB INOP. INSTALLED BULB PER MM.SDR SWAA118019Frame · crackedDURING SCHEDULED SPV CHECK, FOUND LT INNER CHORD FRAME CRACKED AT BS 639, BETWEEN STR 14L TO STR 15L. REPAIRED FRAME PER EA.SDR SWAA115433Hook · out of adjustR1 DOOR EMERGENCY EVAC SLIDE HOOK CLIP OUT OF ADJUST. ADJUSTED CLIP PER MM.SDR SWAA114926Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 376, STR 8L. REPAIRED SKIN PER ER AND ER.SDR SWAA114894Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 376, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA113024Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA112281Terminal · contaminatedDIVERSION / DECLARED EMERGENCY. SMOKE AND FUMES FROM R1 WINDOW UPPER RIGHT ENTERED COCKPIT DURING CRUISE AT 36,000FT. REMOVED DEBRIS FROM TOP RIGHT WINDOW HEAT TERMINAL PER MM.SDR SWAA112274Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 990.3, STR 7L. REPAIRED SKIN PER EA.SDR SWAA112273Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CHORD CORRODED AT BS 277.8, BETWEEN RBL 16 TO LBL 16. REPAIRED FRAME PER EO.SDR SWAA112272Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER EO.SDR SWAA112271Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1006, STR 6L. REPAIRED SKIN PER EO.SDR SWAA112249Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 951, STR 11L. REPAIRED SKIN PER EO AND EA.SDR SWAA112247Crease Beam · corrodedDURING SCHEDULED 242 CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 TO BS 380, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA112234Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, BL 0. REPAIRED WEB PER EA.SDR SWAA112233Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SLAT DELAMINATED ON EXTERNAL SKIN LOWER SUFRACE O/B EDGE. REPAIRED SKIN PER SRM.SDR SWAA112168Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 807, STR 25L. REPAIRED FRAME PER EO.SDR SWAA112167Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 947.5, BETWEEN STR 25R TO STR 24R. REPAIRED FRAME PER EO.SDR SWAA112166Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER EO.SDR SWAA112104Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP PER MM.SDR SWAA112102Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING T/E WEDGE AT I/B MID FLAP DELAMINATED. REMOVED AND REPLACED MID FLAP PER MM.SDR SWAA112186Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 22L TO STR 23L. REPAIRED FRAME PER EA.SDR SWAA112185Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 312 TO BS 323.7, STR 28R. REMOVED AND REPLACED STRINGER PER EO.SDR SWAA112184Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, BL 0. REPAIRED WEB PER EA.SDR SWAA112183Battery · lowDURING SCHEDULED 22Y CHECK, FOUND LT OVERHEAD EMERGENCY EXIT LIGHT BATTERY CHARGER LOW AT BS 616. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA112182Crease Beam · crackedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 706, BETWEEN RBL 45.5 TO RBL 64. REPAIRED BEAM PER EO.SDR SWAA112181Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CRACKED AT BS 597, STR 10R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA112180Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 540, STR 10R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA112179Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 947.5, STR 26R. REPAIRED FRAME PER EO.SDR SWAA112177Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 18R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111600Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO CHANNEL CORRODED AT BS 860, RBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA111599Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO CHANNEL CORRODED AT BS 732D, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA111834Skin · crackedDURING SCHEDULED 22Y CHECK, RT WING NR 6 SLAT SKIN CRACKED AT OUTBOARD EDGE. REPAIRED SKIN PER SRM.SDR SWAA111648Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA111647Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SLAT SKIN I/B EDGE DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA111910Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND CRACK ON DOOR CUTOUT STRUCTURE STA 294.5, STR 7R. REPAIRED FRAME PER EA.SDR SWAA111491Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 860, RBL 3.0. REPAIRED CHANNEL PER EA.
Back to N347SW, cancelled Jan 4, 2018