N335SW, cancelled Jan 3, 2018
Service difficulty reports · 389
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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 SWAA981063Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED BS 178, WL 207 LBL 55, 178 BULKHEAD SIDE CHORD, BS 178 WL 207, RBL 55, 178 BULKHEAD SIDE CHORD AND BS 178 BULKHEAD, LBL 1, WL 185 HAS 1 CRACKED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980997Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED WEB AT BS 315, RBL 60, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980996Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED FLOORBEAM AT BS 312, LBL 10 TO 12, RBL 10 TO 12, LBL 21. REPAIRED PER BOEING SRM.SDR SWAA980995Stiffener · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED VERTICAL STIFFENER AT BS 328 FLOORBEAM (FWD SIDE), RBL 35, WL 20. REPAIRED PER BOEING SRM.SDR SWAA980994Strap · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED STRAP AT BS 1015 TO 1030, LBL 3 WL 208. REPAIRED PER BOEING SRM.SDR SWAA980992Web · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED WEB AT BS 500 TO 500A, RBL 6.5, WL 147. REPAIRED PER BOEING SRM.SDR SWAA980973Angle · wornDURING SCHEDULED D-CHECK, FOUND LT FUSELAGE TO VERTICAL STAB SKATE ANGLE IS WORN. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980969Bulkhead Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACK INDICATIONS AT BS 178 BULKHEAD WEB WL 197.3 TO 201.9, LBL 4.7. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980967Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED L ANGLE BETWEEN BS 380 AND 400, BL 0, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980966Skin · crackedDURING SCHEDULED D CHECK, FOUND CRACKED NR 4 SLAT ON LOWER SKIN, O/B OF PUSHROD SITTING. REPAIRED PER TRAMCO EO NR 98-0440.SDR SWAA980965Angle · crackedDURING SCHEDULED D CHECK, FOUND LT HORIZ STAB WEB AT HSS 175.5 HAS CRACKED L ANGLE STIFFENER APPROX 30 AFT OF FRONT SPAR. REPAIRED PER BOEING SRM.SDR SWAA980964Skin · dentedDURING SCHEDULED D CHECK, FOUND NR 7 SPOILER UPPER SURFACE HAS 2 DENT 14 FROM I/B END 5 FROM T/E. REPAIRED PER BOEING SRM.SDR SWAA980963Angle · crackedDURING SCHEDULED D CHECK, FOUND CRACKED ANGLE AT BS 328, WL 200-207, LBL 45, FORWARD SIDE OF FLOORBEAM AND AT BS 328, WL 200-207, LBL 45 AFT SIDE OF FLOORBEAM. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980962Tip · crackedDURING SCHEDULED D CHECK, FOUND RT HORIZONTAL STAB TIP HAS 2 CRACK INTERNAL AND EXTERNAL SURFACES 4 FROM L/E AT LOWER EDGE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980961Support · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 983, LBL 18, WL 208. REMOVED AND REPLACED PER BOEING MM.SDR SWAA980960Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 986, LBL 4-43, WL 208 AROUND FASTENER HOLES UPPER AND LOWER SIDES. REMOVED AND REPLACED PER BOEING MM.SDR SWAA980959Stop Pads · wornDURING SCHEDULED D CHECK, FOUND LEFT AND RIGHT EMERGENCY EXIT HATCH STOP PADS WORN 6 EACH. REMOVED AND REPLACED PER BOEING MM.SDR SWAA980958Skin · dentedDURING SCHEDULED D CHECK, FOUND DENTED FUSELAGE SKIN AT BS 500A+12 STR 23L. REPAIRED PER BOEING SRM.SDR SWAA980957Support · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED AFT CARGO FLOOR SUPPORT ANGLE UPPER SURFACE IN SEVERAL AREAS, AT BS 947, LBL 21 TO RBL 21, WL 179. REPAIRED PER BOEING SRM.SDR SWAA980950Skin · dentedDURING SCHEDULED D CHECK, FOUND DENTED FUSELAGE SKIN, AT BS 500A +1 BETWEEN STRINGERS 21R AND 22R. REPAIRED PER BOEING SRM.SDR SWAA980940Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AROUND NUTPLATE AT BS 986 RBL 43, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980939Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORRODED FLOORBEAM AT BS 986 RBL 26-BL 0 WL 208 AROUND FASTENER HOLES UPPER AND LOWER SIDE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980938Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED WEB AT BS 180 WL 208, RBL 24; BS 180, WL 208, LBL 24. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980937Bulkhead Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INDICATIONS NOTED AT BS 178 BULKHEAD WEB AT WL 209.7 TO 212.6 LBL 4.7; AND WL 209.5 TO 212.7 RBL 4.7. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980936Bulkhead Web · crackedDURING SCHEDULED D CHECK, FOUND CRACKED INDICATIONS NOTED AT BS 178 BULKHEAD WEB AT WL 209.3 TO 212.7 LBL 6.7; AND BS 178 WL 212 TO 212.9 RBL 6.7. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980500Stringer · crackedDURING SCHEDULED BC3 CHECK, FOUND STRINGER 18A IN RT W/W CRACKED. REPAIRED PER ACO 1-353-1800.SDR SWAA980374Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE CRACKED AT BS 881 TO 885 BETWEEN STR 24R AND 25R. REPAIRED PER BOEING SRM.SDR SWAA980052Card · failedAFTER TAKEOFF, AND NORMAL GEAR RETRACTION, GEAR HANDLE CENTERED. GEAR EXTENDED WITH BOTH RED AND GREEN LIGHTS. RAISED HANDLE, GEAR RETRACTED, BUT RED UNSAFE LIGHTS REMAINED ON. GEAR WAS AGAIN EXTENDED AND RETRACTED BUT TOOK EXCESSIVE AMOUNT OF TIME TO RETRSDR SWAA980020Skin · crackedDURING SCHEDULED BC1 CHECK, FOUND A 1.5 FUSELAGE SKIN CRACK AT E&E COOLIN AND DUCT CUTOUT. REPAIRED PER BOEING SRM.SDR SWAA980019Skin · crackedDURING SCHEDULED BC1 CHECK, FOUND A 4 FUSELAGE SKIN CRACK 4 FWD OF OS BS 747, S26R. REPAIRED PER BOEING SRM.SDR SWAA980018Strap · crackedDURING SCHEDULED BC1 CHECK, FOUND FLOORBEAM SUPPORT STRAP CRACKED AT BS 312, AT BL 0 AND RBL 33 AND 46. REPAIRED PER BOEING SRM.SDR SWAA970840Skin · crackedDURING RON, FOUND CRACK AT AFT SERVICE DOOR LOWER HINGE CUTOUT, UNDER PRODUCTION MOD DOUBLER. REPAIRED PER BOEING SRM.SDR SWAA970845Skin · crackedDURING SCHEDULED TERMINAL CHECK, FOUND FUSELAGE SKIN CRACK AT BS 847, S28R. REPAIRED PER BOEING SRM.SDR SWAA970450Skin · crackedDURING SCHEDULED BC2 CHECK, FOUND A 3.25 INCH FUSELAGE SKIN CRACK AT BS 762, ABOVE S26R. REPAIRED PER BOEING SRM.SDR SWAA970353Connector · loosePRECAUTIONARY SHUTDOWN OF NUMBER 2 ENGINE, DUE TO OIL QUANTITY AND PRESSURE INDICATION FLUCTUATIONS. AIRCRAFT LANDED WITHOUT INCIDENT. INSPECTED AND DISCOVERED ENGINE OIL QUANTITY WAS NORMAL AND NO LEAKS WERE NOTED. REPLACED OIL QUANTITY TRANSMITTER CANNON SDR SWAA970284Connector · looseEXPERIENCED NUMBER 2 ENGINE LOW OIL QUANTITY INDICATION. CREW PERFORMED ENGINE SHUTDOWN PROCEDURES. AIRCRAFT DIVERTED AND LANDED IN RNO WITHOUT INCIDENT. INSPECTED AND FOUND ENGINE OIL QUANTITY NORMAL. CLEANED AND RESEATED OIL PRESSURE TRANSMITTER CANNON PSDR SWAA961243Light · inoperativeDURING SCHEDULED BC4 CHECK, FOUND EMERGENCY EXIT LIGHT AT ROW 22R INOP. REPLACED LIGHT ASSEMBLY PER BOEING M/M.SDR SWAA95289Eel Wire · brokenFIFTEEN MINUTES BEFORE PUSHBACK, EMERGENCY LIGHTS ILLUMINATED WITH NORMAL AIRCRAFT POWER APPLIED AND SWITCH IN ARMED POSITION. INSPECTED AND REPAIRED WIRE ON AFT GALLEY EMERGENCY LIGHT SWITCH PER BOEING MM.SDR SWAA950249Eel Ballast · inopDURING SCHEDULED SERVICE CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHTS INOP. REPLACED LIGHT BALLAST ASSEMBLY PER BOEING M/M.
Back to N335SW, cancelled Jan 3, 2018