N314SW, cancelled May 18, 2012
Service difficulty reports · 412
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 = 'N314SW' AND deregistration_id = 'N314SW-2012-05-18' 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 = 'N314SW' AND deregistration_id = 'N314SW-2012-05-18' 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 SWAA072188Bolt · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 2 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA072190Bolt · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 1 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA072189Bolt · wornDURING SCHEDULED 10Y CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 3 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA072187Bolt · wornDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 4 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA072186Bolt · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 4 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA072185Bolt · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 2 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA072184Bolt · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. R&R NR 1 HINGE BUSHING AND BOLT PER SWA EA.SDR SWAA071422Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA071421Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 264, STR 14R. REPAIRED SKIN PER SWA EA.SDR SWAA071423Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 955, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA071424Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA070217Hook · looseDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. SECURED AFT GIRT BAR HOOK PER MM.SDR SWAA063704Bolt · wornDURING SCHEDULED C2 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE BOLT AND BUSHING PER MM.SDR SWAA063172Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT INOP AT ROW 17 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063171Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT INOP AT ROW 6 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063012Controller · faultyL1 COCKPIT WINDOW SHATTERED AND ARCHED, REMOVED HEAT, ARCHING STOPPED. REMOVED AND REPLACED L1 WINDOW AND HEAT CONTROLLER PER MM.SDR SWAA062707Flashlight · inoperativeAFT EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA061776Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 294, STR 11L TO STR 12L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA061775Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 5L TO STR 14L. REMOVED AND REPLACED STRINGER SPLICE PER EA.SDR SWAA061442Lens · missingDURING SCHEDULED PM CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT LENS MISSING AT ROW 12 ABC. INSTALLED LIGHT LENS PER MM.SDR SWAA061143Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND CABIN EMERGENCY EXIT LIGHT BATTERY PACK INOP. R&R BATTERY PACK PER MM.SDR SWAA060686Battery Pack · inoperativeDURING SCHEDULED SPECIAL VISIT, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA060685Stiffener · bulgedDURING SCHEDULED C4 CHECK, FOUND BS 1016 AFT PRESS BULKHEAD RADIAL STIFFENER BULGED AT STR 9R. MX FERRY TO DHN FOR REPAIRS. REPAIRED RADIAL STIFFENER PER SRM.SDR SWAA060684Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 450, BL 0, NR 4 RADIO ALTIMETER ANTENNA CUTOUT. MX FERRY TO DHN FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060683Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 430, BL 0, NR 3 RADIO ALTIMETER ANTENNA CUTOUT. MX FERRY TO DHN FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060682Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 410, BL 0, NR 2 RADIO ALTIMETER ANTENNA CUTOUT. MX FERRY TO DHN FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060681Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 390, BL 0, NR 1 RADIO ALTIMETER ANTENNA CUTOUT. MX FERRY TO DHN FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060680Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 912, STR 4R. MX FERRY TO DHN FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060679Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19L. MX FERRY TO DHN FOR REPAIRS. REPAIRED SKIN PER SRM.SDR SWAA060603Bulb · inoperativeDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 8 DEF. RELAMPED LIGHT PER MM.SDR SWAA060345Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515D, STR 16R. MX FERRY TO DALLAS FOR REPAIRS. REPAIRED SKIN PER SWA EA.SDR SWAA060001Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 434, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA054077Attach Bracket · looseL2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA054076Slide · dislodgedR1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA053554Ski · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING NR 6 SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA053553Skin · crackedDURING SCHEDULED C3 CHECK, FOUND NR 2 L/E SLAT OUTBOARD LOWER SKIN CRACKED. REPAIRED SLAT PER SWA EA.SDR SWAA053552Bushing · wornDURING SCHEDULED C3 CHECK, LT & RT ELEVATOR TABS FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED LT & RT ELEVATOR TABS NR 1 HINGE BUSHINGS & HARDWARE PER MM.SDR SWAA052225Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE CRACKS AT BS 792 AND BS 812, STR 18L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA052152Lens · missingLT OVERWING EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA051832Floor Panel · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FLOOR WEB CRACKS BETWEEN BS 188 TO BS 197, LT & RT SIDE, WL 208. REPAIRED FLOOR WEB PER SRM.SDR SWAA051831Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE STUB FRAMES CRACKED AT BS 188, LT & RT SIDE, WL 208. REMOVED AND REPLACED STUB FRAMES PER SRM.SDR SWAA051830Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 400, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA051829Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 727A, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA051828Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051827Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT VERTICAL STAB FWD & AFT FAILSAFE CLEVIS LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA051820Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, LBL 17, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA051819Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 967, LBL 8, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA051818Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 767, BL 0 TO RBL 5, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA051817Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 747, RBL 16 TO RBL 20, WL 148. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051816Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 747, LBL 5 TO RBL 5, WL 148. REMOVED AND REPLACED SHEAR TIE PER SRM.
Back to N314SW, cancelled May 18, 2012