N349SW, cancelled Apr 24, 2018
Service difficulty reports · 411
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 = 'N349SW' AND deregistration_id = 'N349SW-2018-04-24' 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 = 'N349SW' AND deregistration_id = 'N349SW-2018-04-24' 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 SWAA2013020412251Skin · crackedSKIN CRACK AT BS 405 TO 406 ABOVE STR-26R. REPAIRED SKIN IAW EA.SDR SWAA2013020412250Skin · crackedSKIN CRACKED AT BS 473.25 TO 475 ABOVE STR-16L. REPAIRED SKIN IAW EA.SDR SWAA2013013112152Skin · crackedSKIN CRACK AT BS 502 TO 503.25 ABOVE STR-17R. REPAIRED SKIN IAW SRM.SDR SWAA2013010911322Control Panel · faultyDIVERSION -- DURING INITIAL CLIMB CABIN OVER PRESSURIZED. REMOVED AND REPLACED CABIN CONTROL PANEL PER MM.SDR SWAA2012122810927Sign · brokenAFT EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER M/M.SDR SWAA2012120510254Battery Pack · dischargedLEFT AND RIGHT UPPER AND LOWER OVERWING EMERGENCY EXIT LIGHTS ARE INOP. REMOVED AND REPLACED BATTERY PACKS FOR LEFT AND RIGHT UPPER AND LOWER OVERWING EMERGENCY EXIT LIGHTS IAW M/M.SDR SWAA2012112809989Intercostal · brokenINTERCOSTAL IS BROKEN AT STA 380-STA 400 BL "0". REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-02 AND SRM 51-40-02.SDR SWAA2012120310176Structure · damagedNR 4 SLAT OUTBOARD SLAT CAN HAS EVIDENCE OF INTERNAL DAMAGE. REPAIRED PER EA.SDR SWAA201212030175Structure · damaged3 SLAT OUTBOARD SLAT CAN HAS EVIDENCE OF INTERNAL DAMAGE. REPAIRED PER EA.SDR SWAA2012112609895Seat Track · corrodedMAIN CABIN FLOOR STRUCTURE STA 871-873 CORROSION ON NR 1 SEAT TRACK. REPAIRED SEAT TRACK FROM STA 867 TO 907 LBL 45 PER SRM 53-00-52-2R-3 AND EA 1-353-21100.SDR SWAA2012112609894Seat Track · corrodedMAIN CABIN FLOOR STRUCTURE STA 888-890 CORROSION ON NR 1 SEAT TRACK. REPAIRED SEAT TRACK FROM STA 867 TO 907 LBL 45 PER SRM 53-00-52-2R-3 AND EA 1-353-21100.SDR SWAA2012112609892Skin · crackedFOUND FUSELAGE SKIN DAMAGED AT THREE AREAS (MARKED) WHERE DORSAL FIN APEX MATES TO FUSELAGE. REPAIRED PER EA.SDR SWAA2012112609891Support Fitting · crackedRIGHT SIDE CENTER AIR DISTRIBUTION DUCT SUPPORT FITTING AT STA 907 IS CRACKED. REMOVED AND REPLACED BRACKET PER SRM 51-10-2.SDR SWAA2012112609890Frame · crackedFRAME CRACKED AT STRINGER CUTOUT, BS 380 STR 26L. REPAIRED IAW SRM 53-00-07-2R.SDR SWAA2012111609565Frame · crackedAFT CARGO, FWD DOOR FRAME, INNER CLOSURE WEB CRACKED AT FWD LWR CORNER. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA2012112609893Keelbeam · corrodedFWD CARGO PIT, STA 500D+5", LBL 6", CORROSION ON LEFT KEEL BEAM ON O/B SIDE (MKD). REPAIRED LEFT KEEL BEAM AT STA 500D+5 PER SRM 53-30-12-2R-2.SDR SWAA2012110909205Light · crackedLEFT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT CRACKED AT ROW 12. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA2012100808314Cover · looseR2 DOOR SLIDE COVER LOOSE. REMOVED AND REPLACED DOOR SLIDE COVER PER AMM.SDR SWAA2012100908335Slat · chafedNR 4 SLAT AFT UPPER INBOARD END CHAFED THROUGH PREVIOUS REPAIR. REPAIRED SLAT PER SRM.SDR SWAA2012100808313Flap · delaminatedRIGHT WING OUTBOARD AFT FLAP DELAMINATED ON TRAILING EDGE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA2012100108203Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA2012062205160Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2012062205159Stringer · corrodedSTRINGER CORRODED BETWEEN BS 968 TO BS 986.5, STR 25L. REMOVED AND REPLACED STRINGER IAW SRM AND DWG.SDR SWAA2012062205158Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, STR 25L. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012062205157Skin · crackedSKIN CRACKED AT BS 971, STR 24L. REPAIRED SKIN IAW EA.SDR SWAA2012062505191Skin · crackedFUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012061905068Skin · crackedSKIN CRACKED AT BS 520, STR 13R. REPAIR SKIN IAW ER AND EA.SDR SWAA2012061905067Skin · crackedFUSELAGE SKIN CRACKED AT BS 380, STR 15R. REPAIRED SKIN PER ER AND EA.SDR SWAA2012061404899Skin · crackedSKIN CRACKED AT BS 500A+ 6, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012061404898Skin · crackedSKIN CRACKED AT BS 500B+ 13, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA2012060504672Skin · crackedSKIN CRACKED AT BS 500A+ 14, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012062605319Skin · crackedSKIN CRACKED AT BS 520, STR 13R. REPAIRED SKIN PER SRM.SDR SWAA2012062605315Skin · crackedFUSELAGE SKIN CRACKED AT BS 380, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA2012062605314Skin · crackedSKIN CRACKED AT BS 500A+14, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012062605313Skin · crackedSKIN CRACKED AT BS 500A+6, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012062605312Skin · crackedSKIN CRACKED AT BS 500B+6, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA2012022001555Skin · crackedFUSELAGE SKIN IS CRACKED AT BS 265 TO 271.3, S9L. REPAIRED SKIN IAW SRM 53-00-01.SDR SWAA2012020901268Skin · crackedFUSELAGE SKIN IS CRACKED FROM BS 265-271, STR 9L. REPAIRED SKIN PER SRM.SDR SWAA116136Module · faultyDECLARED EMERGENCY - AT FL340 HYDRAULIC FUMES AND SMOKE IN CABIN. REMOVED AND REPLACED HYDRAULIC AIR PRESSURE MODULE PER MM.SDR SWAA115990Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 500B+5, STR 15R. REPAIRED SKIN IAW ER AND EA.SDR SWAA115989Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 500D+6, STR 16R. REPAIRED SKIN IAW EA AND ER.SDR SWAA115972Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500D+6, STR 16R. REPAIRED SKIN PER ER AND EA.SDR SWAA115929Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500B+5, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA115993Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 500B+5, STR 15R. REPAIRED SKIN PER ER AND EA.SDR SWAA115992Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 500D+6, STR 16R. REPAIRED SKIN PER ER AND EA.SDR SWAA115749Actuator · brokenRT WING NR 5 GROUND SPOILER O/B ACTUATOR LOWER MOUNTING TAB BROKEN. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA113406Skin · delaminatedDURING SCHEDULED 16Y CHECK FOUND, RT WING NR 9 SPOILER LOWER SKIN DELAMINATED. REPAIRED SPOILER PER SRM.SDR SWAA113373ASkin · corrodedDURING SCHEDULED 16Y CHECK FOUND, AFT CARGO COMPARTMENT CORRODED ON INTERNAL SKIN ON BS .942 ST2 26L. REPAIRED SKIN IAW EO.SDR SWAA113372Frame · corrodedDURING SCHEDULED 16Y CHECK FOUND, CORROSION ON FWD AND AFT FACE OF FRAME LOCATED BS 727D BETWEEN STR 27L TO STR 27R AFT CARGO COMPARTMENT. REPAIRED SECTION OF FRAME IAW SRM.SDR SWAA113347Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACK IN CHEM-MILLED AREA, BS 747+2.5 AND BELOW S-19L. REPAIRED PER DOC.
Back to N349SW, cancelled Apr 24, 2018