N613SW, cancelled Jan 2, 2019
Service difficulty reports · 268
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 = 'N613SW' AND deregistration_id = 'N613SW-2019-01-02' 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 = 'N613SW' AND deregistration_id = 'N613SW-2019-01-02' 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 SWAA030111Slide · out of adjustDURING SCHEDULED BC1 CHECK, FOUND R2 DOOR ESCAPE SLIDE OUT OF ADJUSTMENT. ADJUSTED ESCAPE SLIDE PER MM.SDR SWAA021356Sign · looseFWD ENTRY DOOR EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA020371Bulkhead · damagedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB HAS A HOLE AT BS 178, WL 183 AND RBL 17.1. REMOVED AND REPLACED WEB PER SWA ACO.SDR SWAA020370Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND RT CHORD CRACKED AT BS 178, WL 207 AND RBL 34.5. REPAIRED CHORD PER SWA ACO.SDR SWAA013382Slide · out of adjDURING SCHEDULED C1 CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE ASSY PER MM.SDR SWAA013040Engine · overtemp(AIR TURNBACK) DURING CLIMB NR 1 ENG HAD 2 HIGH EGT INDICATIONS, (1100 DEGS & 950 DEGS), FOLLOWED BY ANOTHER HIGH EGT DURING APPROACH (950 DEG). REMOVED AND REPLACED NR 1 ENG PER MM.SDR SWAA011999Transmission · failedDURING SCHEDULED SPECIAL VISIT CHECK DUE TO NR 3 T/E FLAP TRANSMISSION FAILURE, (MX FERRY TO DAL). REMOVED AND REPLACED LT INBD AFT FLAP, LT INBD FORE FLAP. REMOVED AND REPLACED LT WING BODY FAIRING, REMOVED AND REPLACED CRACKED LT INBD MID FLAP FAIRING ATTASDR SWAA011998Transmission · inoperativeDURING APPROACH FLAPS WOULD NOT PASS 2.1 POSITION. FOUND NR 3 T/E FLAP TRANSMISSION INOP ALONG WITH DAMAGE TO AFT LT WING BODY FAIRING, NR 4 FLAP TRACK ATTACH CASTING, INBOARD MID FLAP FAIRING. REMOVED AND REPLACED NR 3 FLAP TRANSMISSION, NR 4 FLAP TRACK ATTSDR SWAA001712Battery · inoperativeDURING SCHEDULED 1/2D CHECK, FOUND AISLE EMERGENCY EXIT LIGHT INOP BETWEEN BS 430 - 500. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA001647Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR AFT FRAME CRACKED AT NR 3 STOP. REPAIRED FRAME PER TI-152-003.SDR SWAA001646Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CORRODED, BS 827 TO BS 847. REPAIRED CREASE BEAM SECTION PER SRM.SDR SWAA001639Angle · crackedDURING SCHEDULED 1/2D CHECK, FOUND ANGLES CRACKED, BS 292, STRINGER 12R AND BS 294, STRINGER 9R. REMOVED AND REPLACED ANGLES PER SRM.SDR SWAA001638Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 328 FLOORBEAM CORRODED AROUND NUT PLATE, RBL 42. REPAIRED BEAM PER TI-553-048.SDR SWAA000684Switch · out of adjAIR TURNBACK, AFT CARGO DOOR LIGHT ILUMMINATED ON TAKEOFF. VERIFIED DOOR CLOSED AND DEFERRED PER MEL. LATER ON AT BWI ADJUSTED DOOR POSITION SWITCH PER MM.SDR SWAA000639Slide · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD SERVICE DOOR EVACUATION SLIDE PRESSURE INDICATOR LOW. R&R SLIDE ASSY PER MM.SDR SWAA991357Sensor Cable · out of adjustAIR TURNBACK, GEAR HANDLE WOULD NOT COME UP AFTER TAKEOFF. RIGGED MLG GROUND SHIFT SENSOR CABLE ASSY PER MM.SDR SWAA982833Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FLOOR TRACK LIGHTING INOPERATIVE. REMOVED AND REPLACED CTR FLOOR TRACK LIGHTING BATTERY PACK AND POWER SUPPLY, OPS CHECK GOOD PER BOEING MM.SDR SWAA982738Engine · fodON TAKEOFF ROLL, PLASTIC BAG REPORTED INGESTED INTO NR 2 ENG. BEGAN ABORTED T/O AT 30 KTS INTO 20 KT HW. PERFORMED BIRD STRIKE INSPECTION PER BOEING MM. NO DAMAGED NOTED. INSPECTED NR 2 ENGINE FOR FOD, NONE FOUND AND NO DAMAGE.
Back to N613SW, cancelled Jan 2, 2019