N507SW, cancelled Jan 29, 2014
Service difficulty reports · 338
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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 = 'N507SW' AND deregistration_id = 'N507SW-2014-01-29' 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 SWAA074266Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074235Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074215Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074216Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074214Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA074213Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND LEFT KEEL BEAM CORRODED AT BS 488B, LBL 6.50. REPAIRED KEEL BEAM PER SRM.SDR SWAA074163Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 16L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073290Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT LOWER LT SIDE. REPAIRED SKIN PER SWA EA.SDR SWAA073292Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT LOWER END. REPAIRED SKIN PER SWA EA.SDR SWAA073291Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 927, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA071115Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP AT ROW 20 DEF. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA071087Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA064788Connector · looseDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT OVERHEAD LIGHTS INOP. SECURED BATTERY PACK CONNECTOR PER MM.SDR SWAA064787Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND FWD CABIN EMERGENCY EXIT OVERHEAD LIGHTS INOP. REMOVED AND REPLACED LIGHT BULBS PER MM.SDR SWAA064786Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA064785Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER BOEING SB.SDR SWAA064784Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, BL 0. REPAIRED SKIN PER BOEING SB.SDR SWAA064234Battery · looseDURING SCHEDULED SERVICE CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. RECONNECTED CONNECTOR AT BATTERY PACK PER MM.SDR SWAA064152Battery · inoperativeDURING SCHEDULED MV2 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA063525Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 812, STR 19L. REPAIRED SKIN IAW SWA EA.SDR SWAA063524Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 797, STR 19L. REPAIRED SKIN IAW SWA EA.SDR SWAA063339Battery · inoperativeDURING SCHEDULED C2 CHECK, FOUND RIGHT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA061909Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 486, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA061805Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA061627Skin · crackedDURING SCHEDULED A2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 766, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA060634Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 6R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060566Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 797, STR 18L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060332Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 881 TO BS 893, STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA060331Bear Strap · corrodedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT BS 867, STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA053685Wire · brokenDURING SCHEDULED SPECIAL VISIT, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REPAIRED WIRE NR W1150-559-20 PER WDM AND MM.SDR SWAA053684Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT, FWD FRAME NR 5 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA053683Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME LOWER CORNER. REPAIRED FRAME PER BFG ER.SDR SWAA053656Door Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, AFT FRAME NR 5 STOP FITTING. REPAIRED FRAME PER BFG ER.SDR SWAA053655Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 361.5, STR 17L. REPAIRED SKIN PER BFG ER.SDR SWAA053471Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053402Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BLKHD WEB CRACKED AT RBL 17.1 & LBL 17.1, WL 227. REPAIRED WEB PER SRM.SDR SWAA053232Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 807, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA052965Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052568Motor · faultyLOUD NOISE HEARD WHEN FLAPS ARE EXTENDED & RETRACTED. REMOVED AND REPLACED FLAP HYDRAULIC DRIVE MOTOR PER MM.SDR SWAA052507Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 784, STR 19L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052398Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA052331Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 757, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA052117Slide · out of positionR2 DOOR EVACUATION SLIDE OUT OF POSITITON. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA050710Lens · out of positionDURING SCHEDULED 1/2D CHECK, R1 DOOR EMERGENCY EXIT LIGHT COVER FELL OFF. REINSTALLED COVER PER MM.SDR SWAA050687Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 907, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA050686Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND NOSE W/W CEILING CRACKS ON LT & RT SIDE AT BRAKE PAD ATTACH POINT, BS 251.6. REPAIRED NOSE W/W CEILING PER SWA EA.SDR SWAA050649Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK AT BS 178 BULKHEAD, WL 198, RBL 5.7. REPAIRED BULKHEAD PER SRM.SDR SWAA050632Floor Support · crackedDURING SCHEDULED 1/2D CHECK, FOUND CENTER CABIN LONGITUDINAL FLOOR SUPPORT CRACKED AT BS 664, BL 0. REPAIRED FLOOR SUPPORT PER SWA EA.SDR SWAA050627Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED R1 DOOR SKIN PER SRM.SDR SWAA050608Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED STRINGER AT BS 360, STR 15L. REPAIRED STRINGER PER SRM.
Back to N507SW, cancelled Jan 29, 2014