N316SW, cancelled Sep 10, 2012
Service difficulty reports · 452
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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 SWAA111260Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 635, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA111371Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA111820Skin · crackedDURING SCHEDULED CV CHECK, FOUND CRACK IN FUSELAGE AT STA 787 +17, ABOVE STR 18L BETWEEN TWO EXISTING REPAIRS. REPAIRED PER SRM.SDR SWAA106727Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 16R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106726Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 435, STR 16L. REPAIRED SKIN PER EA.SDR SWAA106724Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 504C, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA106723Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 506B, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA106722Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 395, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA106721Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 434, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA106720Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 426, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA106719Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 506A, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA106718Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 514, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA106717Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 867-3, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA106716Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 375, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA106607Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500C-4, STR 19R. REPAIRED SKIN PER SRM.SDR SWAA106606Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 395, STR 16R. REPAIRED SKIN PER ER.SDR SWAA106653Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106652Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 15L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106651Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 16L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106650Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 15L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106649Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 506B, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA106648Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 867-3, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA106488Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP AT LOWER FWD SIDE. RELAMPED PER MM.SDR SWAA106260Slat · delaminatedDURING SCHEDULED HC1 CHECK, FOUND LT WING NR 2 L/E SLAT DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA105803Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING O/B AFT FLAP T/E DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA104945Battery · looseAFT EMERGENCY EXIT LIGHT BATTERY LOOSE. SECURED BATTERY PER MM.SDR SWAA104477Slide · low pressureDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATOR LOW. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA103902Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 500C, STR 8L. REPAIRED SKIN PER MT.SDR SWAA103901Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE GAUGE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA102009Cable · misroutedDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE MISROUTED. REROUTED CABLE LATCH PER MM.SDR SWAA101843Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 277, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA101771Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 416, STR 16L. REPAIRED SKIN PER EA.SDR SWAA101770Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 406, STR 16L. REPAIRED SKIN PER EA.SDR SWAA101769Shear Tie · crackedDURING SCHEDULED MV1 CHECK, FOUND SHEAR TIE CRACKED AT BS 400, BETWEEN STR 13L TO STR 14L. REPAIRED SHEAR TIE PER EA.SDR SWAA097917Mount · out of adjustR1 DOOR EMERGENCY EVAC SLIDE MOUNTS OUT OF ADJUST. ADJUSTED MOUNTS PER MM.SDR SWAA097778Battery · dischargedFWD FLASHLIGHT INDICATOR INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA097146Control Rod · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT ELEVATOR TAB OUTBOARD CONTROL ROD CORRODED. REMOVED AND REPLACED ROD ASSY PER MM.SDR SWAA096019Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 294.5, STR 27L. REPAIRED FRAME PER ER.SDR SWAA096046Slide · out of adjustDURING SCHEDULED 2HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA095986Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND RT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA095968Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 515, STR 28L. REPAIRED STRINGER PER SRM.SDR SWAA095967Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 485 TO BS 495, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA095966Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER BOX WING FLOORBEAM LOWER CHORD CRACKED AT BS 663, RBL 24.8. REPAIRED BEAM PER ER.SDR SWAA095965Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 669, LBL 24.5. REPAIRED BEAM PER BAC DWG.SDR SWAA095964Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 23R TO STR 22R. REPAIRED FRAME PER ER.SDR SWAA095963Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO BAY SKIN CORRODED AT BS 737, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA095889Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER ER.SDR SWAA095888Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 25L TO STR 26L. REPAIRED FRAME PER ER.SDR SWAA095887Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA095886Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 460, STR 26L. REPAIRED FRAME PER ER.
Back to N316SW, cancelled Sep 10, 2012