N339SW, cancelled Feb 16, 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 = 'N339SW' AND deregistration_id = 'N339SW-2018-02-16' 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 = 'N339SW' AND deregistration_id = 'N339SW-2018-02-16' 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 SWAA095305Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727D, BETWEEN STR 19R TO STR 20R. REPAIRED SHEAR TIE PER BAC DWG.SDR SWAA095304Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 908, STR 25R. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA095303Skin · debondedDURING SCHEDULED SPV CHECK, FOUND SKIN DISBONDED AT BS 908, STR 10R. REPAIRED SKIN PER ER.SDR SWAA095302Skin · debondedDURING SCHEDULED SPV CHECK, FOUND SKIN DISBONDED AT BS 360, BETWEEN STR 8R TO STR 9R. REPAIRED SKIN PER ER.SDR SWAA095213Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 1006, BETWEEN STR 24L TO STR 25L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA094993Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 400 TO BS 420, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA094992Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 867 TO BS 887, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA094852Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094851Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094850Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094670Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 308, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094669Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094668Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094600Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094562Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND SKIN CORRODED BETWEEN BS 907 TO BS 967, BETWEEN STR 25R TO STR 25L. REMOVED AND REPLACED SKIN PANEL PER SRM.SDR SWAA094417Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 1R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094416Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094004Light · inoperativeDURING SCHEDULED MV3 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA093524Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT 727C, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA093489Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727C, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA093225Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA092985Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 984, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA093017Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 984, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA092928Bracket · crackedDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD MOUNT CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA092378Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA092053Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED EMERGENCY LIGHT PER MM.SDR SWAA091684Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 470, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA090790Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 780, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA090789Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 790, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA090788Web · crackedDURING SCHEDULED MV2 CHECK, FOUND RT SIDE WEB CRACKED AT BS 259, WL 174. REPAIRED WEB PER SWA EA.SDR SWAA085881Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085883Ground Stud · defectiveDURING SCHEDULED 20Y CHECK, FOUND FIRST RT OVERHEAD EMERGENCY EXIT LIGHT INOP. REPLACED EXIT LIGHT ELECTRIC GROUND STUD PER SRM.SDR SWAA085828Battery · dischargedDURING SCHEDULED 20Y CHECK, FOUND AFT EMERGENCY EXIT FLASHLIGHT INOP. REMOVED AND REPLACED BATTERIES PER MM.SDR SWAA085848Battery · dischargedDURING SCHEDULED 20Y CHECK, FOUND FWD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERIES PER MM.SDR SWAA085820Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB PER AAR EA.SDR SWAA085819Tab · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT AILERON TAB CORRODED AT HINGE DOUBLER UPPER SURFACE. REMOVED AND REPLACED TAB PER MM.SDR SWAA085818Wedge · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING LEADING EDGE NR 3 SLAT I/B UPPER WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA085811Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING L/E NR 3 SLAT INBOARD UPPER WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA085680Light · not seatedDURING SCHEDULED 20Y CHECK, FOUND AFT RT OVERHEAD EMERGENCY EXIT LIGHT INOP. RESEATED LIGHT PER MM.SDR SWAA085679Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD BULKHEAD O/B STIFFENER CRACKED AT BS 663, RBL 6.15. REPLACED STIFFENER PER SRM.SDR SWAA085678Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND BULKHEAD CRACKED AT BS 1016, STR 6R. REPAIRED BULKHEAD PER AAR EA.SDR SWAA085677Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND BULKHEAD CRACKED AT BS 1016, STR 8R. REPAIRED BULKHEAD PER AAR EA.SDR SWAA085676Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085665Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND LT MAIN GEAR W/W FWD PRESSURE BULKHEAD CRACKED NEXT TO AILERON CONTROL SHAFT. REPAIRED WEB PER AAR EA.SDR SWAA085621Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085620Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT JUST ABOVE FWD END OF HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085619Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUOUT BELOW FWD END OF HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA085622Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING O/B FLAP, AFT FLAP DELAMINATED AT INBOARD END ALONG T/E. REPAIRED FLAP PER SRM.SDR SWAA085598Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 787, BETWEEN RBL 10 AND RBL 19. REPAIRED FRAME PER SRM.SDR SWAA085528Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, STR 16R. REPAIRED FRAME PER AAR EA.
Back to N339SW, cancelled Feb 16, 2018