N105SW, cancelled Jun 7, 2013
Service difficulty reports · 156
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 = 'N105SW' AND deregistration_id = 'N105SW-2013-06-07' 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 = 'N105SW' AND deregistration_id = 'N105SW-2013-06-07' 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 SWAA020605Frame · crackedDURING SKIN REPAIR, FOUND BELL FRAME CRACKED AT BS 907, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA020604Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA020519Cap · missingDURING SCHEDULED C3 CHECK, FOUND EEPLS END CAP MISSING IN AFT CABIN. INSTALLED END CAP PER MM.SDR SWAA020453Skin · crackedDURING SCHEDULED RON, FOUND FUSELAGE SKIN CRACKED 2.50 INCHES LONG AT BS 905, STR 25R. REPAIRED SKIN PER SWA RA.SDR SWAA020399Slide · out of positionDURING SCHEDULED RON, FOUND AFT SERVICE DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013321Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013113Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013079Uplock Sensor · failedAFTER GEAR RETRACTION RED NOSE GEAR LIGHT STAYED ON. CYCLED GEAR, LIGHT STAYED ON WITH GEAR UP. REMOVED AND REPLACED UPLOCK SENSOR ON NLG PER MM.SDR SWAA012922Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012669Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA012591Slide · unserviceableDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA012571Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, BETWEEN STR 8R & 9R. REPAIRED FRAME PER BFG ER 01-0788SDR SWAA012570Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED ( 2 EA ) AT BS 767 & BS 807, BETWEEN STR 8L & 9L. REPAIRED FRAMES PER BFG ER 01-0788.SDR SWAA012566Web · crackedDURING SCHEDULED D CHECK, FOUND VERTICAL BEAM WEBS CRACKED ( 2 EA ) AT BS 178, WL 175 & WL 177, RBL 17.1. R&R WEBS PER BFG ER 01-0781.SDR SWAA012573Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR FWD LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM & ER 01-0796.SDR SWAA012535Fitting · crackedDURING SCHEDULED D-CHECK, FOUND Lt W/W SUPPORT FITTING CRACKED AT BS 716, LBL 68 & WL 192. REPAIRED FITTING PER SRM.SDR SWAA012533Web · corrodedDURING SCHEDULED D-CHECK, FOUND WEB CORRODED AT BS 810-823, RBL 66 & WL 199.v Removed and replaced WEB PER SRM.SDR SWAA012551Crease Beam · crackedDURING SCHEDULED D CHECK, FOUND CREASE BEAM CRACKED AT BS 189, STR 17L, WL 207. REPAIRED CREASE BEAM PER BFG ER.SDR SWAA012446Splice · crackedDURING SCHEDULED D CHECK, FOUND STR SPLICE CRACKED AT BS 365, STR 5L. R&R STR SPLICE PER SRM.SDR SWAA012462Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA012461Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, BETWEEN STR 8R & 9R. REPAIRED FRAME PER SRM.SDR SWAA012460Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 986.5, BETWEEN STR 21R & 22R. R&R SHEAR TIE PER SRM.SDR SWAA012458Wedge · delaminatedDURING SCHEDULED D CHECK, FOUND # 2 SLAT T/E WEDGE DELAMINATED. R&R SLAT ASSY PER MM.SDR SWAA012420Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 663, STRINGER 10R. R&R STRINGER CLIP PER SRM.SDR SWAA012434Tie · crackedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CRACKED AT BS 500A, LBL 25. R&R SHEAR TIE PER SRM.SDR SWAA012459Wedge · delaminatedDURING SCHEDULED D CHECK, FOUND # 3 SLAT T/E WEDGE DELAMINATED. R&R SLAT ASSY PER MM.SDR SWAA012428Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 2 EA ) AT STR 16L, BS 767 & BS 787. R&R STR CLIPS PER SRM.SDR SWAA012435Stringer · crackedDURING SCHEDULED D CHECK, FOUND STR CRACKED AT BS 807, STR 16L. REPAIRED STR PER SRM.SDR SWAA012390Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIP CRACKED AT BS 616, STR 7L. R&R STR CLIP PER SRM.SDR SWAA012380Stringer · crackedDURING SCHEDULED D CHECK, FOUND STR 5R LWR CHORD CRACKED BETWEEN BS 1138-1145, . R&R STR SECTION PER SRM.SDR SWAA012391Frame · crackedDURING SCHEDULED D CHECK, FOUND FRAME CRACKED AT BS 616, STR 7L. REPAIRED FRAME PER SRM.SDR SWAA012396Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED AT BS 787, STR 7R, BS 807, STR 10L, BS 847, STR 4L. R&R STR CLIPS PER SRM.SDR SWAA012394Clip · crackedDURING SCHEDULED D CHECK, FOUND ( 2 EA ) STR CLIPS CRACKED AT BS 747, STR 6R, & 7R. R&R STR CLIPS PER SRM.SDR SWAA012389Frame · corrodedDURING SCHEDULED D-CHECK, FOUND HORIZONTAL CHORD CORRODED AT LWR APU AIR INLET BETWEEN BS 1167-1177. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA012429Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIP CRACKED AT BS 1138, STR 13L. R&R STR CLIP PER SRM.SDR SWAA012402Skin · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, BETWEEN STR 28R & 28L. REPAIRED SKIN PER SRM.SDR SWAA012395Clip · crackedDURING SCHEDULED D CHECK, FOUND ( 4 EA ) STR CLIPS CRACKED AT BS 727, STR 5R, 4R, 7L, 5L. R&R STR CLIPS PER SRM.SDR SWAA012363Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 7 EA ) AT BS 727A, STR'S 7R & 7L, BS 727B, STR'S 7R, 7L, 6R, 6L, BS 887, STR 4L. R&R STR CLIPS PER SRM.SDR SWAA012408Clip · crackedDURING SCHEDULED D CHECK, FOUND STR CLIPS CRACKED ( 3 EA ) AT BS 420, STR 10L, BS 747, STR 16L, BS 520, STR 19L. R&R STR CLIPS PER SRM.SDR SWAA012182Slide · out of positionDURING SCHEDULED RON CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE PER MM.SDR SWAA012110Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SERVICE DOOR EVACUATION SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE ASSY PER MM.SDR SWAA011834Bearing · wornDECLARED EMERGENCY……………….DURING GEAR EXTENSION FOR LANDING, THE LEFT MAIN RED LIGHT REMAINED ON & NO GREEN LIGHT. NOSE & RIGHT MAIN WERE GREEN. AFTER MANUAL GEAR EXTENSION RED LIGHT REMAINED ON.. INSTALLED LEFT MSDR SWAA011798Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011383Cap · missingDURING SCHEDULED C4 CHECK, FOUND EEPLS END CAP MISSING AT FWD END. INSTALLED END CAP PER MM.SDR SWAA011354Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EMERGENCY EVAC SLIDE PER MM.SDR SWAA011328Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 870, BELOW STR 24R. REPAIRED SKIN PER SRM.SDR SWAA011217Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA011205Slide · out of adjAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY OUT OF ADJUST. READJUSTED EVAC SLIDE ASSY PER MM.SDR SWAA011165Slide · out of positionAFT DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA011043Actuator · failedAIR TURNBACK, NR 4 L/E SLAT WOULD NOT RETRACT. VISUALLY VERIFIED SLAT NOT RETRACTED. R&R SLAT ACTUATOR PER MM. OPS & LEAK CHECK GOOD.
Back to N105SW, cancelled Jun 7, 2013