N506SW, cancelled Nov 8, 2013
Service difficulty reports · 277
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 = 'N506SW' AND deregistration_id = 'N506SW-2013-11-08' 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 = 'N506SW' AND deregistration_id = 'N506SW-2013-11-08' 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 SWAA050413Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 482 + 16, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043631Tee Fitting · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR LOWER OUTBOARD TEE FITTING, CRACKED. REMOVED AND REPLACED TEE FITTING PER SRM.SDR SWAA043616Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT BS 518, STRINGER 12L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043591Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 277, STRINGER 15R, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043575Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN AT AFT SERVICE DOOR CUTOUT LOWER CORNER CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043574Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM AT BS 665, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA043572Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP AT BS 663, STRINGER 10L, CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA043571Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT ENTRY DOOR, UPPER HINGE CUTOUT LOWER CORNER SKIN, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043558Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR CUTOUT FWD CORNER, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043557Crease Beam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND LT CREASE BEAM BETWEEN BS 400 AND BS 420, CORRODED. REMOVED AND REPLACED CREASE BEAM SECTION PER EA.SDR SWAA043556Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING LOWER RIB CHORD AT WBL 135.5, CRACKED. REPAIRED RIB CHORD PER ACO.SDR SWAA043555Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING LOWER RIB CHORD AT WBL 135.5, CRACKED. REPAIRED RIB CHORD PER ACO.SDR SWAA043538Hook · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR AFT HOOK, CORRODED. REMOVED AND REPLACED GIRT BAR HOOK PER MM.SDR SWAA043537Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR FRAME STRINGER AT BS 360, STRINGER 14L, CRACKED. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA043509Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND BELT FRAME AT BS 616, STRINGER 17R, CRACKED. REPAIRED BELT FRAME PER T1-153-018.SDR SWAA042965Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 470, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042582Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING NR 5 L/E SLAT, DELAMINATED. REPAIRED SLAT PER EA.SDR SWAA042027Cover · damagedEEPLS COVER AT ROW 1 ABC, DISCOLORED. REMOVED AND REPLACED EEPLS COVER PER MM.SDR SWAA042020Skin · delaminatedDURING SCHEDULED A1 CHECK, FOUND LT WING OUTBOARD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED LT OUTBOARD AFT T/E FLAP PER MM.SDR SWAA041598Strip · looseEEPLS PHOTOLUMINESCENT STRIP AT ROW 7 ABC, LOOSE. SECURED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA040969Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBOARD T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING OUTBOARD T/E FLAP PER MM.SDR SWAA040968Skin · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING NR 2 LEADING EDGE SLAT DELAMINATED. REMOVED AND REPLACED LT WING NR 2 LEADING EDGE SLAT PER MM.SDR SWAA040471Slide · dischargedL2 DOOR EVAC SLIDE LOW PRESSURE INDICATION. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR SWAA040441Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 945, STRINGER 24L. REPAIRED FUSELAGE SKIN PER SRM.SDR SWAA032401Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND 2 EA FUSELAGE FRAMES CRACKED AT BS 188, WL 207, LT AND RT SIDES. REPAIRED FRAMES PER SRM.SDR SWAA032015Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 482B AND BS 520, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA031966Slide · out of positionDURING SCHEDULED A2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA031834Apu · malfunctionedAIR TURNBACK, SMOKE REPORTED IN CABIN. REMOVED AND REPLACED APU AND WATER SEPARATOR BAGS PER MM.SDR SWAA031831Slide · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA022120Lens · missingDURING SCHEDULED C1 CHECK, FOUND OVERHEAD BIN BULLNOSE EMERGENCY LIGHT LENS AT ROW NR 5 DEF MISSING. INSTALLED LENS PER MM.SDR SWAA022052Slide · defectiveFWD SVC DOOR EMERGENCY EVAC SLIDE GIRT BAR WOULD NOT LATCH PROPERLY. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA021814Pin · brokenDURING SCHEDULED RON, FOUND LEFT OVERWING EMERGENCY EXIT LIGHT INOP. FOUND BROKEN PIN IN CONNECTOR D2964. REPAIRED CONNECTOR PER MM.SDR SWAA021294Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT LOWER CORNER OF CUTOUT FOR FWD SVC DOOR. REPAIRED SKIN PER SWA ER.SDR SWAA021264Light · looseDURING SCHEDULED 1/4D CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 3 ABC. SECURED LIGHT PER MM.SDR SWAA021278Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA021232Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR AFT FRAME CRACKED AT CUTOUT FOR 5TH STOP FROM BOTTOM. REPAIRED FRAME PER SRM.SDR SWAA021233Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SVC DOOR AFT FRAME CRACKED AT CUTOUT FOR 3RD STOP FROM BOTTOM. REPAIRED FRAME PER SRM.SDR SWAA021220Light · looseDURING SCHEDULED 1/4D CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHTS LOOSE AT ROW'S 11ABC AND 15ABC. SECURED LIGHTS PER MM.SDR SWAA013110Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED (6 EA) AT BS 178, BETWEEN LBL 10 & RBL 11. REPAIRED WEB PER SRM.SDR SWAA012069Cover · looseEEPLS COVER COVER LOOSE AT ROW 10. INSTALLED EEPLS COVER PER MM.SDR SWAA012060Cover · looseEEPLS COVER LOOSE AT ROW 10. SECURED EEPLS COVER PER MM.SDR SWAA011155Bushing · wornFLT CONTROL VIBRATION FELT ABOVE 230 KTS. VIBRATION INCREASES WITH POSITIVE ANGLE OF ATTACK. R&R LT ELEVATOR TAB INBD HINGE BUSHINGS & HARDWARE PER MM.SDR SWAA010749Lens · looseEEPLS LENS LOOSE AT ROW 7. REMOVED AND REPLACED EEPLS TRACK COVER AND LENS PER MM.SDR SWAA010706Lens · looseEEPLS LENS LOOSE AT ROW 7. SECURED EEPLS LENS PER MM.SDR SWAA010698Cover · missingEEPLS TRACK COVER MISSING AT MID CABIN. INSTALLED TRACK COVER PER MM.SDR SWAA002399Cover · looseEEPLS TRACK COVER LOOSE AT ROW 7. RESECURED TRACK COVER PER PER MM.SDR SWAA001059Gate · out of adjDIVERSION, CABIN AIR PRESSURIZATION LEAK AROUND AFT ENTRY DOOR. ADJUSTED AFT ENTRY DOOR LOWER GATE PRESS SEAL. OPS CK GOOD PER MM.SDR SWAA000200Web · crackedDURING SCHEDULED D CHECK, FOUND MAIN WHEEL WELL PRESS WEB CRACKED, BS 664.5, LBL 32, WL 200. REPAIRED WEB PER ER 00-0011.SDR SWAA000181Frame · crackedDURING SCHEDULED D CHECK, FOUND 4 EACH FRAMES CRACKED, BS 867, BETWEEN STRINGERS 8L-9L AND STRINGERS 8R-9R, BS 827 BETWEEN STRINGERS 8L-9L AND 8R-9R. REPAIRED FRAMES PER SRM AND ER.SDR SWAA000180Frame · crackedDURING SCHEDULED D-CHECK, FOUND 4 FRAMES CRACKED, BS 747, BETWEEN STRINGERS 8L-9L AND STRINGERS 8R-9R, BS 787 BETWEEN STRINGERS 8L-9L AND 8R-9R. REPAIRED FRAMES PER SRM AND ER.
Back to N506SW, cancelled Nov 8, 2013