N312SW, cancelled Oct 31, 2011
Service difficulty reports · 320
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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 SWAA000839Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 663 BULKHEAD CRACKED, LBL 32. REPAIRED WEB PER TRM TI-353-046.SDR SWAA000822Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD SERVICE DOOR AFT FRAME CRACKED AT 3RD DOOR STOP. REPAIRED FRAME PER T1-152-003.SDR SWAA000169Line · crackedNOSE WHEEL STEERING INOP AFTER LANDING. FOUND WATER LEAK FROM CRACKED FWD LAV DRAIN LINE FREEZING NLG STEERING PULLEYS. REMOVED AND REPLACED DRAIN LINE, CLEANED BELLY INTERIOR. LEAK AND OPS CK GOOD PER MM.SDR SWAA000129Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND BULL NOSE EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK AND CHARGER PER MM.SDR SWAA991582Light · inopAFT LOWER EMERGENCY FLASHLIGHT BLINKER INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA991471Skin · crackedDURING WALK ARROUND INSPECTION, FOUND APPROX A 8 INCH LONG CRACK ON FUSELAGE CROWN 4 FEET FWD OF ANTI COLLITION LIGHT. REPAIRED SKIN PER SRM.SDR SWAA991380Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED, BS 510, ABOVE STRINGER 11L. REPAIRED SKIN PER SRM.SDR SWAA990824Hook · looseAFT ENTRY DOOR EMERGENCY EVACUATION SLIDE GIRT BAR LATCH HOOK HAS BROKEN SCREW. REMOVED AND REPLACED LATCH HOOK ASSY PER MM.SDR SWAA983024Skin · crackedDURING SCHEDULED SC CHECK, FOUND FUSELAGE SKIN CRACKED 2.5 INCHES AT S19R, BS 770. REPAIRED PER BOEING SRM.SDR SWAA982699Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND BOTH OVERWING EMERGENCY HATCH DOOR LIGHTS ARE INOP. REMOVED AND REPLACED BATTERY PACK PER BOEING MM.SDR SWAA982517Battery Pack · dischargedDURING WALKAROUND CHECK, FOUND EMERGENCY TRACK LIGHTS WOULD NOT TURN-OFF WITH BATTERY POWER IN OFF AND EMERGENCY LIGHTS SWITCHED TURN IN OFF POSITION. REMOVED AND REPLACED FWD AND AFT FLOOR TRACK LIGHTING BATTERY PACKS PER BOEING MM.SDR SWAA981472Flight Controls · shimmyAIR RETURN, ON CLIMBOUT A/C STARTED TO SHAKE/SHIMMY AT 160-180 KTS. FLAPS DOWN. AT 210-250 KTS CLIMBING CONTINUE SHAKE/SHIMMY LEVEL FLIGHT (10K) 230-250 KTS NOT AS BAD DURING DESCENT. CLEAN 230-210 KTS, SHAKING NOT AS BAD AS LEVEL FLT. FLAPS 5 GEAR DOWN 170SDR SWAA980127Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE OUTER SKIN CRACKED AT LOWER HINGE RADIUS OF AFT SERVICE DOOR UNDER PRODUCTION LAP JOINT DOUBLER. REPAIRED PER BOEING SRM.SDR SWAA970976Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND RIGHT SIDE MID CABIN EMERGENCY EXIT LIGHT INOP \N\NREPLACED BATTERY PACK PER BOEING M/MSDR SWAA970617Battery Charger · inoperativeDURING RON CHECK, FOUND THAT CABIN EMERGENCY TRACK LIGHTS WOULD NOT DISARM. REPLACED AFT BATTERY CHARGER PER BOEING M/M.SDR SWAA970347Skin · crackedDURING SCHEDULED TERMINAL CHECK, FOUND A 3 INCH FUSELAGE SKIN CRACK AT BS 757, BELOW S19R. REPAIRED PER BOEING SRM.SDR SWAA960455Window Post · crackedDURING SCHEDULED BC1 CHECK, FOUND R1 AND L1 C-D COCKPIT WINDOW POSTS CRACKED. INSTALLED REPAIR PER SWA RA 1-A53-1156.SDR SWAA960234Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827 S9L AT FASTENER HOLE. REPAIRED PER BOEING SRM.SDR SWAA960233Floor Beam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR BEAM CORROSION AT BS 344 LBL 35 LBL 7.5 BL 0 AND RBL 1.5. REPAIRED PER BOEING SRM.SDR SWAA950705Floorbeam · crackedDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM STRAPS CRACKED AT RBL 32 AND AT LBL 12 BS 312 IN E AND E COMPARTMENT. REPAIRED PER BOEING SRM.
Back to N312SW, cancelled Oct 31, 2011