N716SW, cancelled Nov 13, 2024
Service difficulty reports · 274
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 = 'N716SW' AND deregistration_id = 'N716SW-2024-11-13' 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 = 'N716SW' AND deregistration_id = 'N716SW-2024-11-13' 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 SWAA2013050215443Slide · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2013020412330Slide · crackedRIGHT HORIZONTAL STAB FWD LOWER SLIDE CRACK. REMOVED AND REPLACED PER AMM.SDR SWAA2013020412329Slide · crackedLEFT HORIZONTAL STAB FWD LOWER SLIDE CRACK. REMOVED AND REPLACED PER AMM.SDR SWAA2013020412328Battery Pack · dischargedRIGHT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED PER AMM BATTERY PACK M1669.SDR SWAA2013020412327Battery Pack · dischargedLEFT OVERWING EMERGENCY LIGHTS INOP. REMOVED AND REPLACED PER AMM BATTERY PACK M1668.SDR SWAA2013020412326Battery Pack · dischargedFWD LEFT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED PER AMM BATTERY PACK M1674.SDR SWAA2012122710902Escape Rope · pulledLEFT OVERWING EMERGENCY EXIT ROPE PULLED. INSTALLED LIFELINE (ROPE) PER AMM.SDR SWAA2012112109680Engine · malfunctionedIN FLT SHUT DOWN/DIVERSION/EMERGENCY DECLARED NR 2 ENG OIL FILTER BYPASS LIGHT IND AND VIBRATION INDICATION HIGH. REMOVED AND REPLACED NR 2 ENG PER MT.SDR SWAA2012080306419Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2012050903834Window Frame · crackedCAPTAINS NR 1 WINDOW EXTERNAL FRAME O/B POST CRACKED AT THE UPPER CORNER. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA2012021301415Light · inoperativeRT EXTERNAL EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA118688Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA117450Battery Pack · no testDURING SCHEDULED HC1 CHECK, AFT CABIN EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA117426Battery Pack · failedDURING SCHEDULED HC1 CHECK, CENTER CABIN EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA117407Battery Pack · failedDURING SCHEDULED HC1 CHECK, FWD CABIN EMERGENCY EXIT LIGHT FAILED CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA115077Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT AT ROW 18. RELAMPED LIGHT PER MM.SDR SWAA114748Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT AFT EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA110958Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA106752Window · arcedL2 COCKPIT WINDOW ARCED. REMOVED AND REPLACED WINDOW AND CONTROLLER PER MM.SDR SWAA104157Light · inoperativeDURING SCHEDULED HC1 CHECK, FOUND RT EMERGENCY EXIT SIDEWALL LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA103308Fitting · looseDURING SCHEDULED 12Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA103259Light · inoperativeDURING SCHEDULED 12Y CHECK, FOUND EXTERIOR EMERGENCY EXIT LIGHT INOP AT L1 DOOR. RELAMPED PER MM.SDR SWAA103258Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 420, BETWEEN STR 14L TO STR 15L. REPAIRED FRAME PER AAR EA.SDR SWAA103243Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND LT SIDE LANDING GEAR FUSELAGE SUPPORT FRAME CORRODED AT BS 695. REPAIRED FRAME PER AAR EA.SDR SWAA103242Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND RT SIDE LANDING GEAR FUSELAGE SUPPORT FRAME CORRODED AT BS 695. REPAIRED FRAME PER AAR EA.SDR SWAA103122Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND LT WING NR 2 SLAT LOWER SKIN CRACKED. REPAIRED SLAT PER AAR EA.SDR SWAA103094Stringer Clip · crackedDURING SCHEDULED 12Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA102972Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA102971Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA102970Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA102969Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA102938Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND L1 DOOR LOWER CREASE BEAM CORRODED BETWEEN BS 291 TO BS 332. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA101597Lens · looseDURING SCHEDULED CV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA095245Cable · out of positionL1 DOOR EMERGENCY EVAC SLIDE COVER CABLE OUT OF POSITION. REPOSITIONED CABLE PER MT.SDR SWAA083678Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. R&R LIGHT BULB PER MM.SDR SWAA083644Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA083292Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA083291Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076061Battery Pack · failedDURING SCHEDULED HC1 CHECK, RT OVERWING EMERGENCY EXIT BATTERY PACK FAILED LONG TEST. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA076060Battery Pack · failedDURING SCHEDULED HC1 CHECK, EMERGENCY EXIT BATTERY PACK AT ROW 16 ABC FAILED LONG TEST. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA076059Battery Pack · failedDURING SCHEDULED HC1 CHECK, AFT CABIN EMERGENCY EXIT BATTERY PACKS FAILED LONG TEST. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA076058Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 138.7. REPAIRED SKIN PER SRM.SDR SWAA076057Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 129.5. REPAIRED SKIN PER SRM.SDR SWAA070414Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT INOP AT ROW 6 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063487Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORR0DED AT BS 986, RBL 44. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA062578Battery · inoperativeDURING SCHEDULED 8Y CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA062524Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 44. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA062523Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 771, RBL 13 TO LBL 13. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA060108Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA060107Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.
Back to N716SW, cancelled Nov 13, 2024