N369SW, cancelled Mar 22, 2018
Service difficulty reports · 323
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 = 'N369SW' AND deregistration_id = 'N369SW-2018-03-22' 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 = 'N369SW' AND deregistration_id = 'N369SW-2018-03-22' 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 SWAA090908Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 928, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090835Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 847, STR 15R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA090834Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090833Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND INTERNAL DOUBLER SKIN CORRODED AT BS 950, BETWEEN STR 23L TO STR 24L. REPAIRED SKIN PER SRM.SDR SWAA090832Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO BS 400. REPAIRED BEAM PER SRM.SDR SWAA090825Attach Bracket · corrodedDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR ATTACH BRACKET CORRODED, BS 312. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA090756Flap · puncturedDURING SCHEDULED SPV CHECK, FOUND LT WING I/B AFT FLAP PUNCTURED. REPAIRED AFT FLAP PER SRM.SDR SWAA090474Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOOR STUB BEAM CRACKED AT BS 639, LBL 45. REMOVED AND REPLACED BEAM PER DWG.SDR SWAA090400Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 847, STR 14R. REPAIRED STRINGER PER SRM.SDR SWAA090399Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 1. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA090296Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 5R. R&R CLIP PER SRM.SDR SWAA090295Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4L. R&R CLIP PER SRM.SDR SWAA090294Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 2L. R&R CLIP PER SRM.SDR SWAA090293Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR. 6L. R&R CLIP PER SRM.SDR SWAA090292Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME ANGLE CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA090291Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 1 SLAT LOWER T/E SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA090210Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED AT BETWEEN BS 380 TO BS 400. REPAIRED BEAM PER SRM.SDR SWAA086414Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA086000Garlock Seal · leakingDIVERSION, NR 1 ENG OIL QUANTITY LOSS INDICATION. FOUND OIL LEAK AT NR 1 ENG FUEL PUMP. REMOVED AND REPLACED GARLOCK SEAL PER MM.SDR SWAA083459Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA083458Pressure Panel · crackedDURING SCHEDULED MV2 CHECK, FOUND BEADED PRESSURE DECK WEB CRACKED AT BS 540, LBL 25. REPAIRED WEB PER SRM.SDR SWAA083457Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730E, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA083456Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 729D, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA081140Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 973, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA076073Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505D, STR 14R. REPAIRED SKIN PER EA.SDR SWAA076074Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 12L. REPAIRED SKIN PER EA.SDR SWAA076019Light · inoperativeDURING SCHEDULED 14Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076011Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 390, RBL 1.5. REPAIRED SKIN PER EA.SDR SWAA075943Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075944Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075945Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075874Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075812Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER ACO.SDR SWAA074870Lens · missingDURING SCHEDULED SERVICE CHECK, FOUND EEPLS LENS MISSING AT ROW 12 DEF. INSTALLED LENS PER MM.SDR SWAA073317Slide · brokenDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE COVER BROKEN. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA073319Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073318Light · inoperativeDURING SCHEDULED C2 CHECK, FOUND RT FWD CABIN EMERGENCY EXIT SIDEWALL LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA072975Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072670Slide · low pressureDURING SCHEDULED SERVICE CHECK, L2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA071685Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070232Slide · dislodgedDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA070103Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 1, WL 186. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA064871Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 522, STR 28R, AIR CONDITIONING DOOR CUTOUT RIGHT FWD CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA064870Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 937, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA061993Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 525, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA061034Lens · brokenDURING SCHEDULED A1 CHECK, FOUND L1 DOOR LOWER EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA060808Nut · corrodedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT MLG INBOARD TRUNNION NUT CORRODED. REMOVED AND REPLACED TRUNNION NUT PER MM & CCO.SDR SWAA053706Door Frame · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR FWD FRAME CRACKED AT LOWER STOP FITTING. REMOVED AND REPLACED CARGO DOOR PER MM.SDR SWAA052588Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER SWA EA & SRM.SDR SWAA052577Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 767, STR 27R. REMOVED AND REPLACED CLIP PER SRM.
Back to N369SW, cancelled Mar 22, 2018