N670SW, cancelled Jan 8, 2022
Service difficulty reports · 454
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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-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 = 'N670SW' AND deregistration_id = 'N670SW-2022-01-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 SWAA112565Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 907+2, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA112144Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 822 TO BS 825, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA112130Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FRAME WEB CRACKED AT BS 500D, RBL 7. REPAIRED FRAME PER EA.SDR SWAA112127Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 767-787, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA111999Shear Tie · corrodedDURING SCHEDULED OTS CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 28L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA111998Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 500, RBL 6.50. REPAIRED SKIN PER EA.SDR SWAA111997Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 504D, STR 16R. REPAIRED SKIN PER EA.SDR SWAA111942Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 803, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA111941Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND RT EEPLS INOP BETWEEN ROW 1 TO ROW 8. RELAMPED PER MM.SDR SWAA111545Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 822 TO BS 825, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA107996Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 928+12, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA107995Slide · out of adjustL1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA107793Angle · crackedDURING SCHEDULED SPV CHECK, FOUND RT MAIN WHEEL WELL VERTICAL "L" ANGLE CRACKED AT BS 663, RBL 6.1. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA107792Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 178.5, RBL 5.7. REPAIRED WEB PER ER AND EA.SDR SWAA105990Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA104540Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 404 TO BS 406.5, STR 26L. REPAIRED SKIN PER EA.SDR SWAA104539Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 412.5 TO BS 417, STR 26L. REPAIRED SKIN PER EA.SDR SWAA103192Web · crackedDURING SCHEDULED 2HC2 CHECK, FOUND NLG WHEEL WELL LT SIDE PANEL WEB CRACKED AT BS 243.7. REPAIRED WEB PER EA AND BAC DWG.SDR SWAA103041Gasper Fan · faultyFUMES REPORTED AT ROWS 15 TO 17. TURNED OFF RIGHT A/C PACK AND RECIRC FANS. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA102401Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 907 AT STR 14R. REPAIRED SKIN PER EO AEM.SDR SWAA102371Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 666, RBL 24.5. REPAIRED BEAM PER AEM.SDR SWAA102137Bracket · corrodedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FLOOR BRACKETS CORRODED. REMOVED AND REPLACED BRACKETS PER MMK.SDR SWAA102136Battery Pack · dischargedDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY EXIT LIGHT BATTERY INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA102127Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 19R & 20R. REPAIRED FRAME PER SRM & EO.SDR SWAA102126Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR FWD FRAME CRACKED AT BS 329. REMOVED AND REPLACED R1 DOOR FRAME PER SRM & BAC DRAWING.SDR SWAA102125Structure · corrodedDURING SCHEDULED 22Y CHECK, FOUND UPPER CHORD CORRODED AT BS 227.8, LBL 7 TO RBL 23. REPAIRED UPPER CHORD PER EO.SDR SWAA102114Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 277 RT SIDE. REPAIRED FRAME PER EO.SDR SWAA102113Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 L/E SLAT DELAMINATED AT UPPER SURFACE. REPAIRED SLAT PER SRM.SDR SWAA102100Lens · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT GALLEY EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA102099Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND AFT EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA102098Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND FWD EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA102097Lens · missingDURING SCHEDULED 22Y CHECK, FOUND LT DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA102096Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA102086Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND RT WING I/B NR 6 SLAT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA102051Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP LOWER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA102050Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING FORE FLAP UPPER SURFACE DELAMINATED BETWEEN WBL 153 TO WBL 156. REPAIRED FORE FLAP PER SRM.SDR SWAA102049Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING I/B FORE FLAP LOWER SURFACE DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA102048Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 6 SLAT SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA102042Support · corrodedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT Z CORRODED ON LOWER SILL AT LBL 66.5 L1 DOOR. REMOVED AND REPLACED SUPPORT Z PER SRM.SDR SWAA102022Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP SKIN DELAMINATED BETWEEN WBL 132 TO WBL 136. REPAIRED FORE FLAP PER SRM.SDR SWAA101969Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 296, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA101968Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED AT BS 312, BBL 0. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA101833Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING T/E INBOARD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA101747Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME LOCATED AT BS 1016 FWD FACE AFT PRESSURE BULKHEAD CRACKED. REPAIRED FRAME PER SRM.SDR SWAA101809Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101808Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101807Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101806Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 14L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101415Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LAMP PER MM.SDR SWAA101289Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.
Back to N670SW, cancelled Jan 8, 2022