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 SWAA111317Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 987, STR 7L. REPAIRED SKIN PER SRM.SDR SWAA107882Fuse · inoperativeNO L/E DEVICES DURING LANDING CONFIGURATION. REMOVED AND REPLACED BOTH L/E DEVICES HYD FUSES PER MM.SDR SWAA107676Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT INBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA107675Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LT INBOARD FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA107179Window · arcedR1 COCKPIT WINDOW ARCED. REMOVED AND REPLACED R1 WINDOW PER MM.SDR SWAA106451Skin · crackedDURING SCHEDULED OTS CHECK, FOUND NOSE WHEEL WELL SKIN CRACKED AT BS 277. REPAIRED SKIN PER EA.SDR SWAA106457Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA106357Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND AFT CARGO DOOR FUSELAGE SKIN CRACKED AT BS 948.5, STR 15L. REPAIRED SKIN PER EA.SDR SWAA106356Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 948.5, STR 15L. REPAIRED SKIN PER EA.SDR SWAA104579Bulkhead · crackedDURING SCHEDULED MV2 CHECK, FOUND NOSE WHEEL WELL LT FWD BULKHEAD PRESSURE DECK CRACKED. REPAIRED BULKHEAD PER EA.SDR SWAA103865Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 960, STR 5R. REPAIRED SKIN PER SRM.SDR SWAA103503Wire · arcedR2 COCKPIT WINDOW INTERNAL WIRING ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA102069Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 3 SLAT LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA101693Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 908.9, STR 4L. REPAIRED SKIN PER EA.SDR SWAA097266Slide · out of positionR2 DOOR EVAC SLIDE PULL HANDLE OUT OF POSITION. REINSTALLED SLIDE PER MM.SDR SWAA096655Actuator · faultyAFTER TAKEOFF, RETRACTED GEAR, RT MLG RED LIGHT REMAINED ILLUMINATED. RECYCLED GEAR TO DOWN, ALL NORMAL WITH 3 GREEN, RETRACTED GEAR STILL WITH RT MLG RED LIGHT. GEAR DID RETRACT WITH GEAR HANDLE IN "OFF", RT MLG EXTENDED IN UP, ALL GEAR RETRACTED. REMOVEDSDR SWAA093859Lens · looseDURING SCHEDULED 24Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 17. SECURED LENS PER MM.SDR SWAA093689Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED BETWEEN BS 685 TO BS 706, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA093652Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 25. REPAIRED BEAM PER EA.SDR SWAA093625Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER SRM.SDR SWAA093455Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, AT LBL 45.5. REPAIRED BEAM PER AAR EA.SDR SWAA093411Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED BETWEEN BS 685 TO BS 706, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA093255Slat · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING O/B LE NR 6 SLAT DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA093254Slat · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 3 SLAT I/B SIDE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA093195Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 20L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA093193Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CHORD CORRODED AT BS 727, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA093111Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 987, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA092926Wedge · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING O/B LEADING EDGE NR 5 SLAT AFT WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA092925Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 986, STR 20R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA091554Relay · faultyDECLARED EMERGENCY, NOSE GEAR UNSAFE INDICATION WHILE ON APPROACH TO HOU. RECYCLED NO CHANGE. EMERGENCY DECLARED, LANDING UNEVENTFUL. NO GEAR HORN. REMOVED AND REPLACED R374 RELAY PER MM.SDR SWAA091413Light · inoperativeDURING SCHEDULED HC2 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 16. REPAIRED LIGHT PER MM.SDR SWAA091412Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 277, STR 14L. REPAIRED SKIN PER SWA EA.SDR SWAA091356Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 375, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA091218Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT INOP AT ROW 16. RELAMPED PER MM.SDR SWAA085506Slide · unserviceableFOUND R1 DOOR ESCAPE SLIDE PRESSURE GAUGE OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA084656Rod End · wornDURING SCHEDULED CV CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR CONTROL ROD ENDS PER SWA EA.SDR SWAA084627Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD SERVICE DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA084429Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT, BS 304, WL 234 TO WL 261. REPAIRED SKIN PER SRM & ER.SDR SWAA084428Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 26R. REPAIRED PER SRM & ER.SDR SWAA084362Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 16R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084253Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA084171Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084138Shear Tie · corrodedDURING SCHEDULED PAE CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084137Stringer Clip · crackedDURING SCHEDULED PAE CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084136Frame · crackedDURING SCHEDULED PAE CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 259, STR 11R. REPAIRED FRAME PER SRM.SDR SWAA084108Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 259, STR 11R. REPAIRED FRAME PER SRM.SDR SWAA084109Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 22L. R&R STRINGER CLIP PER SRM.SDR SWAA084062Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 727, STR 21R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA084014Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 23R CORRODED AT BS 360. REPAIRED STRINGER PER SRM.SDR SWAA083965Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 13R. REPAIRED FRAME PER SWA EA.
Back to N314SW, cancelled May 18, 2012