N635SW, cancelled Nov 28, 2018
Service difficulty reports · 319
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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 SWAA101378Floorbeam · crackedDURING SCHEDULED 14Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD AFT END CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER ER.SDR SWAA101288Beam · crackedDURING SCHEDULED 14Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 185, LBL 17. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA101218Web · crackedDURING SCHEDULED 14Y CHECK, FOUND VERTICAL BEAM WEB CRACKED BETWEEN BS 178 TO BS 183, RBL 17. REMOVED AND REPLACED WEB PER SRM.SDR SWAA101206Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101205Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101202Angle · crackedDURING SCHEDULED 14Y CHECK, FOUND ANGLE CRACKED AT BS 293, BETWEEN STR 12R TO STR 13R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA101201Angle · crackedDURING SCHEDULED 14Y CHECK, FOUND ANGLE CRACKED AT BS 293, BETWEEN STR 9R TO STR 10R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA101143Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101142Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101141Angle · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE ANGLE CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BS 291, WL 255. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA095060Skin · damagedDURING SCHEDULED HC2 CHECK, FOUND SKIN DAMAGED AT BS 1048, BETWEEN STR 24L TO STR 25L. REPAIRED SKIN PER SWA EA.SDR SWAA091862Holder · out of adjustDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOLDER OUT OF ADJUST. ADJUSTED HOLDER PER MM.SDR SWAA090638Lens · crackedDURING SCHEDULED HC1 CHECK, FOUND FWD OVERHEAD EMERGENCY EXIT SIGN LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA090637Light · looseDURING SCHEDULED HC1 CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT ASSY LOOSE. SECURED LIGHT PER MM.SDR SWAA090636Track · damagedDURING SCHEDULED HC1 CHECK, FOUND RT EEPLS TRACK DAMAGED BETWEEN ROW 12 TO ROW 13. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA090288Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. R&R LIGHT PER MM.SDR SWAA082141Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA081635Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081634Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, STR 27L TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA081599Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081633Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 807, STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA081636Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081588Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081587Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 787, STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA081572Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081573Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081574Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080834Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080644Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA076479Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA075681Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072426Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064387Lens · looseDURING SCHEDULED HC1 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA064218Lens · looseRT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT LENS PER MM.SDR SWAA063292Battery Pack · dischargedDURING SCHEDULED MV3 CHECK, FOUND RT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA061588Rib · crackedDURING SCHEDULED 10Y CHECK, FOUND RT WING RIB CRACKED AT WBL 135.5, BETWEEN STR 2 AND STR 3. REPAIRED WING RIB PER SRM.SDR SWAA061585Torque Tube · corrodedDURING SCHEDULED 10Y CHECK, FOUND RT WING T/E MID FLAP OUTBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED OUTBOARD TORQUE TUBE PER CMM AND SRM.SDR SWAA061584Torque Tube · corrodedDURING SCHEDULED 10Y CHECK, FOUND RT WING T/E MID FLAP INBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED INBOARD TORQUE TUBE PER CMM AND SRM.SDR SWAA061583Flap Track · corrodedDURING SCHEDULED 10Y CHECK, FOUND RT WING T/E MID FLAP CETER FORE FLAP TRACK CORRODED. REMOVED AND REPLACED FORE FLAP TRACK PER CMM AND SRM.SDR SWAA061582Fitting · corrodedDURING SCHEDULED 10Y CHECK, FOUND LT AND RT HORIZONTAL STAB FITTING LUG FACES CORRODED. REPAIRED HORIZONTAL STAB FITTING PER SRM.SDR SWAA061581Floorbeam · crackedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 246, RBL 23, WL 208. REPAIRED FLOORBEAM WEB PER SRM.SDR SWAA061580Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 989, RBL 48. REMOVED AND REPLACED FLOORBEAM WEB PER SRM.SDR SWAA061579Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, FROM LBL 55 TO RBL 55. REPAIRED FLOORBEAM PER ER.SDR SWAA061578Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061577Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061576Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061575Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061574Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, AT STR 8L AND STR 8R. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR SWAA061573Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, AT STR 8L AND STR 8R. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR SWAA061572Hinge Fitting · corrodedDURING SCHEDULED 10Y CHECK, FOUND L1 DOOR LOWER HINGE FITTING CORRODED. REMOVED AND REPLACED L1 DOOR HINGE FITTING PER SWA EA AND SRM.
Back to N635SW, cancelled Nov 28, 2018