N689SW, cancelled Mar 16, 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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-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 = 'N689SW' AND deregistration_id = 'N689SW-2018-03-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 SWAA982986Card · failedRETURNED TO TPA DUE TO AFTER GEAR RETRACTION NOSE WHEEL RED AND GREEN LIGHTS REMAINED ON WITH HANDLE UP. WITH HANDLE OFF NOSE WHEEL WAS GREEN, MAIN GEAR WENT NORMALLY UP AND LOCKED. REMOVED AND REPLACED M983 CARD, JACKED NOSE OF AIRCRAFT, CYCLED NOSE GEAR SSDR SWAA982165Oil Syst · reqd serviceDIVERSION DUE TO NR 1 ENGINE OIL QUANTITY IS LOW, NEEDS SERVICING. AIRCRAFT MADE AN UNEVENTFUL LANDING. RAN NR 1 ENG. INSPECTED FOR OIL LEAKS, NO LEAKS NOTED. (LP 187371)SDR SWAA980804Web · damagedDURING SCHEDULED C3 CHECK, FOUND WEB DAMAGE JUST FWD OF AFT SERVICE DOOR FRAME AT BS 950. REPAIRED PER BOEING SRM.SDR SWAA980724Seal · failedFLT LEVEL 350, CABIN ALT WARNING HORN SOUNDED WOULD NOT HOLD PRESSURE IN AUTO/STBY OR MANUAL WITH OUTFLOW VALVE SULL CLOSE, DESCENDED TO FLT LEVEL 240 AND STILL WOULD NOT HOLD CABIN PRESSURE. WENT TO HIGH ON PACKS, REGAINED PRESSURIZATION, PRESSURE WOULD HOLDSDR SWAA970953Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND A CRACK IN FUSELAGE SKIN AT BS 727B+16 BETWEEN S21 AND 22R. REPAIRED PER BOEING SRM.SDR SWAA970516Battery · dischargedDURING SCHEDULED BC3 CHECK, FOUND EMERGENCY EXIT LIGHTS INOP AT ROWS 7, 8 AND 9. REMOVED AND REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA970175Floorbeam · crackedDURING SCHEDULED 1/2 D CHECK, FOUND FLOOR BEAM CRACKED ON UPPER FLANGE OF WEB .5 INCH AFT OF BS 1006, LBL 2.5. REPAIRED PER BOEING SRM.SDR SWAA970174Shear Tie · crackedDURING SCHEDULED 1/2 D CHECK, FOUND STRINGER 22L SHEAR TIE CRACKED BS 295. REPLACED PER BOEING SRM.SDR SWAA960937Keel Beam · crackedDURING SCHEDULED BC4 CHECK, FOUND LOWER FUSELAGE KEEL BEAM FIXED PANEL CRACKED AT I/B RT ROW OF FASTENERS. REPAIRED PER SWA RA 1-A53-1273.SDR SWAA960314Battery Pack · dischargedDURING SCHEDULED A2 CHECK, FOUND OVERWING EXIT LIGHT INOP. REPLACED BATTERY PACK PER BOEING M/M.
Back to N689SW, cancelled Mar 16, 2018