N368SW, cancelled Mar 22, 2018
Service difficulty reports · 360
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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 SWA980654Floorbeam · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND CRACKED FLOORBEAM AT BS 787 RBL 14. REMOVED AND REPLACED PER BOEING SRM.SDR SWA980651Frame · crackedDURING SCHEDULED 1/2 D CHECK, FOUND CRACKED FWD GALLEY DOOR AT FWD LWR CORNER BS 294.5 AT Z-ANGLE. REPAIRED PER BOEING SRM.SDR SWA980650Web · damagedDURING SCHEDULED 1/2 D CHECK, FOUND DAMAGED WEB AT FWD SIDE OF DOOR CUT-OUT 8 UP FROM LOWER END. REPAIRED PER BOEING SRM.SDR SWA980649Frame · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORROED BELT FRAME LEG AT BS 500 C, RBL 3. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA970857Light · brokenDURING SCHEDULED C2 CHECK, FOUND FLOOR TRACK LIGHTS TAPED TO FLOOR AT AFT END OF CABIN. REMOVED AND REPLACED BROKEN LIGHT PER BOEING M/M.SDR SWAA970784Slide · low pressDURING SERVICE CHECK, FOUND R1 FLOOR SLIDE PRESSURE LOW. REPLACED PER BOEING M/M.SDR SWAA970087Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND RIGHT AFT SERVICE DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER BOEING M/M.SDR SWAA970086Skin · dentedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN DENTED AND OIL CANNING AT BS 196.5. REPAIRED PER BOEING SRM.SDR SWAA961416Ac Module · malfunctionedDIVERTED TO OAK DUE TO ELECTRICAL SMELL, NO SMOKE NOTED, EMITTING FROM F/O OVERHEAD AREA. LANDED WITHOUT INCIDENT. INSPECTED P5 OVERHEAD PANEL AREA. REPLACED AC MODULE PER BOEING M/M.SDR SWAA950420Eel Wires · damagedDURING SCHEDULED C1 CHECK, FOUND 2 FLOOR TRACK LIGHTS INOP AT AFT SECTION OF CABIN. REPAIRED AND RECONNECTED TWO WIRES PER BOEING MM.
Back to N368SW, cancelled Mar 22, 2018